NoSQL Options for Java Developers

比眉伴天荒 2022-06-05 12:19 228阅读 0赞

#### The Java community is one I know and love, so even though a NoSQL database is rarely tied to a language I’m writing this article for you, Java developers around the world. In this article, I’ll show you several options for NoSQL databases. After exploring all the options, I’ll narrow the choices down to the top five based on Indeed Jobs, GitHub stars, and Stack Overflow tags. Then I’ll let you know if they’re supported by Spring Data and Spring Boot. ####

#### Why NoSQL? ####

#### NoSQL databases have helped many web-scale companies achieve high scalability through[eventual consistency][]: because a NoSQL database is often distributed across several machines, with some latency, it guarantees only that all instances will eventually be consistent. Eventually consistent services are often called BASE (basically available, soft state, eventual consistency) services in contrast to traditional ACID properties. ####

#### Selecting NoSQL Candidates ####

#### Defining the top five can be difficult. Many folks have attempted to this recently. See the Research & Notes section at the end of this article for reference. ####

#### In mid-August, I told my followers on Twitter that I was writing this article. I asked for good/bad stories about NoSQL databases and received a number of options people wanted me to include. ####

#### I'm writing an article about NoSQL options for[@Java][Java] developers. I'd be happy to hear what you prefer, as well as good/bad stories in production. ####

#### — Matt Raible (@mraible) [ August 15, 2017][August 15_ 2017] ####

#### I received many suggestions, listed in alphabetical order below: ####

#### 1. ArangoDB ####

#### 2. Cassandra ####

#### 3. Couchbase ####

#### 4. DynamoDB ####

#### 5. FaunaDB ####

#### 6. Hazelcast ####

#### 7. MongoDB ####

#### 8. Neo4j ####

#### 9. PostgreSQL JSON ####

#### 10. Redis ####

#### 11. (JetBrains) Xodus ####

#### People also mentioned [Hibernate OGM][] (JPA for NoSQL) and [ NoSQLUnit][NoSQLUnit] as tools to help access and test NoSQL databases. ####

#### Note that I didn’t receive any requests for CouchDB, HBase, Elasticsearch, or Solr. CouchDB and Couchbase are often confused because of similar names, but[they’re quite different][they_re quite different]. Since CouchDB is a document store, I included it in my rankings. I also added HBase since it is mentioned by ITBusinessEdge, KDnuggets, and DB-Engines (in Research & Notes section). I didn’t include Elasticsearch or Solr because I believe those aren’t often used as the primary data store. ####

#### Raible’s Ranking Technique ####

#### I used Indeed Jobs, GitHub Stars, Stack Overflow tags, and Docker pulls to develop my system of ranking the top five NoSQL databases. ####

#### Indeed Jobs ####

#### I searched on [ Indeed Jobs][Indeed Jobs] without a location and found very few surprises, save for Amazon’s DynamoDB showing up as a top contender. ####

#### [![clip\_image002][clip_image002]][clip_image002_clip_image002] ####

#### Indeed Jobs, September 2017 ####

#### NOTE: It’s difficult to search for “PostgreSQL JSON” because most listings specify “PostgreSQL” as a requirement, not its NoSQL support. I searched for “postgres + json”. Xodus is the name of a company, so I had to tack on “JetBrains” to ensure accurate results. ####

#### GitHub Stars ####

#### I searched and found the top five NoSQL options by GitHub stars are Redis, MongoDB, ArangoDB, Neo4j, and Cassandra. ####

#### [![clip\_image004][clip_image004]][clip_image004_clip_image004] ####

#### GitHub Stars, September 2017 ####

#### NOTE: Cassandra, HBase, PostgreSQL are mirrored repositories. DynamoDB, Couchbase, and FaunaDB don’t have their servers on GitHub, so I counted stars for their Java-based drivers. Using number of stars for each option’s Java driver is a good idea, but [ there’s 11 just for Redis][there_s 11 just for Redis]. ####

#### You can use Tim Qian’s [ star-history project][star-history project] to see the star growth of these five. ####

#### [![clip\_image006][clip_image006]][clip_image006_clip_image006] ####

#### GitHub Star History ####

#### Stack Overflow Tags ####

#### I searched on Stack Overflow for tags for each and found that MongoDB and PostgreSQL are the most popular, followed by Neo4j, Cassandra, and Redis. ####

#### [![clip\_image008][clip_image008]][clip_image008_clip_image008] ####

#### Stack Overflow Tags, September 2017 ####

#### Docker Pulls ####

#### I searched on [ Docker Hub][Docker Hub] for images and found the stats to be 10M+ for a few, 5M+ for Neo4j, and 1M+ for many others. FaunaDB and JetBrains Xodus don’t seem to have images available. ####

#### [![clip\_image010][clip_image010]][clip_image010_clip_image010] ####

#### Docker Pulls, September 2017 ####

#### After gathering this information, it didn’t seem very relevant to include these stats in my ranking. My reason is two-fold: because the numbers aren’t exact and because there weren’t “official” images for each option. ####

#### NoSQL Options Matrix ####

#### I created a matrix to combine jobs, stars, and tags. I awarded 1-5 points based on the ranking they scored in each category. If an option didn’t make the top five, it received a zero. The results – MongoDB, Redis, Cassandra, Neo4j, and PostgreSQL – are in the table below. <table> <tbody> <tr> <td> NoSQL Option </td> <td> Jobs </td> <td> Stars </td> <td> Tags </td> <td> Total </td> </tr> <tr> <td> MongoDB </td> <td> 5 </td> <td> 4 </td> <td> 5 </td> <td> 14 </td> </tr> <tr> <td> Redis </td> <td> 3 </td> <td> 5 </td> <td> 1 </td> <td> 9 </td> </tr> <tr> <td> Cassandra </td> <td> 4 </td> <td> 1 </td> <td> 2 </td> <td> 7 </td> </tr> <tr> <td> Neo4j </td> <td> 0 </td> <td> 2 </td> <td> 3 </td> <td> 5 </td> </tr> <tr> <td> PostgreSQL </td> <td> 0 </td> <td> 0 </td> <td> 4 </td> <td> 4 </td> </tr> <tr> <td> ArangoDB </td> <td> 0 </td> <td> 3 </td> <td> 0 </td> <td> 3 </td> </tr> <tr> <td> HBase </td> <td> 2 </td> <td> 0 </td> <td> 0 </td> <td> 2 </td> </tr> <tr> <td> DynamoDB </td> <td> 1 </td> <td> 0 </td> <td> 0 </td> <td> 1 </td> </tr> <tr> <td> Couchbase </td> <td> 1 </td> <td> 0 </td> <td> 0 </td> <td> 1 </td> </tr> <tr> <td> CouchDB </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> </tr> <tr> <td> Hazelcast </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> </tr> <tr> <td> JetBrains Xodus </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> </tr> <tr> <td> FaunaDB </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> <td> 0 </td> </tr> </tbody> </table> ####

#### If you look at [DB-Engines Ranking][] for their top five options, you’ll find PostgreSQL, MongoDB, Cassandra, Redis, and HBase. ####

#### [![clip\_image012][clip_image012]][clip_image012_clip_image012] ####

#### DB-Engines Ranking, September 2017 ####

#### Will you look at that - our top five results are pretty close! ####

#### Overview of NoSQL Options ####

#### Since my top five results are pretty close to what DB-Engines has, I’ll use mine as the top five. Below is an overview of each one, along with information about their Spring Boot support. ####

#### You might ask “Why Spring Boot?” My answer is simple: because Spring Boot adoption is high. According to[Redmonk’s recent look at Java frameworks][Redmonk_s recent look at Java frameworks], Spring Boot adoption grew 76% between September 2016 and June 2017. ####

#### [![clip\_image014][clip_image014]][clip_image014_clip_image014] ####

#### The Spring Boot Explosion ####

#### And things haven’t slowed down since June:[Maven downloads in August 2017 were 22.2 million][]. ####

#### MongoDB ####

#### MongoDB was founded in 2007 by the folks behind DoubleClick, ShopWiki, and Gilt Groupe. It uses the Apache and GNU-APGL licenses on[GitHub][]. Its many large customers include Adobe, eBay, and eHarmony. ####

#### l Available on start.spring.io? Yes, including embedded MongoDB for testing. ####

#### l Supported by Spring Data? Yes, via[Spring Data MongoDB][]. ####

#### l Bonus: Supported by Hibernate OGM, NoSQLUnit, and[JHipster][]. ####

#### Redis ####

#### Redis stands for REmote Dictionary Server and was started by[Salvatore Sanfilippo][]. It was initially released on April 10, 2009. According to[redis.io][], Redis is a BSD-licensed in-memory data structure store and can be used as a database, cache, and message broker.[Well known companies using Redis][] include Twitter, GitHub, Snapchat, and Craigslist. ####

#### l Available on start.spring.io? Yes. ####

#### l Supported by Spring Data? Yes, via[Spring Data Redis][]. ####

#### l Bonus: Supported by NoSQLUnit. Hibernate ORM support is in progress. ####

#### Cassandra ####

#### [Cassandra][] is “a distributed storage system for managing structured data that is designed to scale to a very large size across many commodity servers, with no single point of failure” (from [ “Cassandra – A structured storage system on a P2P Network”][_Cassandra _ A structured storage system on a P2P Network] on the Facebook Engineering blog). It was initially developed at Facebook to power its Inbox Search feature. Its creators, Avinash Lakshman (one of the creators of Amazon DynamoDB) and Prashant Malik, released it as an open-source project in July 2008. In March 2009, it became an Apache Incubator project and graduated to a top-level project in February 2010. ####

#### In addition to Facebook, Cassandra helps a number of other companies achieve web scale. It has some[impressive numbers about scalability on its homepage][]. ####

#### One of the largest production deployments is Apple’s, with over 75,000 nodes storing over 10 PB of data. Other large Cassandra installations include Netflix (2,500 nodes, 420 TB, over 1 trillion requests per day), Chinese search engine Easou (270 nodes, 300 TB, over 800 million requests per day), and eBay (over 100 nodes, 250 TB). ####

#### l Available on start.spring.io? Yes. ####

#### l Supported by Spring Data? Yes, via[Spring Data Cassandra][]. ####

#### l Bonus: Supported by NoSQLUnit and JHipster. Hibernate ORM support is in progress. ####

#### Neo4j ####

#### Neo4j is available as GPL3-licensed “community edition” with some extensions licensed under the Affero GPL. The community edition is limited to running on one node and does not contain clustering support or hot backups. Neo4J’s “enterprise edition” has scale-out capabilities, in-memory page cache, and hot backups. A 30-day trial is available; no pricing is provided. ####

#### Neo4j is best known as a graph database, where everything is stored as an edge, node, or an attribute. Version 1.0 was released in February 2010 and has been developed by Neo4j, Inc. since its beginning. Its[large customers][] include Walmart, Airbnb, Monsanto, and eBay. ####

#### l Available on start.spring.io? Yes. ####

#### l Supported by Spring Data? Yes, via[Spring Data Neo4j][]. ####

#### l Bonus: Supported by Hibernate ORM and NoSQLUnit. ####

#### PostgreSQL JSON ####

#### PostgreSQL is a traditional relational database management system (RDBMS) that has NoSQL support via its native JSON support (added in version 9.2). In 9.4, they added support for Binary JSON (aka[JSONB][]) and indexes. ####

#### Leigh Halliday explains how you can[unleash the power of storing JSON in Postgres][] in a blog post dated June 2017. Halliday goes on to show how this can be used with Ruby on Rails. A blog post from Umair Shahid shows[how to process PostgreSQL JSON & JSONB data in Java][how to process PostgreSQL JSON _ JSONB data in Java]. ####

#### I’m not sure that PostgreSQL and its JSON support should be included as a recommend NoSQL option. However, it likely makes sense if you’re already using PostgreSQL and want to make your data schema more free-flowing. As [ Dj Walker-Morgan says][Dj Walker-Morgan says], “PostgreSQL 9.5 isn’t your next JSON database, but it is a great relational database with a fully fledged JSON story.” ####

#### l Available on start.spring.io? Yes. ####

#### l Supported by Spring Data? Yes, via[Spring Data JPA][]. ####

#### Recommendation ####

#### I feel good about how this analysis played out, and as a committer on the[JHipster][] project, I’m both well aware of the strength of that team and think that its support for MongoDB and Cassandra is a pretty strong endorsement. It’s interesting to see that there’s[work-in-progress to add Couchbase][] too. ####

#### But I’m not stopping there. I shared this analysis with a few experts I know in the Java and NoSQL communities and asked them the following questions: ####

#### 12. Do you agree with my choices of the top 5 NoSQL options (MongoDB, Redis, Cassandra, Neo4j, and PostgreSQL with its JSON support)? ####

#### 13. Do you have any good or bad stories about using any of these databases in production? ####

#### 14. Have you found any of these databases particularly difficult to get started with or maintain over time? ####

#### 15. What is your favorite NoSQL database and why? ####

#### 16. Anything else you’d like to share? ####

#### Please check back in a few weeks! I’ll post the answers to these questions from the experts I interviewed. I’ll also update this post to point to it when I do. If you’re an expert on NoSQL databases, let me know! I’d be happy to include your answers in the interview. Just send me a message to[@mraible on Twitter][mraible on Twitter] or matt.raible@okta.com. ####

#### Update:[Part II has been published][]. Many thanks to Justin McCarthy, Rafal Glowinski, Vlad Mihalcea, and Laurent Doguin for answering these questions! ####

#### Research & Notes ####

#### ITBusinessEdge has a [ slideshow about the top five NoSQL databases][slideshow about the top five NoSQL databases]. However, there’s no date on the article, and it says Redis Labs made the selection. The slideshow lists MongoDB, Cassandra, Redis, Cassandra, CouchDB, and HBase. ####

#### [Matthew Mayo][], editor of KDnuggets, wrote a similar article about[Top NoSQL Database Engines][] in June 2016. Mayo used [ db-engines.com ranking][db-engines.com ranking] and Google Trends to select the top five: MongoDB, Cassandra, Redis, HBase, and Neo4j. ####

#### Hackernoon has an [ Infographic of the most popular NoSQL databases][Infographic of the most popular NoSQL databases] that are “worth your notice.” This article is from June 2017, and the comments say the rankings are based on stats from[https://db-engines.com/en/ranking\_trend][https_db-engines.com_en_ranking_trend]. ####

#### [![clip\_image016][clip_image016]][clip_image016_clip_image016] ####

#### Hackernoon Infographic ####

#### NOTE: If you look at this ranking today (September 6, 2017), you’ll see that Redis has replaced Couchbase. Or maybe Hackernoon skipped over Redis? It also begs the question: is Elasticsearch a NoSQL database, or a search engine? Should Solr be considered a NoSQL database as well? Both show up in[DB-Engines Ranking Trends][https_db-engines.com_en_ranking_trend]. ####

#### [![clip\_image018][clip_image018]][clip_image018_clip_image018] ####

#### DB-Engines Ranking Graph ####

#### JAXenter published the results of their annual survey of[top database trends][] on March 30, 2017. They list Elasticsearch and Solr as databases. They also include Apache Spark and Hadoop. MongoDB, Cassandra, Redis, and Neo4j are the most interesting “NoSQL” databases. Hazelcast is listed as the top in-memory data grid, over CouchDB and Oracle. ####

#### [![clip\_image020][clip_image020]][clip_image020_clip_image020] ####

#### JAXenter Top Database Trends ####

#### Changelog: ####

#### l Oct 10, 2017: Updated to link to[Part II blog post][Part II has been published] with answers from experts. ####

### ###

#### [https://developer.okta.com/blog/2017/09/08/nosql-options-for-java-developers][https_developer.okta.com_blog_2017_09_08_nosql-options-for-java-developers] ####

[eventual consistency]: https://en.wikipedia.org/wiki/Eventual_consistency
[Java]: https://twitter.com/java
[August 15_ 2017]: https://twitter.com/mraible/status/897492857170280448
[Hibernate OGM]: http://hibernate.org/ogm/
[NoSQLUnit]: https://github.com/lordofthejars/nosql-unit/
[they_re quite different]: https://www.couchbase.com/couchbase-vs-couchdb
[Indeed Jobs]: https://www.indeed.com/jobs
[clip_image002]: https://img-blog.csdn.net/20171127205834447
[clip_image002_clip_image002]: /images/20220605/93bb35f71d29425fa5e342793b7e3d3b.png
[clip_image004]: https://img-blog.csdn.net/20171127205835567
[clip_image004_clip_image004]: /images/20220605/3add861723884b2084d77d77473b663e.png
[there_s 11 just for Redis]: https://redis.io/clients#java
[star-history project]: https://github.com/timqian/star-history
[clip_image006]: https://img-blog.csdn.net/20171127205836592
[clip_image006_clip_image006]: /images/20220605/bd4e71aa68dc46da9eff1d1ca4fc6b25.png
[clip_image008]: https://img-blog.csdn.net/20171127205837594
[clip_image008_clip_image008]: /images/20220605/1c879e3217b04a07a223dfa124427360.png
[Docker Hub]: https://hub.docker.com/
[clip_image010]: https://img-blog.csdn.net/20171127205838344
[clip_image010_clip_image010]: /images/20220605/f1ad07a3dbe94309abcc63042c5d852d.png
[DB-Engines Ranking]: https://db-engines.com/en/ranking
[clip_image012]: https://img-blog.csdn.net/20171127205839277
[clip_image012_clip_image012]: /images/20220605/2df30776b8504236bbe71defc2f77659.png
[Redmonk_s recent look at Java frameworks]: http://redmonk.com/fryan/2017/06/22/language-framework-popularity-a-look-at-java-june-2017/
[clip_image014]: https://img-blog.csdn.net/20171127205839975
[clip_image014_clip_image014]: /images/20220605/0c7181cce32248278babe0dc6ef5ee3b.png
[Maven downloads in August 2017 were 22.2 million]: https://twitter.com/PieterHumphrey/status/905131222094929920
[GitHub]: https://github.com/mongodb/mongo
[Spring Data MongoDB]: https://projects.spring.io/spring-data-mongodb/
[JHipster]: http://www.jhipster.tech
[Salvatore Sanfilippo]: http://invece.org/
[redis.io]: https://redis.io/
[Well known companies using Redis]: https://redis.io/topics/whos-using-redis
[Spring Data Redis]: https://projects.spring.io/spring-data-redis/
[Cassandra]: http://cassandra.apache.org/
[_Cassandra _ A structured storage system on a P2P Network]: https://www.facebook.com/notes/facebook-engineering/cassandra-a-structured-storage-system-on-a-p2p-network/24413138919
[impressive numbers about scalability on its homepage]: http://cassandra.apache.org
[Spring Data Cassandra]: https://projects.spring.io/spring-data-cassandra
[large customers]: https://neo4j.com/customers/
[Spring Data Neo4j]: https://projects.spring.io/spring-data-neo4j
[JSONB]: https://www.postgresql.org/docs/current/static/datatype-json.html
[unleash the power of storing JSON in Postgres]: https://blog.codeship.com/unleash-the-power-of-storing-json-in-postgres/
[how to process PostgreSQL JSON _ JSONB data in Java]: https://blog.2ndquadrant.com/processing-json/
[Dj Walker-Morgan says]: https://www.compose.com/articles/could-postgresql-9-5-be-your-next-json-database/
[Spring Data JPA]: https://projects.spring.io/spring-data-jpa/
[work-in-progress to add Couchbase]: https://github.com/jhipster/generator-jhipster/issues/6086
[mraible on Twitter]: https://twitter.com/mraible
[Part II has been published]: https://developer.okta.com/blog/2017/10/10/nosql-options-for-java-developers-part-ii
[slideshow about the top five NoSQL databases]: http://www.itbusinessedge.com/slideshows/top-five-nosql-databases-and-when-to-use-them.html
[Matthew Mayo]: https://twitter.com/mattmayo13
[Top NoSQL Database Engines]: http://www.kdnuggets.com/2016/06/top-nosql-database-engines.html
[db-engines.com ranking]: http://db-engines.com/en/ranking
[Infographic of the most popular NoSQL databases]: https://hackernoon.com/top-4-nosql-databases-infographic-b6acc389befc
[https_db-engines.com_en_ranking_trend]: https://db-engines.com/en/ranking_trend
[clip_image016]: https://img-blog.csdn.net/20171127205841030
[clip_image016_clip_image016]: /images/20220605/16010a7c4d694e708095e4602237b2a0.png
[clip_image018]: https://img-blog.csdn.net/20171127205841941
[clip_image018_clip_image018]: /images/20220605/56d39a1098fe4655821422fe34db0619.png
[top database trends]: https://jaxenter.com/top-databases-2017-132912.html
[clip_image020]: https://img-blog.csdn.net/20171127205843065
[clip_image020_clip_image020]: /images/20220605/e1e8b4b686914100a66429b5f490fd4c.png
[https_developer.okta.com_blog_2017_09_08_nosql-options-for-java-developers]: https://developer.okta.com/blog/2017/09/08/nosql-options-for-java-developers