- Overview
- Alternatives
- Pros & Cons
- Compare
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. The database uses Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs. Microsoft SQL.. read more.
PostgreSQL
PostgreSQL, or Postgres for short is a widely popular, free and open-source relational database management system. PostgreSQL is available for all major operating systems including macOS, Linux, Windows, BSD and Solaris. The project has been in active development for over 30 years now, and powers many of the applications you use on a daily basis.
MariaDB
MariaDB is an free and open-source, community-developed relational database management system. MariaDB is a fork of MySQL, and is developed and maintained by the creators of MySQL, after concerns over its acquisition by Oracle Corporation in 2009. The databases comes bundled by default with most Linux distributions and is also apart of most cloud offerings. MariaDB is built upon the values of performance, stability, and openness which is ensured through the MariaDB Foundation.
SQLite
SQLite is a free and open-source relational database management system that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. Rather than being a typical client–server database engine, SQLite is self-contained and can be embedded into applications. Making it perfect for development frameworks that want to provide a default database without setup, or applications that needs an embedded database. SQLite is built into all mobile operating systems and most computers and comes bundled with a countless applications. SQLite is also ACID-compliant and implements most of the SQL standard, generally following PostgreSQL syntax.
Apache Cassandra
Apache Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. Apache Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. The database has become the choice of many organizations that need scalability and high availability without compromising performance. Apache Cassandra also provides support for replicating across multiple datacenters, providing lower latency for end users of Cassandra-powered applications.
CouchDB
CouchDB is a free and open-source document-oriented NoSQL database developed by the Apache Foundation. The database is written and implemented in the language Erlang and provides the use of multiple formats and protocols to store, transfer, and process data. With CouchDB you query data with JavaScript using MapReduce, and HTTP for an API. Which can be done across multiple distributed CouchDB instances as the database has the ability to synchronize multiple copies of the same database, across servers.
CockroachDB
Cockroach is a distributed key/value datastore that allow you to build, scale and manage modern, data-intensive applications. The database delivers distributed SQL by combining the familiarity of relational data with limitless, elastic cloud scale and bulletproof resilience. Correct data is a must for mission-critical and even the most common applications. CockroachDB provides guaranteed ACID compliant transactions, allowing you to fully trust your data.
RethinkDB
RethinkDB is a scalable, open-source database designed for real-time applications. When your app polls your database for data, it becomes slow, unscalable, and cumbersome to maintain. RethinkDB solves this by providing a new database access model, where developers can instruct the database to continuously push updated query results to their applications, without polling.
HSQLDB
HSQLDB is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2016. It's the best for Java developers for development, testing and deployment of database applications. HSQLDB provides a small, fast, multithreaded engine and server with memory and disk tables, LOBs, transaction isolation, multiversion concurrency and ACID.
MemSQL
MemSQL is a free and open-source all-in-one relation database management system. The database lends itself for operational analytics and AI/ML-powered applications that requires fast data ingest, high performance queries and elastic scaling. MemSQL supports ANSI SQL and blended workloads, commonly referred to as translytical, HTAP, HOAP, and ATP workloads. The developer MemSQL Inc, also provides commercially hosted version of the database called MemSQL Helios, a cloud database-as-a-service.
CouchBase
Couchbase, originally known as Membase is an award-winning, open-source, distributed multi-model NoSQL and document-oriented cloud database. It is designed and optimized for interactive applications and may serve many concurrent users by creating, storing, retrieving, aggregating, manipulating and presenting data. Couchbase delivers unmatched versatility, performance, scalability, and financial value across cloud, on-premises, hybrid, distributed cloud, and edge computing deployments.
ArangoDB
ArangoDB is a database system that was designed to support key/value, document, and graph data to be stored together, and queried via a unified language called AQL. The project is developed by ArangoDB GmbH, and released free and open-source under the Apache License 2.0. The universal "native multi-level" design of the database allows for a flexible approach when structuring and building an application, a feature that many have come to love.
OrientDB
OrientDB is an open-source NoSQL database management system written in Java. The multi-model database supports graph, document, key/value, and object models, where relationships are managed as in graph databases with direct connections between records. The database is extremly efficient and can store over 220,000 records per second on common hardware, and traverse thousands of records in milisecons. OrientDB scales well on multiple machines, thanks to the multi-master replication where there is no single bottleneck on writes like with master-slave replication.
How Are These Microsoft SQL Server Alternatives Generated?
Information found on this page is crowd-sourced by the community and contains the most agreed upon Open Source Microsoft SQL Server alternatives. You can use this information to find similar software to Microsoft SQL Server for specific platforms with various pricing options and licenses. Anyone that have previously used Microsoft SQL Server can suggest alternatives, vote on the accuracy of other users claims, and help more people in the process of doing so.
This page was last updated on Sun 23 Jan 2022 (3 weeks, 1 day ago).