3 ms·
From: https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html Appropriate Uses For SQLite: SQLite is not directly comparable to client/ser
by mr_overalls 8y ago
From: https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html
Appropriate Uses For SQLite:
SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.
Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.
SQLite does not compete with client/server databases. SQLite competes with fopen().
- joshklein 8y agoI like the way I recall someone (Richard Hipp?) putting it: SQLite is a file format. SQLite is an efficient file format for relational data with excellent tooling.