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

     319 likes
    Copy a direct link to this comment to your clipboard

    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.

    73 PostgreSQL alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • BSD
    • Self-Hosted
    PostgreSQL screenshot 1
     
    |
    1
    15
    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.
    SQLite Icon
    PostgreSQL icon

    • Most users think PostgreSQL is a great SQLite alternative.

    • PostgreSQL is the most popular Windows, Mac, Linux & Self-Hosted alternative to SQLite.

    • PostgreSQL is the most popular Open Source & free alternative to SQLite.

    • PostgreSQL is Free and Open SourceSQLite is also Free and Open Source
  2. MySQL Community Edition icon

    MySQL Community Edition

     300 likes
    Copy a direct link to this comment to your clipboard

    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.

    65 MySQL Community Edition alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

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

    MariaDB

     140 likes
    Copy a direct link to this comment to your clipboard

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

    Cost / License

    • Free
    • Open Source

    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.
    SQLite Icon
    MariaDB icon

    • Some users think MariaDB is a great SQLite alternative, some don't.

    • MariaDB is Free and Open SourceSQLite is also Free and Open Source
  5. MongoDB icon

    MongoDB

     148 likes
    Copy a direct link to this comment to your clipboard

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

    99 MongoDB alternatives

    Cost / License

    • Freemium
    • Proprietary

    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/

    SQLite Icon
    MongoDB icon

    • Some users think MongoDB is a great SQLite alternative, some don't.

    • MongoDB is the most popular Web-based alternative to SQLite.

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

    Microsoft SQL Server

     84 likes
    Copy a direct link to this comment to your clipboard

    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.

    66 Microsoft SQL Server alternatives

    Cost / License

    • Freemium (Pay once)
    • 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.
    SQLite Icon
    Microsoft SQL Server icon

    • This alternative is disputed. Microsoft SQL Server is a legitimate SQLite alternative, but it might have issues that some users think are important.

    • Microsoft SQL Server is Freemium and ProprietarySQLite is Free and Open Source
  7. CouchDB icon

    CouchDB

     48 likes
    Copy a direct link to this comment to your clipboard

    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.

    72 CouchDB alternatives

    Cost / License

    • Free
    • Open Source

    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.
    SQLite Icon
    CouchDB icon

    • CouchDB is the most popular Android alternative to SQLite.

    • CouchDB is Free and Open SourceSQLite is also Free and Open Source
  9. DuckDB icon

    DuckDB

     7 likes
    Copy a direct link to this comment to your clipboard

    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

    Platforms

    • Mac
    • Windows
    • Linux
     
  10. Triplit icon

    Triplit

     8 likes
    Copy a direct link to this comment to your clipboard

    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

    • Free
    • Open Source

    Platforms

    • Self-Hosted
    • Software as a Service (SaaS)
    Triplit screenshot 1
     

    • Triplit is the most popular SaaS alternative to SQLite.

    • Triplit is Free and Open SourceSQLite is also Free and Open Source
  11. libSQL icon

    libSQL

     2 likes
    Copy a direct link to this comment to your clipboard

    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

    Platforms

    • Self-Hosted
    • Docker
    libSQL screenshot 1
     
  12. Firebird icon

    Firebird

     21 likes
    Copy a direct link to this comment to your clipboard

    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.

    47 Firebird alternatives

    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.
    SQLite Icon
    Firebird icon

    • Most users think Firebird is a great SQLite alternative.

    • Firebird is the most popular Android Tablet alternative to SQLite.

    • Firebird is Free and Open SourceSQLite is also Free and Open Source
  13. Realm icon

    Realm

     7 likes
    Copy a direct link to this comment to your clipboard

    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
     

    • Realm is the most popular iPhone & iPad alternative to SQLite.

    • Realm is Free and Open SourceSQLite is also Free and Open Source
  14. CockroachDB icon

    CockroachDB

     16 likes
    Copy a direct link to this comment to your clipboard

    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.

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

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