SQLite
Romans Malinovskis
Mar 31, 2016
0 views0
CommentsWhat is SQLite?
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
SQLite is a tool in the Databases category of a tech stack.
SQLite Pros & Cons
Pros of SQLite
- ✓Lightweight
- ✓Portable
- ✓Simple
- ✓Sql
- ✓Preinstalled on iOS and Android
- ✓Free
- ✓Tcl integration
- ✓ Portable A database on my USB 'love it'
Cons of SQLite
- ✗Not for multi-process of multithreaded apps
- ✗Needs different binaries for each platform
SQLite Alternatives & Comparisons
What are some alternatives to SQLite?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
