🧠 Second Brain

SQLite DB

Last updated Nov 14, 2024

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled with countless other applications that people use every day. More Information…

The SQLite File Formatay through the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems and as a long-term archival format for data. There are over 1 trillion (1e12) SQLite databases in active use.

SQLite source code is in the public domain and is free for everyone to use for any purpose. It’s open source, but open contribution, it’s maintained by three people only. That’s why Turso started libSQL.

# When to use: Use-Cases

SQLite is used for relational workloads. Most often used if the data needs to stay close to that application, as it’s a single file and easy to manage, also called embedded database.

If you want more analytical workload, but with the same principles, check out DuckDB.