Best Open-Source and Free Database Software

Aaron Walker
Aaron Walker  |  December 5, 2017

Database software tools power just about every application you can think of.

It could be a social media giant storing user information or a spooky hacker on the dark web storing your personal and financial data.

Most companies today need some kind of database, but it’s not always easy to know which one would best fit your needs. They started out as sets of punch cards, but are now monstrous databases capable of storing petabytes of information.

That can make it pretty tough on a new user looking for a database software solution for their business. But there are three database types we see most frequently: relational databases, document databases and graph databases. There are myriad additional NoSQL database solutions, but let’s focus on these popular choices.

They not only range in purpose, but price as well. They can be outrageously expensive or free to use. Free and open-source database tools are typically more appealing to the everyday small business and app creator, so we’ve outlined some of the best ones, according to user reviews on G2 Crowd.

To help small businesses this list: Best Free Database Software. Using reviews from real users, our list of free database tools is ordered by highest G2 Score as of November 20, 2017.

Best Free Relational Databases

These are some of the oldest and most common databases around today. Oracle released the first fully functional one in 1979, but today there are hundreds of proprietary and open-source options available.

Just about all relational databases utilize the SQL language for querying objects and related information. But some are web-based, others are not. Some are cross-platform, others are not.

  MySQL Microsoft SQL PostgreSQL
License AGPL version 2 Commercial BSD
Cloud-Based No No No
Server OS FreeBSD, Linux, OS X, Solaris, Windows Linux, Windows FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows
APIs ADO.NET, JDBC, ODBC OLE DB, Tabular Data Stream (TDS), ADO.NET, JDBC, ODBC native C library, streaming API for large objects, ADO.NET, JDBC, ODBC
Language Support Ada, C, C#, C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl C++, Delphi, Go, Java, JavaScript (Node.js), PHP, Python, R, Ruby, Visual Basic .Net, C, C++, Delphi, Java , Perl, PHP, Python, Tcl

Source
 

1. MySQL

MySQL logo

MySQL has been around for more than 30 years, and it’s evolved a lot since then. It’s still free and open-source, but there are a lot more GUI and command line tools for managing and accessing MySQL. Those can be found in our Non-Native Database Mgmt Systems software category.

The open-source community edition includes a pluggable storage engine, MySQL replication, partitioning, connectors and a ton of other features. It can run on just about every platform and operating system you can think of.

The tool has 217 reviews on G2 Crowd, averaging 4.4 out of 5 stars. It was named a Leader in G2 Crowd’s Summer 2016 Grid® for Relational Databases. And it’s used pretty equally across small, mid-market and enterprise businesses and industries.

It powers gigantic apps like Uber, WordPress and Facebook. But for high-volume sites, the enterprise offerings may be better suited to meet your requirements.

 

2. Microsoft SQL

MS SQL logoAnother staple in the relational database world, Microsoft SQL has been around since the late 1980s and powers other hugely popular companies like NASDAQ, Yahoo and Dell.

Microsoft offers a free “express” version for building smaller applications, which can host up to 10GB of data. It comes with development tools, management tools and Azure backup and restore.

The reviews for Microsoft SQL span the express, standard and enterprise versions, but it’s currently rated third-highest on our Grid® for Relational Databases. It has 332 reviews, averaging 4.3 out of 5 stars.

The tool has fewer small-business users compared to MySQL. 274 of its 332 reviews come from users at mid-market and enterprise companies. Those span tons of industries, but IT and SaaS companies were its largest clients.

 

3. PostgreSQL

PostgreSQL logoThough it is not quite as old or widely used, it has still been around for more than 20 years and powers giant corporations like ADP, Fujitsu and Cisco. According to its site, 30 percent of tech companies use PostgreSQL as the core for applications as of 2012.

The tool has a liberal open-source license, which allows users to freely modify code for their specific company’s needs. Some of its core features include table inheritance, nested transactions and asynchronous replication.

PostgreSQL has 126 reviews on G2 Crowd, averaging 4.4 out of 5 stars. It’s definitely more appealing to small- and mid-sized companies, judging by its review distribution, and it spans a ton of industries as well.

It’s currently the sixth-highest rated overall relational database on G2 Crowd, but has the third-highest satisfaction score. It was named a High Performer in G2 Crowd’s Summer 2016 Grid® for Relational Databases.

Feature Rating MySQL Microsoft SQL PostgreSQL
Query Language 90% 90% 92%
Storage 89% 89% 90%
Availability 90% 91% 92%
Stability 88% 90% 94%
Scalability 78% 87% 85%
Security 84% 89% 90%
Data Manipulation 87% 89% 90%

 

Additional Free Relational Databases to Note

Teradata Database — Offers free developer edition that includes a preconfigured database, row-level security and virtual deployment capabilities.

SAP HANA, Express Edition — Offers free edition capable of handling 32GB of RAM. Features include database server, analytics and microservice architecture.


Best Free Document Databases

Document-oriented database software solutions, sometimes called document stores, like you’d guess, are used for managing document-oriented data. They’re one of the most common non-SQL, or NoSQL, databases used today.

Unlike SQL database servers, document databases store all data available, not just sets designated by the programmer. This makes them more flexible and dynamic, ideal for web developers managing tons of data that’s constantly changing.

  MongoDB CouchDB DynamoDB
License AGPL version 3 Apache version 2 Commercial
Cloud-Based No No Yes
Server OS Linux, OS X, Solaris, Windows Android, BSD, Linux, OS X, Solaris, Windows Hosted
APIs proprietary protocol using JSON RESTful HTTP/JSON API RESTful HTTP API
Language Support C, C#, C++, Clojure, ColdFusion, D, Dart, Delphi, Erlang, Go, Groovy, Haskell, Java, JavaScript, Lisp, Lua, MatLab, Perl, PHP, PowerShell, Prolog, Python, R, Ruby, Scala, Smalltalk C, C#, ColdFusion, Erlang, Haskell, Java, JavaScript, Lisp, Lua, Objective-C, OCaml, Perl, PHP, PL/SQL, Python, Ruby, Smalltalk .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
 
Source
 

1. MongoDB

MongoDB logoUnlike the common SQL databases, MongoDB is relatively young. It was launched in 2009, but already has more than 30 million downloads, according to its site. Corporations like Expedia, Forbes and MetLife use it to store and manage their sensitive information.

The free and open-source tool functions across platforms and provides drivers for 10-plus languages, including Python, Java and C++. Its core features are indexing, ad hoc querying and high-availability data replication.

The tool has 168 user reviews, averaging 4.4 out of 5 stars. Only 11 of those are not 4- or 5-star ratings. Most of its users come from IT and software companies but span evenly across company size.

It was the only Leader named in the Spring 2016 Grid® for Document Databases and the only tool in the category with more than 50 reviews.

 

2. CouchDB

CouchDB logoCouchDB is a few years older than MongoDB, but uses the same file notation format, JSON. It was developed by open-source giant Apache and released in 2005. Some large companies using CouchDB are the BBC, Sophos and Canonical.

It’s completely open source, like almost all Apache tools. Some of its core features are ACID Semantics, offline editing and a distributed architecture perfect for data replication.

The tool has 41 reviews on G2 Crowd, averaging 3.8 out of 5 stars. Almost all of those, 30 out of 40, are from small-business users.

It just barely missed a High Performer rating in the Spring 2016 Grid® for Document Databases. But today it has the second-highest rating in the category.

 

3. DynamoDB

Dynamo logoDynamoDB is a fully managed offering from Amazon Web Services (AWS) as part of its suite of cloud products. It’s not totally free, and while AWS does offer a free tier with limited capabilities, be warned: If you exceed free-tier usage, you must pay the difference.

The free offering allows applications to handle up to 200 million requests per month, 2.5 million read requests per month from DynamoDB Streams and store 25 GB of data. Most of the paid offerings are scalable depending on application usage.

The tool has 24 reviews on G2 Crowd, averaging 3.9 out of 5 stars. It didn’t make it into last spring’s report, but it’s the third-highest rated product in the category today.

Most users came from small and mid-market companies, with 10 reviews for each. Fourteen of its total reviews came from users in technology-related industries.

Feature Rating MongoDB CouchDB DynamoDB
Query Language 82% 72% 60%
Storage 88% 80% 96%
Availability 90% 90% 94%
Stability 87% 85% 97%
Scalability 89% 79% 97%
Security 78% 73% 91%
Data Manipulation 85% 70% 66%
 

Additional Free Document Databases to Note

MarkLogic — Offers a developer-edition for free use with features for storing up to 1TB of data, ACID transactions, REST APIs and more.

RethinkDB — Open-source tool to store JSON documents. Features include real-time updates, dynamic schemas and web-based administration as a free online database.


Best Free Graph Databases

Graph Database software solutions are another NoSQL type database that use graph structures for semantic queries. The tools are based on graph theory, where nodes represent data points and they’re interconnected by edges, also called graphs.

Users utilize some kind of non-SQL query language such as AQL, Cypher or Gremlin to retrieve data. There’s no real standard for graph databases as far as queries go, but they can’t use SQL because it doesn’t handle nodes in the same elegant fashion.

  ArangoDB Neo4j OrientDB
License Apache version 2 AGPL version 3 Apache version 2
Cloud-Based No No No
Server OS Linux, OS X, Windows Linux info, OS X, Solaris, Windows All OS with a Java JDK (>= JDK 6)
APIs HTTP API, JSON style queries Cypher query language, Java API, Neo4j-OGM info, RESTful HTTP API, Spring Data Neo4j, TinkerPop 3 ava API, RESTful HTTP/JSON API, Tinkerpop technology stack with Blueprints, Gremlin, Pipes
Language Support C#, Clojure, Java, JavaScript (Node.js), PHP , Python , Ruby .Net, Clojure, Elixir, Go, Groovy, Haskell, Java, JavaScript, Perl, PHP, Python, Ruby, Scala .Net, C, C#, C++, Clojure, Java, JavaScript, JavaScript (Node.js), PHP, Python, Ruby, Scala

Source

 

1. ArangoDB

ArangoDB logoArangoDB is probably the most popular graph database used today. It was published in 2015 and fits in a number of categories on our site including graph and document databases.

Its core functionality is divided into three parts for document, graph and cluster datasets. Its graph features include pattern matching, distributed graphs and nested properties.

It didn’t make the Spring 2016 Grid® for Document Databases. But it’s the highest-rated product in G2 Crowd’s graph database category and the fourth-highest rated product in G2 Crowd’s document database category.

It has 22 reviews, averaging 4.9 out of 5 stars. Eighteen of those reviews fall under the graph databases category. Most of them come from small-business users in technology fields.

 

2. Neo4j

Neo4J logoNeo4j is another open-source graph database, but it’s a little older. It was launched in 2007 and utilizes Cypher, a query language described on its site as “the most efficient and expressive way to describe relationship queries.”

While the graph database makes up the Neo4j core, it offers additional products for analytics, data discovery and development. The database’s core features include high availability, online backup and “whiteboard friendly” data modeling.

Neo4j has 30 reviews on G2 Crowd, averaging 4.4 out of 5 stars. Half of its reviews came from small-business users, most of whom work for technology companies.

Many users describe it as lightweight and easy to use. It’s currently the second-highest rated product in G2 Crowd’s graph databases category.

 

3. OrientDB

OrientDB logoOrientDB is a relatively young database management solution with support for graph, document, key value and object-oriented database models. It’s open source and supports the Gremlin programming/querying language.

The product’s graph database tools actually supports SQL as well, but other features include JSON libraries, ACID transactions and distributed cluster configuration. An interesting component about this tool, though, is its graph editor for easy visual data manipulation.

It made our Spring 2016 Grid® for Document Databases as a niche product. Now, it’s the sixth-highest rated document database and the third-highest rated graph database on G2 Crowd.

It has 32 reviews, averaging 3.9 out of 5 stars. Twenty-six of those are specifically for graph databases. Most users worked at small- and mid-sized companies in a technology field.

Feature Rating ArangoDB Neo4j OrientDB
Query Language 96% 86% 84%
Storage 94% 82% 86%
Availability 94% 84% 82%
Stability 91% 84% 72%
Scalability 92% 73% 76%
Security 82% 61% 80%
Data Manipulation 95% 80% 85%

 

 

Additional Free Graph Databases to Note

Titan — Open-source tool with elastic scalability, data distribution and multi-datacenter high availability.

Cayley — Open-source tool built on Freebase and Google’s Knowledge Graph. Features include multiple backend stores, modular design and RESTful API.


Other Free Databases

Relational, document and graph databases are three of the more common database types available. But others types include object-oriented, operational, key-value and wide-column databases.

And that’s just a few of them. There are a ton to choose from and most people who choose NoSQL are looking for faster implementation time, flexibility and reduced data retrieval times. These are some free tools that don’t fit into some of our larger database categories.

Hive

Hive logoHive is almost a data warehouse, but it has a SQL-like interface to help users query data using the HiveQL language. It’s built atop Apache Hadoop, a big-data processing filesystem.

Some of the core features include a metastore, driver and compiler. It’s typically used to give structure to data already being stored and enabling traditional data mapping.

Hive has 27 user reviews on G2 Crowd, averaging 4.2 out of 5 stars. Most of those came from larger companies, which makes sense since it’s typically used to aid big-data processes.

Some users gave it poor ratings, citing its slow speed and complexity. But it seemed polarizing since many people said it significantly improves their big-data processing capabilities.

 

Elasticsearch

Hive logo

Elasticsearch fits somewhere between a search engine and a database, but I’m including it since many people use it as a NoSQL datastore. It’s built on Lucene, an information retrieval library from Apache.

Several large companies use it to power datastores and search components such as GitHub, Facebook and Adobe. The tool aggregates large datasets and helps users identify trends and patterns within datasets.

Elasticsearch has 28 reviews, averaging 4.6 out of 5 stars. Reviews are split across company size, with most users landing in the mid-market tier.

Users cited tons of different usages for the tool, ranging from database search to log monitoring. Users repeatedly cited its querying speed and many lauded its simplicity for use and configuration.

 

Cassandra

Cassandra logoCassandra is an Apache-developed distributed NoSQL database system that’s been around since 2008. It’s believed to be one of the most scalable database options to choose from because it handles data across many commodity servers.

The tool was developed at Facebook as an open-source project on Google code. Some features of note are its decentralized structure, replication capabilities and tunable consistency to reduce failover.

It has 21 reviews on G2 Crowd, averaging 4.1 out of 5 stars. Users spanned across company sizes and technology-related fields.

Reviewers cited usage cases for a variety of purposes from managing API metadata to a range of clustering packages. The speed and reliability were recently cited, but many users said it was difficult to use and not well suited for users working with small datasets.


Learn more about database software: 

Costs for many of these products may come up for licensing, support and use with larger datasets, but these tools all provide a free core module of some sort for users to begin working for free.

Visit our database software management categories to find more open-source and proprietary options for the best database tool to fit your company’s needs or learn more about the differences between data warehouses vs. databases.

Aaron Walker
Author

Aaron Walker

Aaron is a Senior Research Specialist who focuses on cybersecurity, information technology and software development. He began at G2 Crowd in 2016 after graduating from The University of Iowa. Aaron has written for The Daily Herald, Tribune Media, and The Daily Iowan, among other media outlets. In his free time, Aaron enjoys shooting film photography and fine-tuning his illustration skills.