Best for
Local apps, prototypes, edge tools, single-user workflows, and embedded storage.Great for prototypes and internal local tools before a server database is needed.Teams choose it when the embedded workload is a real product need.
Back to chooserembedded database
SQLite
Local apps, prototypes, edge tools, single-user workflows, and embedded storage.
Common use cases
- Local apps, prototypes, edge tools, single-user workflows, and embedded storage.
- Great for prototypes and internal local tools before a server database is needed.
- Teams choose it when the embedded workload is a real product need.
When not to use it
Many users must write to the same database concurrently over the network.
Common pairings
DuckDBPostgreSQL
Use it when the workload clearly matches; keep the first version operationally simple.
Keep learning before you build.
This page is educational first. Use the project workflow only when you are ready to turn the choice into evidence and a report.