SQLite Alternatives
SQLite is described as 'software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain' and is a very popular relational database in the development category. There are more than 50 alternatives to SQLite for a variety of platforms, including Linux, Mac, Windows, BSD and Online / Web-based. The best alternative is PostgreSQL, which is both free and Open Source. Other great apps like SQLite are MySQL Community Edition, MongoDB, MariaDB and CouchDB.
SQLite alternatives are mainly Relational Databases but may also be Database Managers. Filter by these if you want a narrower list of alternatives or looking for a specific functionality of SQLite.PostgreSQL
Is this a good alternative?YesNo- Free • Open Source
- Relational Database
65 alternatives to PostgreSQL- Mac
- Windows
- Linux
- BSD
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
PostgreSQL Features
PostgreSQL vs SQLite
somepeterThis appears like an oranges versus apples comparison. It would be more appropriate to compare MySQL and PostgreSQL. SQLite is serverless, thus much more appropriate for different use cases which do not involve computer networks.
MySQL Community Edition
Is this a good alternative?YesNo- Free • Open Source
- Relational Database
61 alternatives to MySQL Community Edition- Mac
- Windows
- Linux
- BSD
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.
MySQL Community Edition Features
MySQL Community Edition vs SQLite
Not a serverless database
MongoDB
Is this a good alternative?YesNo- Freemium • Proprietary
95 alternatives to MongoDB- Mac
- Windows
- Linux
- Online
- BSD
MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need
MongoDB Features
MongoDB vs SQLite
somepeterAs with PostgreSQL this is a whole different category of database. It is for networked client-server architecture of systems, not an embedded, file based database for use cases like offline apps. Plus: MongoDB is a NoSQL database. By itself it is good, though!
JohnFastmanNot an inherent vulnerability, but MongoDB admins should ensure they're avoiding common pitfalls by, among other things, blocking access to port 27017 or binding local IP addresses to limit access to servers. Lots of MongoDBs have been hijacked by hackers recently: http://arstechnica.com/security/2017/01/more-than-10000-online-databases-taken-hostage-by-ransomware-attackers/
MariaDB
Is this a good alternative?YesNo- Free • Open Source
- Relational Database
49 alternatives to MariaDB- Windows
- Linux
- BSD
MariaDB is a backward compatible, drop-in replacement of the MySQL® Database Server. It includes all major open source storage engines.
MariaDB vs SQLite
SQLite is an in-process database while MariaDB is a networked database.
CouchDB
Is this a good alternative?YesNo- Free • Open Source
69 alternatives to CouchDB- Mac
- Windows
- Linux
- Android
- BSD
Apache CouchDB is a distributed, fault-tolerant and schema-free document-oriented database accessible via a RESTful HTTP / JSON API. It includes incremental map / reduce mechanics for queries and keeps data safe with an append-only datastore.
CouchDB Features
CouchDB vs SQLite
SQLite is an in-process database while CouchDB is a networked database.
Microsoft SQL Server
Is this a good alternative?YesNo- Freemium • Proprietary
- Relational Database
66 alternatives to Microsoft SQL Server- Windows
- Linux
SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from structured, semi-structured, and unstructured documents within the database.
Microsoft SQL Server Features
Microsoft SQL Server vs SQLite
SQLite is an in-process database while SQL Server is a networked database.
RethinkDB
Is this a good alternative?YesNo- Free • Open Source
70 alternatives to RethinkDB- Mac
- Windows
- Linux
- BSD
The open-source database for the realtime web.
RethinkDB Features
CockroachDB
Is this a good alternative?YesNo- Free • Proprietary
- Relational Database
78 alternatives to CockroachDB- Mac
- Linux
- BSD
Cockroach is a distributed key/value datastore which supports ACID transactional semantics and versioned values as first-class features. The primary design goal is global consistency and survivability, hence the name.
Firebird
Is this a good alternative?YesNo- Free • Open Source
- Relational Database
45 alternatives to Firebird- Mac
- Windows
- Linux
Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.
Firebird vs SQLite
Can be embedded in-process
LemonGraph
Is this a good alternative?YesNo- Free • Open Source
19 alternatives to LemonGraph- Mac
- Windows
- Linux
An embedded transactional graph engine for Python backed by a LMDB file. Works with Python 2.6, 2.7 and 3.x.
LemonGraph Features