Results 1 to 6 of 6

Thread: SQLite server help?...

  1. #1
    Join Date
    Oct 2009
    Location
    Albuquerque, NM
    Posts
    263

    Question SQLite server help?...

    CAn anyone link me to documentation showing me how to setup and SQLite database server. I have a MySQL database server already, but would like to do the same with SQLite.

    Here's how my network looks:
    ---Server - openSuse 11.2 (192.168.0.100)
    --------VBox
    ------------Guest - openSuse 11.2 (Drupal Development) (192.168.56.103)
    ------------Guest - openSuse 11.2 (Drupal Production) (192.168.56.104)
    ------------Guest - openSuse 11.2 (MySQL Database) (192.168.56.105)
    ------------Guest - openSuse 11.2 (Sqlite Database) (192.168.56.105)

    So far I have not found documents for setting up a SQLite database and connecting to it in Drupal. So I hoping I could find some documents here I use as a quide.
    OpenSuse 12.1 (3.1.9-1.4) x64, 7.7GB RAM, GNOME 3.2.1
    Intel(R) Core(TM)2 Quad CPU Q9550 @ 2.83GHz VT x 4
    NVIDIA GeForce 9500 GT 256/512 MB

  2. #2

    Default Re: SQLite server help?...

    Quote Originally Posted by VcDeveloper1 View Post
    CAn anyone link me to documentation showing me how to setup and SQLite database server. I have a MySQL database server already, but would like to do the same with SQLite.

    Here's how my network looks:
    ---Server - openSuse 11.2 (192.168.0.100)
    --------VBox
    ------------Guest - openSuse 11.2 (Drupal Development) (192.168.56.103)
    ------------Guest - openSuse 11.2 (Drupal Production) (192.168.56.104)
    ------------Guest - openSuse 11.2 (MySQL Database) (192.168.56.105)
    ------------Guest - openSuse 11.2 (Sqlite Database) (192.168.56.105)

    So far I have not found documents for setting up a SQLite database and connecting to it in Drupal. So I hoping I could find some documents here I use as a quide.
    thats the joke about SQLite, it does not require a server. SQLite is a C library and PHP brings a wrapper add-on. i am not sure about drupal, but it might also work with PDO.

  3. #3
    Join Date
    Oct 2009
    Location
    Albuquerque, NM
    Posts
    263

    Unhappy Re: SQLite server help?...

    Yea, I just read this about SQLite in there documents over at there site:

    High-volume Websites
    SQLite will normally work fine as the database backend to a website. But if you website is so busy that you are thinking of splitting the database component off onto a separate machine, then you should definitely consider using an enterprise-class client/server database engine instead of SQLite

    So, I'm going to cancel this project. Because my site will start off with low volume but, I know it will be become high. And, I don't want my database on the same server as my web server.
    OpenSuse 12.1 (3.1.9-1.4) x64, 7.7GB RAM, GNOME 3.2.1
    Intel(R) Core(TM)2 Quad CPU Q9550 @ 2.83GHz VT x 4
    NVIDIA GeForce 9500 GT 256/512 MB

  4. #4
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: SQLite server help?...

    SQLite is not a server. It's a database contained in a set of files, and the library provides SQL functions to access the data. Hence the limitation on performance.

  5. #5
    Join Date
    Sep 2008
    Location
    Dubai
    Posts
    1,770

    Default Re: SQLite server help?...

    As already mentioned by others, SQlite is not suitable for Production quality applications unless you are going to use it as a small store for keeping little data such as configuration data etc.
    openSUSE 12.3 (x86_64) with Kernel 3.7.10-1.16-desktop and KDE 4.11.2 on MacBook Pro
    Latest MS Windows version used: Win95

  6. #6
    Join Date
    Oct 2009
    Location
    Albuquerque, NM
    Posts
    263

    Default Re: SQLite server help?...

    Thanks for the replies! I appreciate it!
    OpenSuse 12.1 (3.1.9-1.4) x64, 7.7GB RAM, GNOME 3.2.1
    Intel(R) Core(TM)2 Quad CPU Q9550 @ 2.83GHz VT x 4
    NVIDIA GeForce 9500 GT 256/512 MB

Tags for this Thread

Posting Permissions

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