SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta

SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta ...

giovedì 16 luglio 2026 New tab

728 words~3 min read

Today's Highlights

This week's database news highlights a critical discussion on SQLite's internal memory management for Windows, a major performance-boosting compression change planned for PostgreSQL 19, and the beta release of Spock 6 for multi-master PostgreSQL replication.

Discussion on Dropping SQLITE_WIN32_MALLOC Support (SQLite Forum)

Source: https://sqlite.org/forum/info/e280641d16b70a0980c5409280cfda598b2141a41cbd63be86e943ea334f346f

SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta

SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta

Related reading

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture

DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm

Related reading

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture

DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm