• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

SQL vs NoSQL

 
Greenhorn
Posts: 27
Google Web Toolkit Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The subtitle of your book includes MongoDB. What guidance would you offer for choosing between an SQL and NoSQL database? For applications installed on customers hardware, there can be reluctance in larger DP shops to applications that do not use a major SQL database.
 
Sheriff
Posts: 67537
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the nature of the data? You want to choose the DB based upon which would actually suit the data model best; not fads or buzzwords.
 
Ranch Hand
Posts: 310
18
MS IE Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In very huge generalization: When you have data with complex structure, then relational databases (SQL). When you have data that can be simply arranged as key-value, then non-relational databases (NoSQL).

In reality, you need to learn both to know the best which one to choose. When I was playing at first with NoSQL, I was thinking that moving from MySQL to Apache Cassandra will be an easy task. I couldn't be more wrong, and eventually it turned out that Cassandra is totally not a way to handle the kind of data I had.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic