Updated

SQLite

Embedded SQL database stored in a single file and linked into your app process, with no database server to run.

241 open-source projects declare SQLite in their code; no maker's live product we track uses it yet.

Open sourceSelf-hostableFree tier

Profile checked

Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

How makers use SQLite

What SQLite is used for

Database · Run it yourself →A database that is just a file in your app — desktop and mobile apps, single-server web apps, tests and prototypes.Trade-off: One writer at a time and no network access of its own; backups and replication need extra tools (Litestream, or a host like Turso).
Supabase573Firebase187MongoDB128PostgreSQL98Neon96SQLite0Makers' products on each, for database

SQLite vs the alternatives makers chose

OptionMakers' products2026 launchesFree forAt 10,000 usersOpen source
Supabase573 45%63%~500 users$25/mo · ProYes
Firebase187 15%9%~2,000 users$9.66/mo · Blaze (pay as you go)No
MongoDB128 10%5%~500 users$58/mo · Atlas Dedicated M10No
PostgreSQL98 8%1%——Yes
Neon96 8%11%None$22/mo · LaunchYes
Convex50 4%7%~630 users$29/mo · ProfessionalYes
SQLite0 0%0%——Yes

For database: how many of the 1,263 makers' products we know the database of chose each option, and the share among the 397 launched in 2026, since a tool that came first has products from every year, and what each costs at 10,000 users.

Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for.

When to use SQLite, and when not

Something else fits better if

  • You want the database, auth and file storage in one project, and plain SQL you can take elsewhere: Supabase.
  • You're building a live, collaborative app entirely in TypeScript: Convex.
  • Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost much: Neon.
  • You already run your own server and want a flat monthly cost: PostgreSQL.
From each decision's guide, written from what makers' products chose and why.

What Hacker News says about SQLite

On Hacker News, 21% of comments about SQLite recommend it and 6% criticize it: net praise +16%, 6th best liked of 16 tools HN discusses for database.

By year

YearComments choosing it, per monthNet praise
202326+12%
202431+32%
202535+12%
2026 (8 mo)49+4%

In their words

  • “I love this trend of pushing SQLite for advanced scenarios and new architectures. It’s so much more powerful than people give it credit for.” HN, Aug 2026
  • “I really like the simplicity and speed of SQLite, I've used in both personal and professional projects.” HN, May 2026

Hacker News comments January 2023 to August 2026 that name SQLite in a sentence like "I use" or "we moved to", Claude read a sample of 100 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.

Who uses it

No maker's live product on record yet, and 241 open-source projects that declare it in their code.

Declared in code 241How evidence is collected →

We haven't found a maker's live product that uses SQLite yet — only the open-source projects below, which declare it in their code.

LangBot
LangBotProduction-grade platform for building agentic IM bots - 生产级多平台智能机器人开发平台/ Agent、知识库编排、插件…DatabaseIn its code · source ↗

Open source: a project that declares SQLite as a dependency in its public code — verifiable, but not necessarily a live product.

What its projects tell coding agents

What open-source projects' AGENTS.md and CLAUDE.md files say about SQLite, in our words — from the 74 files that name it:

111 of the 167 open-source products built with SQLite that were worked on in the last 180 days keep instruction files for coding agents — 66%, against 53% of all the projects we read. AGENTS.md is in 96, CLAUDE.md in 74.

1,206words in the median file
npmthe package manager most named, in 31 of 103 files
67%say how to test a change
Named more in these files than in other projects' — in how many of the 103:
What AGENTS.md files say about other tools →What open-source products tell their coding agents →

Alternatives to SQLite

All alternatives by situation →

Further reading

Questions makers ask about SQLite

What are the alternatives to SQLite?

For database, the other options makers' products we track chose most are Supabase (573), Firebase (187), MongoDB (128), PostgreSQL (98), Neon (96), Convex (50). Open source or self-hostable among them: Supabase, MongoDB, PostgreSQL, Neon, Convex. Each alternative, with the situation it fits, is on the SQLite alternatives page.

Is SQLite free?

Yes — it is free, open-source software.

Is SQLite open source or self-hostable?

Open source, and you can self-host it. source ↗

Can AI coding agents work with SQLite?

No llms.txt, official MCP server or CLI found yet.

Who uses SQLite?

No maker's live product we track yet; 241 open-source projects declare it in their code. source ↗