immudb v1.0: A 'Tamper-Evident' Database with Immutable History — SQL support has been added and so the creators now boast immudb is the ‘first immutable database with relational capabilities’. Written in Go and Apache licensed.

Codenotary Inc

Amazon Redshift ML Now Generally Available — Redshift is Amazon’s cloud data warehouse that lets you use SQL to query and combine potentially exabytes (if you have the $!) of structured and semi-structured data.. and the ML extension goes a step further in training machine learning models to generate insights from data in your data warehouse. Even better, you can do all of this with SQL.

Danilo Poccia (AWS)

Comparing Fauna and DynamoDB: Features & Pricing — Fauna and DynamoDB are both serverless databases, but their design goals, architecture, and use cases are very different. This post discusses where they shine, where they don’t, and how they offer fundamentally different value propositions.

Fauna sponsor

An Early Look at Postgres 14: Performance and Monitoring Improvements — Last week we featured the Postgres 14 beta 1 release, and now people are starting to chew over it and see where the underlying improvements are. Small, steady, and reliable improvements seem to be the order of the day.

Lukas Fittl

Rethinking Postgres in a Post-Server World — The increasing popularity of ‘serverless’ solutions is having an impact on databases with entire paradigms (e.g. the DynamoDB model) and new services (e.g. Fauna) being created or extended to support serverless use cases. Michael Rispoli shares his thoughts on how databases created in the pre-serverless era can fit into this new world.

Michael Rispoli

SQL Query Optimization: Understanding Some Key Principles — An interesting benchmark-led guide to how different SQL approaches scale upon different sized tables.

Ivan Borshchov

Why Are Time Series Databases Important Now? — Learn what time series is, what makes it different from stream processing, full-text search and other solutions.

INFLUXDATA sponsor

A Look at a Variety of 'Free' Cloud Database Services — In reality, some of these are enterprise-y options that have free developer or trial tiers, but still, it’s a reasonable roundup.

Nebojsa Radakovic

SQLite fdw 2.0.0 Released for PostgreSQL — A foreign data wrapper to work with SQLite from Postgres 9.6, 10, 11, 12, and 13. GitHub repo.

Toshiba Software Engineering

ClangQL: Query C++ Codebases using SQLite — An interesting experiment. clangd is a language server for parsing and processing C++ code and ClangQL then adds SQLite as an intermediary so you can use SQL to ‘query’ the codebase in question.

Francesco Bertolaccini