SQLit is a terminal UI for SQL databases inspired by lazygit, supporting PostgreSQL, MySQL, SQLite, and dozens more. It features context-aware keybindings, Docker integration, a Vim-style query editor, fuzzy filtering, SSH tunnels, and customizable themes. Built with Python and Textual, it installs via pipx.
SQLit is a terminal UI for SQL databases inspired by lazygit, supporting PostgreSQL, MySQL, SQLite, and dozens more. It features context-aware keybindings, Docker integration, a Vim-style query editor, fuzzy filtering, SSH tunnels, and customizable themes. Built with Python and Textual, it installs via pipx.
PgBouncer is a lightweight connection pooler for PostgreSQL that reduces overhead by reusing connections. It works by maintaining a pool of database connections and distributing them to clients as needed, supporting session, transaction, and statement pooling modes to improve performance and scalability.
The article explains why PostgreSQL systems must use strict memory overcommit settings to prevent the Linux OOM Killer from terminating the database process. It details how memory overcommit allows PostgreSQL to allocate more memory than available, leading to out-of-memory conditions, and recommends setting vm.overcommit_memory to 2 to avoid such crashes.
Brume is an open-source tool for PostgreSQL that pseudonymizes datasets while preserving foreign key relationships across tables, allowing developers to work with realistic but de-identified data.
A pull request for pgvector claims to achieve 10x smaller vector indexes, significantly reducing storage requirements for vector similarity search in PostgreSQL.
A developer has created a PostgreSQL extension that loads Commodore 64 BASIC, allowing users to write stored procedures and functions using the retro BASIC v2.0 language directly within the database.
ClickHouse Cloud's managed Postgres service uses a custom PgBouncer sharding approach to overcome single-CPU-core bottlenecks, enabling the connection pooler to scale horizontally across multiple cores for higher throughput and reduced latency.
Scalar has revamped its documentation for ScalarDB and ScalarDL, aiming to help users start faster, stay updated with changes, and navigate cleaner, more organized docs. The update includes improved structure, clearer guidance, and better version management for developers.
A new pull request for pgvector introduces TurboQuant, a quantization technique that can reduce PostgreSQL vector index size by up to 10x at the 100 million row scale, aiming to improve storage efficiency for large-scale vector search.
ClickHouse partnered with a major tech company to scale LogHouse, a high-volume logging system handling 1.59 quadrillion rows across AWS, GCP, and Azure. The system processes 1.2 PB of new data daily, using optimized compression, tiered storage, and real-time replication to achieve sub-second query performance at minimal cost.
ScyllaDB has introduced a new trie-based index that delivers up to three times more throughput compared to its previous indexing methods. The trie index reduces memory overhead and improves performance for both point lookups and range scans. This enhancement is part of ScyllaDB's ongoing efforts to optimize NoSQL database performance.
The article explains how co-locating workflow state with application data in Postgres enables reliable distributed systems by leveraging database transactions and atomicity. This approach simplifies coordination, making workflows more robust and consistent without relying on external state management.
Sorting in Postgres at scale requires careful optimization beyond basic ORDER BY. Key strategies include using indexes properly, reducing sort memory consumption, and leveraging techniques like partial sorting or external sorting to handle large datasets efficiently without degrading performance.
SurrealDB has launched Scale, a new cloud tier designed for high availability and large-scale deployments. The offering includes multi-region support, horizontal scaling, and enhanced reliability features for enterprise workloads running on SurrealDB Cloud.
ClickHouse Managed Postgres has scaled PgBouncer, the PostgreSQL connection pooler, to improve connection management and performance for its users. The scaling effort enhances the handling of high volumes of database connections, reducing overhead and improving reliability. This update aims to optimize resource usage in ClickHouse's managed PostgreSQL service.
Pgblame is a new tool that helps identify which Vercel deployment caused a slowdown in your PostgreSQL database by correlating deploy timestamps with database performance metrics.
Digga is a web tool that consolidates DNS lookups, RDAP/WHOIS queries, subdomain discovery, and other domain-related data into a single interface for streamlined investigation.
PyCanopy is a spatial query layer built on top of Polars, offering geospatial capabilities that aim to compete with DuckDB and SedonaDB. It brings spatial join, spatial indexing, and geometric operations into the Polars ecosystem.
PL/PHP is a procedural language handler for PostgreSQL that enables users to write database functions using the PHP programming language.
Pglayers provides PostgreSQL extensions as reusable, stackable Docker layers, simplifying extension management in containerized environments.
ClickHouse's managed Postgres service implemented SO_REUSEPORT and socket peering to scale PgBouncer across all CPU cores, eliminating connection bottlenecks and improving performance under high load.
Gilliom Frontline Digital offers a PostgreSQL Management Platform designed to simplify database administration, monitoring, and performance optimization for enterprises.
The article explains how PostgreSQL metadata tables, despite their small size, can become a bottleneck and slow down large queries due to lock contention and sequential scans. It discusses the underlying mechanics of how these system tables interact with query execution, and offers strategies to diagnose and mitigate the performance impact.
PostgreSQL organizes data into a database cluster (a server-managed directory). Within it, databases are subdirectories in the base folder, each holding system catalogs. Tables are stored as relation files (relfilenodes) inside their database's directory, located via OID mappings.
This guide details a methodology for migrating PostgreSQL databases from on-premises servers to AWS Cloud with zero downtime, covering replication, schema migration, and cutover strategies.
Xata is an open-source, cloud-native platform built on PostgreSQL, offering serverless database capabilities with features like branching, search, and analytics for modern applications.
PGX Longevity offers extended commercial support for PostgreSQL versions that have reached their end-of-life (EOL), helping organizations maintain security and compliance while they plan upgrades. The service provides critical patches, troubleshooting, and expert assistance for unsupported PostgreSQL releases.
Pg_graphwright is a Postgres-based knowledge graph index that builds upon row-level security (RLS) features, enabling graph-style queries while inheriting existing database security policies.
The article introduces a tool that stores ISO 27001 information security policies in Git and tracks associated risks in Postgres, providing version control for compliance documentation.
Pgcraft is a terminal user interface for PostgreSQL, designed in the style of lazygit, that lets users visually explore databases, run queries, and manage tables directly from the terminal.
SQLit is a terminal UI for SQL databases inspired by lazygit, supporting PostgreSQL, MySQL, SQLite, and dozens more. It features context-aware keybindings, Docker integration, a Vim-style query editor, fuzzy filtering, SSH tunnels, and customizable themes. Built with Python and Textual, it installs via pipx.