SQLite

Overview

SQLite is a lightweight database application that does not use a client/server SQL database. This generally works great with most low to medium traffic websites and should manage well on domains that average 100k hits per day.

SQLite on DreamHost Servers

SQLite is pre-installed on DreamHost Shared, VPS, and Dedicated servers.

Ubuntu 14 (Trusty) versions

Servers running Ubuntu 14 run the following versions:

  • 2.8.17 for sqlite
  • 3.7.9 for sqlite3

Ubuntu 18 (Bionic) versions

Servers running Ubuntu 18 run the following versions:

  • 2.8.17 for sqlite
  • 3.22.0 for sqlite3

Bindings for C, PHP, Perl, Python, and Ruby are already included with the SQLite service.

Performance is acceptable, and may be further improved by setting the appropriate parameters: for example, the new Write-Ahead Logging can be enabled by using PRAGMA journal_mode=WAL; (SQLite >= 3.7.0).

See also

Did this article answer your questions?

Article last updated PST.