Appropriate Uses For SQLite

SQLite is not directly comparable to other SQL database engines such as Oracle, PostgreSQL, MySQL, or SQL Server since SQLite is trying to solve a very different problem.

Other SQL database engines strive to implement a shared repository of enterprise data. They emphasis scalability, concurrency, centralization, and control.

SQLite, on the other hand, strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.

SQLite is not designed to compete with [ | Oracle]. SQLite is designed to compete with [ | fopen()].

Situations Where SQLite Works Well

Situations Where Another RDBMS May Work Better