Menu

React, etc. Tech Stack

React, Flux, GraphQL, Hack, HHVM...? All of this and more!

They see SQL rollin', they hatin'

A few years back it felt like SQL was on it's way to the grave. Everyone was talking about how all kinds of NoSQL solutions were the absolute future and the solutions to all of life's problems. It felt like everything would be NoSQL in 2015

But as usual, once the hype runs out and most of the web sites and services you visit still keep using SQL - in one form or the other. Popular web publishing tools such as WordPress and Drupal rely on it as their main data source - and there is no major change in sight for them.

Advanced content management systems such as eZ Platform complement SQL storage engines with an integrated Solr search solution. There is a time and place for everything, and this applies to technology more than anything. Many forms of data is relational by nature and storing it in a document database is artificial.

Graph Database is the new NoSQL

Relational databases are very good in storing relational data (duh!), but this is what some people missed in the NoSQL hype. For relational data storage there is a better alternative to SQL. Graph Databases are a rising trend in the CMS space they offer many advantages (such as being natively relational) and there are initiatives like GraphQL and others to make them more universally adaptable.

No doubt Graph Databases will eat up a niche from traditional RDBMSes, just like search engines and Document Databases did. And while there are dialects of SQL, there is nothing comparable in the Graph Database world. Neo4j uses it's own Cypher language, GraphQL a higher level data query language.

The closest thing to SQL the Graph Database domain has is Gremlin:

Gremlin is a graph traversal language. The documentation herein will provide all the information necessary to understand how to use Gremlin for graph query, analysis, and manipulation. Gremlin works over those graph databases/frameworks that implement the Blueprints property graph data model.

I for one welcome our new Graph Database overlords, but I'm not going to sip their Kool-Aid.

The latest on Open Source SQL products

It feels like the last time MySQL was sexy was when people discovered that Query Cache could speed up queries like a motherfucker. Query Cache has since been turned to be harmful to performance in many cases.

Because SQL is so prevalent, there has been continuous investment in Open Source SQL databases across the board. Here are some significant news out lately, all related to popular Open Source SQL databases:

So today is a good day to start learning SQL: 18 Best Online Resources For Learning SQL and Database Concepts

Written by Jorgé on Tuesday October 20, 2015

Permalink - Tags: graphql, sql, mysql, mariadb, postgre, gremlin, graphdb

« Falcor is a new approach to APIs - A simplistic boilerplate for full stack React Development »