SQLite
A lightweight database stored in a single file inside the program, with no separate server.
What is SQLite, and when does it make sense to use it in a program?
SQLite is a database engine that doesn't need a server: the whole database is just a file the program opens directly. Even so, it understands SQL and handles transactions, just like a large-scale database would.
It shows up often inside mobile apps and desktop programs, wherever local data needs to be stored in an orderly way without setting up any infrastructure.
Why it matters to your business
For a program running on one computer or just a few, SQLite can give you the structure of a database with none of the server costs. Choosing the right local storage shapes how fast the app responds and how easy it is to back up its data.
How we use this at Damorus
We don't currently use SQLite in our published projects, and we'd rather say so plainly. At Atlantic Center, the local storage is IndexedDB, the browser database that ships inside Electron, with a layer of changes on top and syncing to Supabase. We'd consider SQLite for a desktop app with a large volume of local data, or for a tool that has to run with no cloud at all.
Need this on your project?
I want my free mockup →