Over a million developers have joined DZone.

Modern SQL: Inaugural Post

DZone's Guide to

Modern SQL: Inaugural Post

I've just launched my new website, Modern SQL. So what is Modern SQL about? Yet another SQL reference? Absolutely not. Modern SQL is different.

· Database Zone ·
Free Resource

Download the Altoros NoSQL Performance Benchmark 2018. Compare top NoSQL solutions – Couchbase Server v5.5, MongoDB v3.6, and DataStax Enterprise v6 (Cassandra).

I've just launched my new website, modern-sql.com. It's very small right now—just six content pages—but it will grow over the following month and years and might eventually become a book like Use-The-Inde-Luke.com did. So I though I'd better get you on board right now so you can grow as the site grows.

So what is Modern SQL about? Yet another SQL reference? Absolutely not. There are definitely enough references out there. And they all suffer from the same issues:

  • They hardly cover more than entry-level SQL-92. Some tutorials don't even mention that they describe a proprietary dialect.
  • The examples just show the syntax but not how to solve real-world problems.
  • They don't document the availability of the features amongst different database products.

No question, the latter ones are a consequence of the first one. However, Modern SQL is different:

  • Modern SQL covers SQL:2011—the current release of the ISO SQL standard. But it adheres to the fact that many databases are developed against elder releases or only support a subset of the standard.
  • Modern SQL shows how to use the most recent SQL features to solve real world problems. It also provides “conforming alternatives” as a way to solve the same problem using other (often older) standard methods. If necessary and possible it will also show “proprietary alternatives.” Note that there is a hierarchy: the recommended (most idiomatic) approach is shown first, standard conforming alternatives next, and proprietary alternatives last but only if inevitable.
  • Modern SQL documents the availability of the features amongst six SQL databases (the example is about values):  

Go here if you don't see an image above.

Click on a feature (e.g., “valid where select is valid”) to see how the availability of the features has evolved. Go here if you can't click a feature in the image above.

There you can see that SQLite just recently started to accept values whereselect is valid. The timeline view also documents the last checked version for those databases that don't support a feature.

Inevitably, Modern SQL will become both: an homage to the SQL standard and a rant about its poor adaptation. The availability documentation and the above mentioned alternative approaches (conforming or proprietary) are there to keep the “rant” a productive one. Look at the “select without from” use case to get the idea.

This is just the first step of a long journey. I invite you to follow it via Twitter, e-mail or RSS.

Download the whitepaper, Moving From Relational to NoSQL: How to Get Started. We’ll take you step by step through your first NoSQL project.

sql ,modern sql ,databases ,news ,announcement

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}