SQLite AlternativesRelational Databases and other similar apps like SQLite

SQLite is described as 'Software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite 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 Windows, Linux, Mac, Self-Hosted and Web-based apps. The best SQLite alternative is PostgreSQL, which is both free and Open Source. Other great apps like SQLite are MySQL Community Edition, MariaDB, MongoDB and Microsoft SQL Server.

More about SQLite
Copy a direct link to this comment to your clipboard
SQLite alternatives page was last updated

Alternatives list

  1. PostgreSQL icon

    PostgreSQL

     321 likes

    PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

    75 PostgreSQL alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    • Self-Hosted
    PostgreSQL screenshot 1
     
    |
    2
    Comments about PostgreSQL as an Alternative to SQLite
    RemovedUser
    Negative
    4

    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.

    Review by a new / low-activity user.
    Guest
    Negative
    0

    SQLite is a great little database engine but it's not really meant for multi-user environments. This is where PostgreSQL, MariaDB, and the likes, live.

    Review by a new / low-activity user.
    PostgreSQL icon
    PostgreSQL icon
    • PostgreSQL is Free and Open SourceSQLite is also Free and Open Source
  2. MySQL Community Edition icon

    MySQL Community Edition

     300 likes

    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.

    66 MySQL Community Edition alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    MySQL Workbench
     
  4. MariaDB icon

    MariaDB

     141 likes

    MariaDB is a backward compatible, drop-in replacement of the MySQL® Database Server. It includes all major open source storage engines.

    Cost / License

    Application type

    Platforms

    • Windows
    • Linux
    • BSD
    Deploy
     
    |
    1
    Comments about MariaDB as an Alternative to SQLite
    Guest
    Negative
    3

    SQLite is an in-process database while MariaDB is a networked database.

    Review by a new / low-activity user.
    MariaDB icon
    MariaDB icon
    • MariaDB is Free and Open SourceSQLite is also Free and Open Source
  5. MongoDB icon

    MongoDB

     148 likes

    MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need

    101 MongoDB alternatives

    Cost / License

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Online
    • BSD
     
    |
    2
    Comments about MongoDB as an Alternative to SQLite
    RemovedUser
    Negative
    2

    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!

    Review by a new / low-activity user.
    John Fastman
    Negative
    -5

    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/

    MongoDB icon
    MongoDB icon
    • MongoDB is Freemium and ProprietarySQLite is Free and Open Source
  6. Microsoft SQL Server icon

    Microsoft SQL Server

     84 likes

    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.

    67 Microsoft SQL Server alternatives

    Cost / License

    • Freemium
    • Proprietary

    Application types

    Platforms

    • Windows
    • Linux
    Microsoft SQL Server screenshot 1
     
    |
    1
    Comments about Microsoft SQL Server as an Alternative to SQLite
    Guest
    Negative
    9

    SQLite is an in-process database while SQL Server is a networked database.

    Review by a new / low-activity user.
    Microsoft SQL Server icon
    Microsoft SQL Server icon
    • Microsoft SQL Server is Freemium and ProprietarySQLite is Free and Open Source
  7. CouchDB icon

    CouchDB

     48 likes

    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.

    74 CouchDB alternatives

    Cost / License

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Android
    • BSD
    CouchDB screenshot 1
     
    |
    1
    Comments about CouchDB as an Alternative to SQLite
    Guest
    Negative
    7

    SQLite is an in-process database while CouchDB is a networked database.

    Review by a new / low-activity user.
    CouchDB icon
    CouchDB icon
    • CouchDB is Free and Open SourceSQLite is also Free and Open Source
  9. DuckDB icon

    DuckDB

     7 likes

    There are many database management systems (DBMS) out there. But there is no one-size-fits all database system. All take different trade-offs to better adjust to specific use cases. DuckDB is no different.

    Cost / License

    • Free
    • Open Source (MIT)

    Platforms

    • Mac
    • Windows
    • Linux
     
  10. Firebird icon

    Firebird

     21 likes

    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.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Android
    • Android Tablet
     
    |
    1
    Comments about Firebird as an Alternative to SQLite
    Guest
    Positive
    1

    Can be embedded in-process

    Review by a new / low-activity user.
    Firebird icon
    Firebird icon
    • Firebird is Free and Open SourceSQLite is also Free and Open Source
  11. Triplit icon

    Triplit

     8 likes

    A full-stack, syncing database that runs on both server and client. Pluggable storage (indexeddb, sqlite, durable objects), syncs over websockets, and works with your favorite framework (React, Solid, Vue, Svelte).

    Cost / License

    Platforms

    • Self-Hosted
    • Software as a Service (SaaS)
    Triplit screenshot 1
     
  12. libSQL icon

    libSQL

     2 likes

    We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.

    Cost / License

    • Free
    • Open Source (MIT)

    Platforms

    • Self-Hosted
    • Docker
    libSQL screenshot 1
     
  13. Realm icon

    Realm

     7 likes

    Realm enables any development team, no matter the size, to include difficult-to-build features like two-way data sync and realtime collaboration. Devote more time to what makes your app truly unique and less time to maintaining services.

    Cost / License

    • Free
    • Open Source

    Platforms

    • Mac
    • Android
    • iPhone
    • iPad
     
  14. CockroachDB icon

    CockroachDB

     16 likes

    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.

    96 CockroachDB alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Linux
    • BSD
    CockroachDB screenshot 1
     
12 of 71 SQLite alternatives