INSTALL.sqlite.txt

Same filename in other branches
  1. 9 core/INSTALL.sqlite.txt
  2. 8.9.x core/INSTALL.sqlite.txt
  3. 10 core/INSTALL.sqlite.txt
  4. 11.x core/INSTALL.sqlite.txt
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. SQLITE REQUIREMENTS
  2. -------------------
  3. To use SQLite with your Drupal installation, the following requirements must be
  4. met: Server has PHP 5.6 or later with PDO, and the PDO SQLite driver must be
  5. enabled.
  6. SQLITE DATABASE CREATION
  7. ------------------------
  8. The Drupal installer will create the SQLite database for you. The only
  9. requirement is that the installer must have write permissions to the directory
  10. where the database file resides. This directory (not just the database file) also
  11. has to remain writeable by the web server going forward for SQLite to continue to
  12. be able to operate.
  13. On the "Database configuration" form in the "Database file" field, you must
  14. supply the exact path to where you wish your database file to reside. It is
  15. strongly suggested that you choose a path that is outside of the webroot, yet
  16. ensure that the directory is writeable by the web server.
  17. If you must place your database file in your webroot, you could try using the
  18. following in your "Database file" field:
  19. sites/default/files/.ht.sqlite
  20. Note: The .ht in the name will tell Apache to prevent the database from being
  21. downloaded. Please check that the file is, indeed, protected by your webserver.
  22. If not, please consult the documentation of your webserver on how to protect a
  23. file from downloading.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.