An embedded, serverless database, ideal for edge and local apps.
SQLite is an embedded database that needs no server of its own and simply exists as a single file. That makes it wonderfully uncomplicated to run and surprisingly robust, with some of the most thoroughly tested code in all of software. It is ideal for local applications, edge deployments and anywhere a full database is wanted but nobody wants to operate one separately.
More in the documentationWe use SQLite for desktop and mobile apps, for prototypes and for edge functions where every network hop to a remote database costs time. You get real SQL with no operational overhead, and the entire database can be backed up or shipped as a single file.
PRAGMA journal_mode = WAL;
PRAGMA foreign_keys = ON;Good to know
Switch on WAL mode for concurrent reads and writes. In the default mode a single write blocks all readers, which quickly leads to waits under parallel load.
More tools we work with in the same area.
PostgreSQL
Our first choice for relational data, powerful and reliable.
MySQL & MariaDB
Proven relational databases for classic applications.
MS SQL Server
For enterprise environments and Microsoft integrations.
MongoDB
A flexible document database for unstructured or growing data.
Supabase
Postgres with auth, storage and realtime as a backend-as-a-service.
Redis
An ultra-fast key-value store for caching and realtime features.
You don't have to decide that, it's our job. Tell us about your plans.