35 Open Source Database engines

The article they have prepared is fantastic in WebResourcesDepot in which they tell us about the great possibilities we have when choosing a database engine in the Open Source field.


As indicated in the article, you probably know the main alternatives (some of them commercial):

As indicated in that text, it is normal that these options are so widespread: they are very well documented, there is a large community of users behind all of them and are highly integrated with the majority of CMS on the market, in addition to being available in the main hosting companies. But there is a whole world of possibilities that goes beyond those options.

Proves it the aforementioned article, of which I will simply make an adaptation and that I recommend you visit. The 35 Open Source alternatives in this field are the following, and first of all, let me apologize for the translation. I'm not familiar with many of the terms that are handled in the article so I may have screwed up some description:

MongoDB

It is a high-performance, scalable, schema-free Open Source database (I think this means that it is not a conventional relational database, although I'm not entirely sure) and document-oriented (JSON-type data schemas ). There are drivers prepared to use this database from languages ​​such as PHP, Python, Perl, Ruby, JavaScript, C ++ and many more.

hyper table

Hypertable is a high-performance distributed data storage system designed to support applications that require maximum performance, scalability, and efficiency. It has been designed and modeled after Google's BigTable project and focuses primarily on large-scale data sets.

Apache CouchDB

As in the case of MongoDB, this project is intended to provide a document-oriented database that can be queried or indexed in MapReduce mode using JavaScript. CouchDB offers a RESTful JSON API that can be accessed from any environment that supports HTTP requests.

Neo4j

It is a completely transactional persistence engine in Java that stores data through graphs, not tables. Neo4j offers massive scalability. It can handle graphs of several billion nodes / relationships / properties on a single machine, and it can be scaled across multiple machines.

Ripples

Riak is an ideal database for web applications and combines:

  • A store with a decentralized key value
  • A flexible map / reduce engine
  • A friendly HTTP / JSPN query interface.

Oracle BerkeleyDB

It is an embedded database engine that provides developers with fast and efficient local persistence with zero administration. Oracle Berkeley DB is a library that links directly into our applications and allows simple function calls instead of sending messages to a remote server to improve performance.

Apache cassandra

Cassandra is probably one of the best known NoSQL projects on the market. It is a second generation distributed database with high scalability that is being used by giants such as Facebook (which is who has developed it), Digg, Twitter, Cisco and more companies. The goal is to provide a consistent, fault-tolerant, and highly available environment for storing data.

Memcached

Memcached is a store of type in-memory key-value for small arbitrary data strings (texts, objects) from results of database calls, API calls, or page rendering. It is geared towards accelerating dynamic web applications by easing the load on the database.

Firebird

Firebird -not to be confused with Firefox- is a relational database that can be used on Linux, Windows and various UNIX platforms, and offers high performance and powerful language support for stored procedures and triggers.

Redis

Redis is an advanced fast key-value database that It is written in C and can be used as memcached, ahead of a traditional database, or by itself independently. It has support for various programming languages ​​and is used in very popular projects such as GitHub or Engine Yard. There is also a PHP client called Rediska that allows managing Redis databases.

HBase

HBase is a column-oriented distributed store which can also be referred to as the Hadoop database. The project is aimed at offering huge tables of “billions of rows, and millions of columns”. It has a RESTful gateway that supports XML, Protobug and binary data encoding options.

keyspace

It is a key-value type store with consistent replication and that works on Windows operating systems. Keyspace offers high availability by masking network and server failures and appearing as a single high availability service.

4store

4store is a database and query storage engine that maintains data in RDF format. It is written in ANSI C99, is designed to run on UNIX systems, and offers a high-performance, scalable, and stable platform.

MariaDB

MariaDB is a backward compatible branch of MySQL® Database Server. It includes support for most of the Open Source storage engines, and also for the Maria storage engine itself.

Drizzle

It is a fork of MySQL that focuses on being an efficient and stable database, especially optimized for Internet applications and that follow the Cloud Computing philosophy.

hypersql

It is a relational SQL database engine written in Java. HyperSQL offers a small but fast database engine that has in-memory and disk-based tables, and that supports embedded and server modes. In addition, it has tools such as a SQL command console and a graphical interface for queries.

MonetDB

MonetDB is a database system for high-performance applications aimed at data mining, OAP, GIS, XML searches, and collection of information from text and multimedia files.

persevere

It is an object storage engine and application server (running in Java / Rhino) that provides dynamic JSON data storage for rapid development of JavaScript-based, data-oriented Internet applications.

eXist-db

eXist-db is developed through XML technology. It stores CML data according to the data model of this standard, and is characterized by an efficient and index-based processing of XQuery.

other alternatives

Seen in | Very Linux


Leave a Comment

Your email address will not be published. Required fields are marked with *

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.