SQLite

 

Overview

This article explains how to use SQLite at DreamHost.

Background

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

How to use SQLite at DreamHost

The following sections provide links to resources that show you how to use and manage SQLite.

Checking SQLite on DreamHost Servers

SQLite is pre-installed on DreamHost Shared, VPS, and Dedicated Servers. See this article to learn more about how to confirm your server's operating system and SQLite version.

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

Using SQLite

The official quickstart guide provides instructions for creating an SQLite database and writing a basic SQLite program.

Installing a custom version

See this article for instructions on installing a custom version of SQLite.

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?