Feed: Planet PostgreSQL.
Don’t fall behind: Here’s the most important database news from the last six months.
SQL on The Rise
NoSQL pioneer Google writes that their Spanner database is becoming a SQL system (summary). Salesforce uses Artificial Intelligence to translate natural language to SQL. Even some ORM vendors say it is better to use SQL. Seems like SQL has a positive vibe.
The highly popular article “Why SQL is beating NoSQL, and what this means for the future of data” is a very nice write-up of why SQL had become frowned upon, and how it is now gaining new popularity right.
The Cloud War Continues
In July the opposite happened for users of Microsoft SQL Server: the cost of running the Standard Edition in Amazon’s AWS cloud was reduced by between 29 and 52 percent.
IBM’s Renaming Insanity
There is a saying that there are only two hard things in computer science: (0) cache invalidation, (1) naming things, (2) and off-by-one errors. In June, IBM renamed the products in the Db2 family and thereby demonstrated how to cause great harm by choosing poor names.
|Old Name||New Name|
|DB2 for LUW||Db2|
|DB2 for z/OS||Db2 for z/OS|
|DB2 for iSeries||Db2 for i|
Note the subtle but groundbreaking innovation to write the “b” in Db2 as a lower case letter.
All sarcasm aside: Previously, DB2 was a common element in the names of different products of the same family. The “for” addendum made a distinction between each product. As these products offer different features, the distinction is quite important.
The new name Db2 doesn’t allow this distinction anymore because it represents the whole family as well as one specific product. This lack of differentiation becomes a real problem when searching the internet: webpages about the former product DB2 for LUW might not contain “LUW” anymore. Reducing the iSeries addendum to i doesn’t improve searching either.
Wikipedia says “A name is a term used for identification.” I doubt the new names fulfill this purpose sufficiently.
One thing is for sure: the new naming is an upgrade for the LUW version. The reverse of this conclusion shines an interesting light on the other variants. IBM also looses grounds in the just published Gartner Magic Quadrant for Operational Databases 2017—it’s now far behind SAP and Amazon Web Services (AWS).
Other Vendors Rethink Release Numbering
The next major release of the Oracle Database will be 18c (instead of 220.127.116.11). New releases will be annual and the version will be the last two digits of the release year (see also: release roadmap).
Starting with the just released PostgreSQL 10, there is no dot in the major versions of PostgreSQL anymore.
New Database Releases
In the past six month there were three major releases among the most popular SQL databases.
- SQL Server 2017 (October 2017)
My personal picks from the “new features” list:
- PostgreSQL 10 (October 2017)
My favorite new features:
- MariaDB 10.2 (May 2017)
News on my Sites
Articles I published or updated: