Back to feed
Dev.to
Dev.to
7/16/2026
The original title is: "SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta"

The original title is: "SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta"

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

Short summary

A database news roundup covering three developments: potential removal of SQLite's Win32 Malloc compile-time option, PostgreSQL 19's planned shift from pglz to LZ4 for TOAST compression, and the Spock 6 beta release for multi-master PostgreSQL replication. The LZ4 change promises faster compression and better ratios for large field values. The SQLite discussion signals Windows embedders to evaluate alternative memory allocation strategies.

  • •SQLite may deprecate SQLITE_WIN32_MALLOC, impacting Windows-embedded applications
  • •PostgreSQL 19 plans to default TOAST compression to LZ4 for better performance
  • •Spock 6 beta from pgEdge adds multi-master replication support for recent PostgreSQL versions

Generated with AI, which can make mistakes.

Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension
Dev.to
SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration
Dev.to
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals
Dev.to
SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture
Dev.to