1 

     2 SQLITE REQUIREMENTS

     3 -------------------

     4 

     5 To use SQLite with your Drupal installation, the following requirements must be

     6 met: Server has PHP 5.2 or later with PDO, and the PDO SQLite driver must be

     7 enabled.

     8 

     9 SQLITE DATABASE CREATION

    10 ------------------------

    11 

    12 The Drupal installer will create the SQLite database for you. The only

    13 requirement is that the installer must have write permissions to the directory

    14 where the database file resides. This directory (not just the database file) also

    15 has to remain writeable by the web server going forward for SQLite to continue to

    16 be able to operate.

    17 

    18 On the "Database configuration" form in the "Database file" field, you must

    19 supply the exact path to where you wish your database file to reside. It is

    20 strongly suggested that you choose a path that is outside of the webroot, yet

    21 ensure that the directory is writeable by the web server.

    22 

    23 If you must place your database file in your webroot, you could try using the

    24 following in your "Database file" field:

    25 

    26   sites/default/files/.ht.sqlite

    27 

    28 Note: The .ht in the name will tell Apache to prevent the database from being

    29 downloaded. Please check that the file is, indeed, protected by your webserver.

    30 If not, please consult the documentation of your webserver on how to protect a

    31 file from downloading.