databases

A talk from the Posette conference argues that PostgreSQL's reputation for poor performance is often misplaced, with the real bottleneck lying in the underlying storage layer rather than the database itself. The argument, shared by ClickHouse, has resonated with developers, many of whom see it as a useful reminder that disk configuration, latency and I/O choices frequently explain slow database behavior.

A research paper by Niv Dayan presents better space-time trade-offs for LSM-tree based key-value stores, the storage architecture behind databases like RocksDB and LevelDB. The work, shared as a PDF titled Dostoevsky, proposes tuning compaction and memory allocation to reduce the write amplification and storage costs that plague these systems at scale.

SQLite 3.54 has been released, bringing performance improvements and query optimizations to the widely used embedded database engine. Developers in open-source communities are sharing the news, highlighting the project's reputation for reliability and its role as a foundational component in countless applications, browsers and operating systems.

MLB's records show the Philadelphia Phillies defeated the Pittsburgh Pirates 4-1 on May 25, 1948, as listed in the league's Gameday archive of historical box scores. The result comes from baseball's official historical database, which documents games from past decades. No further details about the game's events are available in the listing.

ClickHouse has released ClickHouse C, a library for communicating with the ClickHouse analytical database using its native binary protocol rather than the usual HTTP interface. The project, available on GitHub, is aimed at developers building fast, lightweight integrations in C or C-compatible environments. Hacker News readers are weighing its usefulness against existing client drivers and the performance benefits of the binary protocol.

An official MLB Gameday record shows the New York Yankees beat the Washington Senators 4-0 in a game played on May 6, 1914, more than a century ago. The final score entry from baseball's archives has drawn attention from fans browsing the league's historical database. Little context is attached to the box score, leaving the exact reason for the renewed interest unclear.

MLB's Gameday archive lists a final score from July 31, 1920, with the Philadelphia Athletics defeating the Chicago White Sox 5-1. The page records the historical result as part of Major League Baseball's online database of past games, giving fans access to box scores and lineups from more than a century ago, including from the era of the infamous Black Sox scandal season.

A new project proposes a shared, verifiable database of fixes that AI agents can both read from and write to. The idea is that agents working on bugs or errors would contribute their solutions to a common pool, where each fix is verifiable, so other agents can reuse trusted solutions instead of rediscovering them. Discussion is centered on whether such crowdsourced, machine-maintained knowledge bases could make autonomous coding agents more reliable.

The Middle East and North Africa need to build genomic sovereignty, meaning the capacity to collect, store and analyse their own populations' genetic data rather than relying on foreign databases and institutions. Most genomic research historically underrepresents MENA populations, and regional scientists argue local biobanks, data infrastructure and research capacity are needed for better healthcare and medical research.

MLB's Gameday archive shows a final score from May 25, 1948: the Baltimore Elite Giants beat the New York Cubans 10-2. Both teams played in the Negro National League in the last season before the league folded, and MLB now keeps box scores and standings from that era in its official records.

A developer has released Minigraf, an embedded graph database written in Rust that supports bi-temporal data, meaning it tracks both when events happened and when records were written. It is being shared with the Hacker News community as an open-source project on GitHub, where readers are weighing its practical uses against established graph databases.

A new technical blog post explains how to compute count-leading-zeros (CLZ) and count-trailing-zeros (CTZ) operations across multiple values at once using SIMD vectorization. The piece walks through bit-manipulation techniques for speeding up these low-level operations, a topic of interest to systems programmers working on performance-critical code such as databases, compilers and compression libraries.

The OSINT project RosHlopok has added new analytics cataloguing palaces and residences linked to Vladimir Putin, saying that by range calculation 13 of 14 identified sites fall within a specified radius. The database lists locations tied to the Russian president, and observers are sharing the mapping amid ongoing discussion of strikes and drone operations related to the war in Ukraine.

APSW, a long-running Python wrapper for SQLite maintained by Roger Binns, is drawing fresh attention from developers. Unlike the standard sqlite3 module, APSW exposes SQLite's full API directly, giving programmers finer control over database behaviour. The project's GitHub repository is being discussed as a lightweight, dependable option for anyone working with SQLite in Python.

Software developer and free-software figure Bradley Kuhn described writing a system of roughly 100,000 lines of Tcl embedded in the proprietary Informix database. He says he chose Tcl because embedding Perl into an application to provide a scripting language was extremely difficult at the time, while Tcl was designed from the start for exactly that purpose. The remark has drawn attention as a first-hand account of late-1990s scripting language trade-offs.

NASA's Astrophysics Data System, the long-serving research database used by astronomers worldwide, is being transitioned to SciX, a next-generation platform designed for twenty-first century astronomy. According to Nature, the move aims to modernize how researchers search and access the astrophysics literature. SciX is expected to broaden coverage beyond astrophysics while preserving ADS's core search and bibliographic services.

APSW, an open-source Python wrapper for the SQLite database engine written by Roger Binns, has resurfaced in developer discussions this week, with a link to its GitHub repository shared and commented on across tech communities. The library lets Python programs access SQLite directly and is valued for exposing SQLite APIs beyond the standard library's sqlite3 module.

FOSS Academy has announced a four-morning training course on handling geospatial data with PostgreSQL and PostGIS, running 24-27 November 2026. The sessions cover SQL queries, PostGIS functions, psql, pgAdmin and QGIS, plus data exchange, backup, administration and performance. Basic database knowledge is recommended for participants.

Pydantic's Logfire engineering team says it sped up queries by up to 1000x by shredding JSON columns, extracting nested fields into dedicated columns instead of parsing JSON blobs at query time. The article details how the observability platform handles dynamic attributes in its database. Developers on Hacker News are discussing the tradeoffs between schema flexibility and query performance.

Security researchers have disclosed nine vulnerabilities in MariaDB, including issues tracked as CVE-2026-107815, CVE-2026-107818 and CVE-2026-107814, with severity scores reaching 8.5 out of 10. The flaws could let attackers escalate privileges and execute code on affected systems. Fixes are available, and administrators are being urged to update MariaDB Server and Connector/C as soon as possible.

Researchers have introduced an AI platform and database that map protein phase separation across different species. Phase separation, the process by which proteins condense into droplets inside cells, is increasingly linked to cellular organization and diseases such as neurodegeneration. The new resource allows scientists to compare these behaviors across organisms, and the scientific press is highlighting it as a useful tool for studying protein function and evolution.

MLB.com is showing the final score of a baseball game played on August 19, 1936, in which the Stars beat the Grays 7-4. The listing appears in MLB's Gameday archive, which now includes historical matchups from baseball's past, including Negro Leagues-era teams, alongside modern results. Fans encountering decades-old box scores in the current database have been sharing the unusual find.