SQLite is a lightweight, open-source relational database that runs directly inside an application, with no separate server process at all — fundamentally different in design from every other product in this section.
Core Concept
Unlike client-server databases meant to serve many applications from one central server, SQLite stores an entire database as a single file and runs embedded inside whatever application uses it — there's no server to install, configure, or manage.
Deep Dive
- This makes SQLite an excellent fit for situations where a full client-server database would be overkill: mobile apps, small tools, embedded devices, and — relevant to this course — the in-browser SQL Playground you can use throughout your learning.
- SQLite deliberately does not support some things a large multi-user client-server database would, like managing many simultaneous writers, as well as a dedicated server product does — it's optimized for simplicity and portability, not for serving large numbers of concurrent users.
Production Perspective
SQLite is one of the most widely deployed pieces of database software in the world, largely because it's built into countless mobile apps, browsers, and embedded systems, even though most of its users never interact with it directly.
Interview Questions
Why wouldn't you use SQLite for a large, multi-user web application's main database?
SQLite is optimized for embedded, single-application use rather than serving many concurrent users and writers efficiently — a client-server RDBMS like PostgreSQL or MySQL is built specifically for that workload.