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. The versions installed are 2.8.17 for sqlite and 3.7.9 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.