Imagine a bacon-wrapped Ferrari. Still not better than our free technical reports.

Java Tools and Technologies Landscape for 2014

Databases: SQL & NoSQL

Some years ago, no one would have thought that the Oracle / MySQL / SQL Server leadership could be challenged by a newcomer, but we at Data Geekery think that PostgreSQL is the most promising database of this decade, elegantly combining relational and many non-relational / NoSQL concepts.
      – Lukas Eder, CEO of Data Geekery GmbH

Java tools and technologies landscape 2014 SQL NoSQL or both graph

In the world of databases, opinions can run hot. The SQL vs NoSQL vs Something Even Better debate continues to rage at some level, and when we looked at the results we found that a large minority of the 2164 respondents use both (39%), seeing advantages of using SQL and NoSQL technologies in conjunction: as our own engineers will tell you, the high-performance SQL is great at querying websites and other real-time services, whereas NoSQL is better at handling frequently-changing data structures, namely in regards to reporting and configuration.

While 4 out of 10 engineers are using both technologies in peace, the rest are divided into camps: SQL only (53%), NoSQL only (4%) and None (4%).

Java tools and technologies landscape 2014 primary SQL technology graph

We normalized the numbers to exclude non-users (8%) in total, and what we see is a pretty mature market layout with several strong contenders of both open-source and commercial flavors.

MySQL (32%), the original relational database management system (RDBMS) folks, were bought by Sun Microsystems in 2008 and probably became one of many compelling factors for the acquisition of Sun by Oracle in 2010. So, if you combine this with the market share of Oracle DB (30%), Oracle effectively maintains nearly two-thirds of the SQL market.

The third-place upcomer is PostgreSQL (19%), an object-relational object-relationship database management system (ORDMBS), and is run by a consortium of volunteers as the PostgreSQL Global Development Group. The final one-fifth of the market is led by MS SQL (8%), DB2 (4%), H2 (2%) and a dozen more.

Java tools and technologies landscape 2014 primary NoSQL technology graph

We find that developers are using NoSQL databases like MongoDB more and more, for the advantages they provide over traditional relational databases: agility & scalability. Developers love that flexible schemas allow them to develop rapidly and adapt easily to changes in the data model; and the high availability and replication out of the box suits DevOps nicely.

      – Trisha Gee, Developer / Evangelist at MongoDB

In the NoSQL world – remember, that stands for “Not Only SQL”, not “No SQL” – things are a bit more fragmented. This area is less mature than the SQL landscape, and among the developers using NoSQL, which is less than half of our respondents, MongoDB (56%) is clearly leading the pack. The rest of the bunch are relatively new and some are supported by powerful organizations like Apache and Pivotal.

Here we have Apache Cassandra (10%), Redis (9%), Hazelcast (5%) and Neo4J (3%), and a couple dozen more minor projects out there make up the final Other (17%) section.