SQLITE REQUIREMENTS
-------------------

To use SQLite with your Drupal installation, the following requirements must be
met: Server has PHP 5.6 or later with PDO, and the PDO SQLite driver must be
enabled.

SQLITE DATABASE CREATION
------------------------

The Drupal installer will create the SQLite database for you. The only
requirement is that the installer must have write permissions to the directory
where the database file resides. This directory (not just the database file) also
has to remain writeable by the web server going forward for SQLite to continue to
be able to operate.

On the "Database configuration" form in the "Database file" field, you must
supply the exact path to where you wish your database file to reside. It is
strongly suggested that you choose a path that is outside of the webroot, yet
ensure that the directory is writeable by the web server.

If you must place your database file in your webroot, you could try using the
following in your "Database file" field:

  sites/default/files/.ht.sqlite

Note: The .ht in the name will tell Apache to prevent the database from being
downloaded. Please check that the file is, indeed, protected by your webserver.
If not, please consult the documentation of your webserver on how to protect a
file from downloading.

File

INSTALL.sqlite.txt
View source 
  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.6 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.