• GoDaddy Community
  • Websites + Marketing | Website Builders
  • Websites + Marketing | Website Builders

    cancel
    Showing results for 
    Show  only  | Search instead for 
    Did you mean: 
    Go to solution

    PHP and sqlite

    Is it possible to use php with sqlite on godaddy? sqlite is my prefered verison of sql but although I have a test page working on my local test server, it just renders the php code as output on site:

     

    http://www.ilfracomberunningclub.co.uk/runners-2.html

     

    Anyone any ideas?

     

     

    3 REPLIES 3
    Helper II
    Helper II

    Re: PHP and sqlite

     

    Have you read here https://documentation.cpanel.net/display/68Docs/MySQL+Databases#  ?

     

    this might answer your question ? hopefully 

     

     

    Re: PHP and sqlite

    Thanks, but I know using MySQL is okay with GoDaddy, I'd just prefer to use sqlite as I find it easier (it's one file for a start), so was wondering if it was possible with php?

    Helper II
    Helper II
    Solution

    Re: PHP and sqlite

    HI   peter_addison 

     

     

    Although I have not used sqlite,  and it sounds like its a local machine database,  similar to ngrok and xampp.

     

    Here is what I got out of this link here https://www.sqlite.org/whentouse.html

     

    • Stand-in for an enterprise database during demos or testing

      Client applications typically use a generic database interface that allows connections to various SQL database engines. It makes good sense to include SQLite in the mix of supported databases and to statically link the SQLite engine in with the client. That way the client program can be used standalone with an SQLite data file for testing or for demonstrations.

    Client/Server Applications

     

    If there are many client programs sending SQL to the same database over a network, then use a client/server database engine instead of SQLite. SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great. Also, file locking logic is buggy in many network filesystem implementations (on both Unix and Windows). If file locking does not work correctly, two or more clients might try to modify the same part of the same database at the same time, resulting in corruption. Because this problem results from bugs in the underlying filesystem implementation, there is nothing SQLite can do to prevent it.

    A good rule of thumb is to avoid using SQLite in situations where the same database will be accessed directly (without an intervening application server) and simultaneously from many computers over a network.