Your business data lives in spreadsheets that get duplicated, break, and can't be cross-referenced. SQLite is a SQL database engine its own docs sum up as 'small, fast, reliable', and it can query CSV files directly with SQL.
Who this is NOT for
If you don't write SQL or code, this is not for you: there are no screens or forms, it is a database engine you use from commands or from code. If you want a database that feels like a spreadsheet, look at NocoDB. And if several people will use the same database at the same time, read its 'Appropriate Uses For SQLite' page first: its own docs explain when a client/server database is the better choice.
What we like most is how honestly it states what it is not for: it publishes a full page on when not to use it and another on its 'Quirks and Gotchas'. The most common mistake comes from there: SQLite stores the type on each value, not on the column, so a price column can end up holding text without you noticing. Its docs offer STRICT tables precisely for that; create yours that way from day one. For a small business, the most practical feature is the CSV virtual table: you can run SQL against the CSV you export from your invoicing system, without importing it by hand.
Your first step
Go to sqlite.org/docs.html, open 'Try it live!' and run a query in your browser. Then read 'When to use SQLite' before deciding whether it fits you.
The SQLite implementation guide
The project belongs to sqlite.org and it is free: the link beside asks for nothing. The guide to set it up without getting lost is ours: step by step, common mistakes and a checklist. Leave your email and we will send it.
No spam. Unsubscribe anytime.