I am spending some time researching various open source and cloud computing service providers using the exhibitors list for OSCON 2010. Audrey needs some tech research done, before she attends the event. She wants to be prepared So I'm going through each exhibitor and learning and documenting as much as I can.One thing I'm seeing is an explosion of open source database offerings, I'm counting seven systems (yes I didn't include Oracle):
I'm seeing a big shift away from the database world I've known for the last 15 years. Microsoft SQL Server, Access, Oracle, and MySQL. I'm seeing a big shift with cloud database providers like Amazon SimpleDB and Google Fusion Tables. And I"m seeing an all out mutiny with the NoSQL movement. Seeing all this energy and change with databases after 20 years in the business is really exciting.
- BlackRay - BlackRay is an innovative, fully relational in-memory database system designed to offer performance features commonly associated with search engines. It offers fulltext search, function based indeces, JDBC/ODBC via Postgres drivers as well as object oriented APIs. BlackRay is available under the GPLv2.
- DB Relay - DB Relay is an open source project built around the NGiNX web server platform, providing an HTTP/JSON interface to a variety of database servers. It enables database access without drivers and web application development without middleware. Designed for operational efficiency and ease of maintenance. Hosted at http://www.dbrelay.com/
- HTSQL by Prometheus Research - HTSQL by Prometheus Research is the easiest way to connect SQL databases to the web, reducing development time and minimizing mistakes. HTSQL uses simple URL queries, works with open source databases, and is a painless way to create data-driven reports, dashboards, and web applications fast and at low cost.
- Infobright, Inc - Infobright's high performance columnar database, based on MySQL, is the preferred choice for analytic applications and data marts, delivering fast query performance against large data volumes. Easy to implement, with unmatched operational simplicity, Infobright is being used by enterprises, SaaS and software companies to provide rapid access to critical business data. Download Infobright Community Edition and join the Community at infobright.org
- MariaDB - MariaDB is a database server that offers drop-in replacement functionality for MySQL. MariaDB is built by some of the original authors of MySQL, with assistance from the broader community of Free and open source software developers. In addition to the core functionality of MySQL, MariaDB offers a rich set of feature enhancements including alternate storage engines, server optimizations, and patches.
- MongoDB - 10gen sponsors the open source project MongoDB, and provides commercial support, consulting, and training for Mongo. MongoDB (from "humongous") is a scalable, high-performance, document-oriented database. MongoDB bridges the gap between key-value stores (which are fast and highly scalable) and traditional RDBMS systems (which provide rich queries and deep functionality).
- PostgreSQL - PostgreSQL is the world's most advanced and rapidly evolving open source database, with more than 20 years of development by a community of hundreds of database developers from dozens of countries. Our long time support of an enterprise level feature set including transactions, SQL standards compliance, aggregation and subqueries makes PostgreSQL suitable for large enterprises and governments. Easy extensibility through stored procedures and custom data objects makes PostgreSQL exciting for developers. Try PostgreSQL for your next database application!