Dev Tools·35wFree Valentina Studio 16 now available
Valentina Studio 16 has been released as a free database management tool supporting major databases including PostgreSQL, MongoDB, MySQL/MariaDB, MS SQL Server, SQLite, DuckDB, and ValentinaDB. The PRO version includes advanced diagramming, reporting, and forms creation capabilities similar to MS Access or FileMaker. A 5-connection version of Valentina Server 16 is also available for free.
Crunchy Data·36wGet Excited About Postgres 18
PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip scans for multi-column indexes, virtual generated columns as the default, and OAuth 2.0 authentication support. The async I/O feature allows workers to batch reads and optimize idle time, while UUID v7 provides better locality through timestamp-based prefixes. Skip scans enable using multi-column indexes even when leading columns aren't in query conditions, and virtual generated columns compute values on-the-fly without storage overhead.
Collections·34wKey Features and Enhancements in PostgreSQL 18
PostgreSQL 18 introduces major performance improvements including asynchronous I/O that delivers up to 3x faster storage reads, NUMA support, and IO_uring on Linux. The release adds enterprise features like OAuth 2.0 authentication, temporal constraints, and virtual computed columns. Key enhancements include better extension loading for Kubernetes deployments, improved logical replication conflict handling, UUIDv7 support, and advanced vacuum operations for large tables. The update also brings query planning improvements with skip scan lookups and enhanced Unicode collation support.
Hacker News·36wOrioleDB Patent: now freely available to the Postgres community
Supabase has completed the acquisition of OrioleDB and is making the related patent freely available to all users. OrioleDB is a high-performance storage extension for PostgreSQL that shows 5.5x performance improvements over traditional heap storage. The project remains open source with an open contribution model, and Supabase aims to eventually upstream OrioleDB into PostgreSQL itself. The patent license is intended as defensive protection for the open source community rather than offensive enforcement.
Crunchy Data·34wPostgres 18: OLD and NEW Rows in the RETURNING...
PostgreSQL 18 introduces the ability to access both OLD and NEW row values in RETURNING clauses for INSERT, UPDATE, DELETE, and MERGE operations. This enhancement allows developers to see previous and current data states in a single query, making it easier to detect whether an upsert operation inserted a new row or updated an existing one without relying on internal implementation details like xmax values.
PlanetScale·34wPlanetScale for Postgres is now GA — PlanetScale
PlanetScale has officially launched their Postgres database service, moving from private preview to general availability. The managed service combines PlanetScale's proven infrastructure with Postgres, targeting companies that need scalable database solutions. Several companies including Convex, Supermemory, and Layers have already migrated to the platform. PlanetScale is also developing Neki, a Postgres sharding solution built from first principles that will eventually be open-sourced for demanding workloads.
PlanetScale·34wPostgres High Availability with CDC — PlanetScale
Postgres high availability faces operational challenges when using Change Data Capture (CDC) due to logical replication slots being primary-local objects that can prevent failover. When CDC clients lag or poll infrequently, standby replicas may become ineligible for promotion, forcing administrators to choose between waiting for CDC advancement or breaking the CDC stream. MySQL's GTID-based approach avoids this coupling by embedding replication progress in the binary log itself, allowing seamless failover regardless of CDC client behavior.
P99 Conf·34wBooks by P99 CONF Speakers: AI Engineering, Latency, Distribtuted Systems & More
A curated collection of technical books authored by P99 CONF speakers covering AI engineering, distributed systems, database performance optimization, latency reduction, and PostgreSQL query optimization. The books range from foundational concepts to advanced implementation techniques, with special discounts available through conference sponsors O'Reilly and Manning Publications.
Frontend Masters·37wAdvanced PostgreSQL Indexing: Multi-Key Queries and Performance Optimization – Frontend Masters Blog
Explores advanced PostgreSQL indexing techniques for multi-key queries and performance optimization. Demonstrates how to create composite indexes on publisher and title columns to dramatically improve query performance from seconds to milliseconds. Shows practical solutions for querying multiple publishers using CTEs and lateral joins, explaining when and why different execution plans are chosen. Provides real-world examples with a 90-million record books table, illustrating how proper index design and query structure can achieve sub-millisecond performance even with complex multi-publisher queries.
depesz·34wWaiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max). – select * from depesz;
PostgreSQL 19 introduces new random() function variants for generating random dates and timestamps within specified ranges. The update adds three new functions: random(min date, max date), random(min timestamp, max timestamp), and random(min timestamptz, max timestamptz). These functions simplify test data generation by eliminating the need for manual calculations with intervals and mathematical operations.
Hacker News·36wpgEdge goes Open Source
pgEdge has relicensed all core components of their Distributed Postgres platform from a proprietary pgEdge Community License to the permissive PostgreSQL License. This includes their replication engine Spock and extensions like Snowflake and Lolor. The change makes pgEdge's distributed PostgreSQL technology fully open source, allowing unrestricted use and modification of the source code.
Milan Jovanović·35wDistributed Locking in .NET: Coordinating Work Across Multiple Instances
Distributed locking solves coordination problems when applications run across multiple instances. While .NET provides concurrency primitives for single processes, distributed systems need specialized solutions to prevent race conditions and ensure data consistency. PostgreSQL advisory locks offer a simple DIY approach, while the DistributedLock library provides production-ready features with support for multiple backends including Postgres, Redis, and SQL Server.
ByteMonk·36wNext.js Full-Stack App in Minutes | Deploying to Sevalla
A comprehensive tutorial demonstrating how to build a full-stack course feedback application using Next.js for both frontend and backend, with PostgreSQL database integration. The guide covers Next.js fundamentals including server-side rendering, API routes, and file-based routing, then walks through creating a complete feedback system with form handling and database operations. The tutorial concludes with deploying the application to Sevalla cloud platform, highlighting features like managed databases, unlimited collaborators, and usage-based pricing.
Frontend Masters·37wIntroduction to Postgres Indexes – Frontend Masters Blog
A comprehensive guide to PostgreSQL B-Tree indexes covering how they store data on disk, navigate through internal nodes, and speed up queries. Explores practical examples with a 90-million record database, demonstrating index scans, bitmap scans, covering indexes, and the INCLUDE clause. Shows how indexes can sometimes hurt performance when the query optimizer makes suboptimal choices, and explains concepts like heap fetches, visibility tables, and the difference between index scans and index-only scans.
Golang Weekly·35wGolang Weekly Issue 570: September 17, 2025
Weekly Go newsletter covering memory allocation fundamentals, GopherCon 2025 contributor summit discussions on dependency management and language proposals, linter pitfalls, practical uses of channels for non-concurrent scenarios, implementing the outbox pattern with Postgres, building virtual machines, SQL query monitoring with DTrace, and the Flaggy command line parsing library update.
MotherDuck·37wAnnouncing Pg_duckdb Version 1.0
Pg_duckdb version 1.0 is now available, bringing DuckDB's vectorized analytical engine directly into PostgreSQL as an extension. This integration enables faster analytical queries on PostgreSQL data without requiring separate data warehouses or complex ETL processes. The extension allows querying PostgreSQL tables with DuckDB's performance benefits, accessing external data lake files (Parquet, CSV, JSON), and joining local PostgreSQL data with remote cloud storage files in single queries. Performance improvements show up to 4x speedup with indexes and dramatic improvements for queries that previously timed out. The release includes enhanced MotherDuck integration for serverless analytics scaling.
PostgreSQL·35wpgFormatter v5.8 has been released
pgFormatter v5.8 introduces improved formatting for INSERT statements, now distinguishing between single and multiple value formats with different indentation styles. The release also fixes indentation issues in DO blocks and includes various user-reported bug fixes and improvements.
PostgreSQL·35wPostgreSQL: pgexporter 0.7
pgexporter version 0.7.0 has been released with improvements to core metrics and new features. This Prometheus exporter for PostgreSQL includes extension support developed as part of a Google Summer of Code project. The tool helps monitor PostgreSQL databases by exporting metrics to Prometheus.
Baeldung·36wPartitionKey in Hibernate: A Practical Guide for Spring Boot
Database partitioning improves query performance for large datasets by splitting tables into smaller, manageable segments. Hibernate 6.2+ introduces the @PartitionKey annotation to optimize queries on partitioned tables. The tutorial demonstrates setting up PostgreSQL table partitions, configuring Spring Boot with Hibernate entities using @PartitionKey, and creating REST endpoints to interact with partitioned data. Key benefits are realized when queries include the partition key in WHERE clauses, allowing the database to target specific partitions rather than scanning all data.