Results 1 to 6 of 6

Thread: Interacting with SQL Databases?

  1. #1
    Join Date
    Aug 2018
    Posts
    17
    Mentioned
    0 Post(s)
    Quoted
    7 Post(s)

    Default Interacting with SQL Databases?

    Curious if anyone is aware of how to have Lape interact with a SQL Database. I'm wanting to build up a database for a script to store/retrieve information from but am unsure if and how to get the two to communicate. Has anyone accomplished this before or have any ideas on how?

  2. #2
    Join Date
    Nov 2011
    Location
    England
    Posts
    3,072
    Mentioned
    296 Post(s)
    Quoted
    1094 Post(s)

    Default

    Simba a long time ago used to have MySQL interface built into it. Though I would not be against bringing this back if it was dynamic linked.

    But currently most people use just post to a php webpage which handles the mysql interface.

  3. #3
    Join Date
    Aug 2018
    Posts
    17
    Mentioned
    0 Post(s)
    Quoted
    7 Post(s)

    Default

    Appreciate the response! I'll have to look into php!

  4. #4
    Join Date
    Sep 2008
    Location
    Not here.
    Posts
    5,422
    Mentioned
    13 Post(s)
    Quoted
    242 Post(s)

    Default

    The most typical way clients(in this case a script running on simba) interact with databases is thru some sort of backend api. The backend could be written in any language, and there are so many examples out there. A specific search on google, such as "using *insert web framework* with *insert database type* database". Example: "using Flask(python framework) with sql database"

  5. #5
    Join Date
    Feb 2011
    Location
    The Future.
    Posts
    5,600
    Mentioned
    396 Post(s)
    Quoted
    1598 Post(s)

    Default

    https://villavu.com/forum/showthread.php?t=116462

    SQLite.. No support for MySQL or other types.
    I am Ggzz..
    Hackintosher

  6. #6
    Join Date
    Nov 2018
    Posts
    2
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default

    You can either build or write an API to handle HTTP post/get requests and store the information inside a file format of your choosing (JSON, XML, SQLITE(.db), etc.).

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •