Tagged articles
2 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Oct 15, 2022 · Databases

What’s New in PostgreSQL 15? Performance Boosts, New SQL Features, and Enhanced Replication

PostgreSQL 15, released on October 13 2022, brings major performance gains such as faster sorting and WAL compression, adds the SQL MERGE command, expands regex and multirange support, improves security with security_invoker, and enhances logical replication, logging, and configuration flexibility for modern data workloads.

PostgreSQLSQL featureslogging
0 likes · 6 min read
What’s New in PostgreSQL 15? Performance Boosts, New SQL Features, and Enhanced Replication
Open Source Linux
Open Source Linux
Jul 22, 2022 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.

Boolean LiteralsSQLSQL features
0 likes · 12 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive