August 17, 2000

SQLite 1.0 released

Richard Hipp released SQLite 1.0 on August 17, 2000 — a self-contained, serverless SQLStructured Query Language — the standard language for querying relational databases. database engine in a single C library.

What it was for

SQLiteSQLite embeds in apps, browsers, and phones — no separate server process. iOSApple's mobile operating system — runs iPhone and iPad with a sandboxed app ecosystem., AndroidGoogle's open mobile operating system — the dominant platform for smartphones worldwide., FirefoxMozilla's open-source browser — championed web standards and challenged Internet Explorer's dominance., and countless desktop apps store data in `.sqlite` files. TeamsMicrosoft Teams — chat, video calls, and Office integration for workplace collaboration. use it for local caches, mobile offline sync, and tests. Example: a mobile app persisting user settings with `SELECT` and transactions without running Postgres.

Why it's here

SQLite made SQLStructured Query Language — the standard language for querying relational databases. available everywhere a C library could link — not just on database servers.

Why it mattered

It is likely the most widely deployed database engine on earth, hidden inside applications.

What it solved

Embedded apps needed relational storage without the complexity of client/server database administration.

Media

  • SQLite
    ImageSQLite

    Максим Пе, CC BY-SA 4.0, via Wikimedia Commons

Related