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 Microsoft SQL Server.
SQLite is mainly a Relational Database but alternatives to it 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 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.
- Free • Open Source
- Mac
- Windows
- Linux
- BSD
PostgreSQL vs SQLite opinions
somepeter This 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 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.
- Free • Open Source
- Mac
- Windows
- Linux
- BSD
MySQL Community Edition vs SQLite opinions
Not a serverless database - MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you needNo screenshots yet
MongoDB vs SQLite opinions
somepeter As 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!JohnFastman Not 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 a backward compatible, drop-in replacement of the MySQL® Database Server. It includes all major open source storage engines.
MariaDB vs SQLite opinions
SQLite is an in-process database while MariaDB is a networked database. - 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 vs SQLite opinions
SQLite is an in-process database while SQL Server is a networked database. - 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 vs SQLite opinions
SQLite is an in-process database while CouchDB is a networked database. - The open-source database for the realtime web.
- ObjectBox DB is an easy & fast object-oriented mobile database for Android, Linux, soon iOS. It supports relations, JavaRx, Kotlin. It is 10X faster than SQLite. And POJOs are POJOs.No screenshots yet
ObjectBox vs SQLite opinions
Quick, easy to use, no SQL :)Super simple, and fast fast fast.Both are serverless solutions - 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.No screenshots yet
Firebird vs SQLite opinions
Can be embedded in-process - 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.