Database is an organized collection of relational data which includes tables, queries, views, reports and objects etc. Choosing a database for an application is the most difficult phase of project life cycle. There are many parameters which we need to consider while choosing the right database which meets our requirements. This article listed about 30+ available open source databases to store data from various sources such as Computer applications, Mobile apps etc.
Open Source licence:
All open source software projects and code is available for free under open source licence. Please make sure that you are aware of opens source licencing related information, terms of use and different policies associated to it before you download and use the open source software.
Open Source Databases list:
| Database | Description | Platform |
|---|---|---|
| Apache Drill | Apache Drill is one of the fastest query engine which combines both flexibility and speed. Drill supports NoSQL databases and file systems such as Google cloud, HBase, MongoDB NAS etc. Drill features JSON data model and provides intuitive extensions to SQL. | Windows Linux OS X |
| BlinkDB | BlinkDB is a massively parallel, approximate query engine for running interactive SQL queries on large volumes of data. It has an adaptive optimization framework and dynamic sample selection strategy. This is still Alpha release | Windows Linux |
| Cassandra | Apache Cassandra is the best choice when there is a need of linear scalability, availability, performance and fault tolerant. It offers powerful in-built caching, convenient column indexes, and strong support for de-normalization and materialized views. Currently used by Facebook, eBay, Twitter and many more. | OS Independent |
| Freebird | Freebird is a relational database which offers many ANSI SQL standard features, concurrency, high performance and powerful language support for stored procedures and triggers. | Windows Linux Unix OS X Solaris |
| CoachDB | Apache CoachDB is well suited for web applications. CoachDB stores data with JSON documents. The documents accessed on browsers via HTTP queried by JavaScript. CoachDB transform the document on-the-fly and real-time notifications for web apps. CoachDB has fault-tolerant storage engine, distributed scaling, administration console and many more. | Windows OS X Linux Android |
| FlockDB | FlockDB is a distributed social graph database, developed by Twitter to store social graph who follows whom and who blocks whom. | OS Independent |
| HBase | Apache HBase is widely used for Bigdata which can have billions of rows and millions of columns. Apache HBase is distributed, versioned, non-relational database model. HBase is the database for Hadoop | OS Independent |
| Hibari | Hibari DB is written in Erlang which is used for telecom applications to provide high availability, reliable, scalable and fast optimized read capabilities. Hibari DB stores data in the form of key value with the strong consistency, Hibari is processing 2200 transactions per second. | OS Independent |
| Hive | Apache Hive is the data warehouse for Hadoop which facilitates querying and managing large datasets residing in distributed storage. Hive used SQL-like language called HiveQL to query the data. | OS Independent |
| Hypertable | Hypertable delivers scalable database capacity with superior performance to speed-up the Bigdata application and reduces the hardware cost. A proven scalable design which is used by hundreds of Google services (Google’s Bigtable Design). Supported by programming languages such as Java, Node.js, PHP, Python, Perl, Ruby, C++ and more. Hypertable overlays on top of Hadoop to provide supercharged scalable database infrastructure for Bigdata applications. | Linux OS X |
| InfluxDB | InfluxDB is designed to store data from source such as Metrics, Real-time analytics and Sensor data etc. InfluxDB is written in Go. InfluxDB is an open source distributed time series database which has no external dependency. InfluxDB Supports SQL-like query language and built-in native HTTP API which makes easy to read/write data from JavaScript. Influx DB is allowed horizontal scaling. Built-in explorer is interactive which helps us to manage databases, users and permissions. | OS Independent |
| Infinispan | Infinispan is a distributed in-memory key/value data store with optional schema. It can be used as an embedded Java library and service accessed remotely over protocols such as REST, WebSockets, HotRed etc). Integration features supported such as JCache, Hibernate second-level Cache, WildFly modules, Spring Cache, CDI, OSGI, Apache Spark and Apache Hadoop etc. | OS Independent |
| Kexi | Kexi is an open-source visual database applications creator and can be used for creating database schemas, table insertions, queries and data processing. Kexi is also considered as open-source competitor for Microsoft Access, FileMaker and Oracle Forms. | Windows OS X Linux Unix |
| LucidDB | LucidDB is built for data warehousing and business intelligence. This is the first RDBMS open-source database. LucidDB is designed to meet the requirements of flexibility, high performance data integration and sophisticated query processing. | Windows Linux OS X |
| MongoDB | MongoDB is a most popular database system and designed to handle extremely large amount of data. | Windows OS X Linux Solaris |
| MySQL | MySQL is very most popular and widely used open-source database. Used by popular social websites such as Facebook, Twitter, Linkedin and business websites such as ebay, Amazon, Walmart, Booking.com PayPal etc. | Windows Linux OS X Unix |
– Article ends here –
If you have any questions, please feel free to share your questions or comments on the comment box below.
