Over a million developers have joined DZone.

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

Build fast, scale big with MongoDB Atlas, a hosted service for the leading NoSQL database. Try it now! Brought to you in partnership with MongoDB.

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.

Now it's easier than ever to get started with MongoDB, the database that allows startups and enterprises alike to rapidly build planet-scale apps. Introducing MongoDB Atlas, the official hosted service for the database on AWS. Try it now! Brought to you in partnership with MongoDB.

Topics:
sql ,modern sql ,databases ,news ,announcement

Published at DZone with permission of Markus Winand, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}