Tag
The author introduces Noosphere, an open-source memory and wiki layer for AI agents and humans, seeking feedback on its structured Postgres-backed memory, Redis-cached recall, and human-editable wiki pages.
The author replaced OpenClaw's default flat-file memory with a strict Node.js/PostgreSQL API layer, eliminating context drift and hallucinations by enforcing typed schemas and immutable truth.
Cache-aware scheduling improvements show significant performance gains for AMD Zen 5 processors running PostgreSQL and Valkey databases.
Describes implementing a three-layer memory stack for Hermes Agent, combining session memory on PostgreSQL, working memory with pattern redaction, and a long-term knowledge graph using PGLite.
pgGraph v0.1.1 is an open-source, high-performance graph traversal extension for PostgreSQL written in Rust, enabling graph superpowers for Postgres users.
pgBackRest, a popular PostgreSQL backup tool, announces it will continue development thanks to a coalition of sponsors including Amazon Web Services, Supabase, and others, ensuring long-term sustainability.
DeltaX is an Apache-licensed PostgreSQL extension providing compression and columnar storage for time-series data, offering a fast alternative to TimescaleDB or ClickHouse while keeping data in PostgreSQL.
listmonk is a self-hosted email marketing system deployed as a single binary, supporting Newsletter and mailing list management. It is open-source with no vendor lock-in.
Tabularis is an open-source, cross-platform modern database client that supports PostgreSQL, MySQL/MariaDB, and SQLite, with built-in AI, MCP, and Notebook, and supports plugin extensions. Designed for developers.
Explains the subtle differences in how ORDER BY handles bare identifiers versus expressions in SQL, using PostgreSQL examples to show that identical-looking queries can produce different results due to different code paths.
PostgreSQL has released security updates for versions 18.4, 17.10, 16.14, 15.18, and 14.23, fixing 11 CVEs and over 60 bugs. Notable fixes include CVE-2026-6473 (integer wraparound, CVSS 8.8) and CVE-2026-6475 (symlink overwrite, CVSS 8.8).
The article analyzes the scalability limitations of using PostgreSQL as a job queue, specifically highlighting performance bottlenecks caused by MultiXact SLRU contention under high concurrency. It explains why this architecture fails in production despite working well in development and suggests considering alternatives.
OpenAI shares technical insights on scaling PostgreSQL to support 800 million ChatGPT users and millions of queries per second, using a single-primary architecture with 50 read replicas while managing challenges from write-heavy workloads through sharding and optimization strategies.
Mattermost is an open core, self-hosted collaboration platform with chat, workflow automation, voice calling, screen sharing, and AI integration. The GitHub repository serves as the primary source for core development, written in Go and React, and released monthly under an MIT license.
listmonk is a standalone, self-hosted newsletter and mailing list manager that is fast, feature-rich, and packed into a single binary using a PostgreSQL database.