Issue 285 - A bumper sized 2019 roundup (21)

Programming the SQL Way with Common Table Expressions — Bruce Momjian discusses common table expressions (CTEs) and the ability to allow queries to be more imperative. View the on-demand webinar.

Big News In Databases – Fall 2019 — Industry veteran Markus Winand often does quarterly looks back at the biggest database news of the past quarter. This is his fall 2019 update. We’ve covered many of these items but Markus adds an extra level of depth and insight you might appreciate.

2019: A Big Data Year in Review — Datanami reflects on 10 big data trends they said ‘to watch in 2019’ by looking at what actually unfolded.

AresDB: Uber’s Go and GPU-Powered Real-Time Analytics Engine — It uses GPUs to enable real-time data processing in parallel.

Amazon Released DocumentDB, a Document Database with 'MongoDB Compatibility' — AWS kicked off 2019 by competing with MongoDB’s own Atlas service by offering DocumentDB, a scalable, highly available, and fully managed document database service that supports MongoDB workloads. GeekWire reported on the background to the story.

Senior Support Engineer - Severalnines (EU Timezone) — We're looking for a great engineer to join our support team to help people who use our flagship product, ClusterControl.

ksqlDB: An Event Streaming Database for for Stream Processing Applications — A scalable, real-time event streaming database for Apache Kafka which makes stream processing accessible via a familiar, lightweight SQL syntax. Built in Java. Datanami has a more editorial writeup of the project too.

SQL Server 2019 Now Generally Available — The newest major version of SQL Server is here. A focus has been placed on security with extended ‘always encrypted’ support, the T-SQL language has been extended (particularly in regards to communicating with other, third party databases), and ‘Intelligent Query Processing’ provides new ways to optimize queries for performance.

SQLite 3.30.0 Released — SQLite is such an unsung workhorse of the entire software ecosystem and continues to get better all the time. This latest release adds support for the FILTER clause on aggregate functions and more.

TerminusDB: A New Open Source Graph Database — Billing itself as a database ‘built for data people’, Terminus is a model-driven graph database built in Prolog(!) GitHub repo.

Try Studio 3T: The best way to get started with MongoDB — Code translation in a click? Easy SQL to MongoDB Migration? We’ve got it - and more. Get your 30-day trial today to see.

PostgreSQL 12 Released — Only a year on from Postgres 11 comes version 12, another strong step forward for the popular relational database. Key enhancements include SQL/JSON support, generated columns, and significant performance improvements (particularly with indexes and partitioned tables). BTW, if you’re a Postgres user, be sure to subscribe to our Postgres newsletter.

Yugabyte DB 2.0 GA: A 'Jepsen Tested', High-Performance Distributed SQL DBMS — Yugabyte DB is a Google Spanner-inspired, cloud-native distributed SQL database that’s 100% open source and aims to be Postgres compatible in most cases.

New Query Language for Graph Databases to Become International Standard — GQL is set to be the first new ISO-standardized database language since SQL and Neo4j are, perhaps unsurprisingly, strongly behind it. More background info here.

MongoDB 4.2 Released — The popular document-oriented database takes another step forward with support for distributed ACID transactions, on-demand materialized views, wildcard indexes, and retryable reads and writes (for handling transient cluster failures). Client-side field-level encryption is also in beta.

Amazon Announces PartiQL: A Universal, SQL-Compatible Query Language — PartiQL is a new query language that extends SQL to be able to support non-relational, schemaless and other data formats too. It’s open source and already in use internally in various AWS systems. One of its co-creators also created SQL++ (which saw implementation via Couchbase’s N1QL) several years ago.

CovenantSQL: An SQLite-Powered Byzantine-Fault Tolerant Distributed Relational Database — Written in Go, Covenant, also known as CQL, promotes itself as an alternative to Amazon’s Quantum Ledger Database.

Huawei Launches GaussDB, an 'AI-Backed Database' — The Chinese company better known for its cellphones has entered the enterprise business market with a database aiming to ‘redefine data infrastructure through a Data + Intelligence strategy’. Think self-turning, self-diagnosing and self-healing.. all concepts we can expect to see more of in databases over the next few years.

Find A Job Through Vettery — Vettery specializes in dev roles and is completely free for job seekers.

AWS Unveils a New, 'Open' Distribution of Elasticsearch — Elasticsearch is a popular document-oriented search and analytics engine/database and AWS is offering a new, purely open source distribution of it after concerns regarding recent additions of more proprietary features to the main project. (Look at the homepage's URL.. makes you wonder what they're planning next!)