Tag
GreptimeDB v1.1 introduces online repartitioning for existing tables via a single ALTER TABLE statement, eliminating the need for data migration, dual-writes, or application changes. It leverages shared object storage and logical shards to update manifests and routing without moving data between nodes.
sqlite-utils 4.1.1 fixes a TransactionError edge case when transforming tables with foreign keys and improves documentation cross-references between CLI and Python API.
SQLite's strict tables enforce rigid typing to prevent common datatype mistakes. The article explains how to use them and their pros and cons.
Ship That Code is a learning platform offering over 80 build-from-scratch courses to teach real systems like Redis, Git, and databases, with structured career paths and multiple languages.
A ground-up reimplementation of PostgreSQL in Rust passes 100% of official tests, is disk-compatible, and claims significant performance improvements (50% faster transactional, ~300x faster analytical) in a WIP version.
The article revisits the SETI@home distributed computing model as a potential solution to alleviate the demand for new database centers by utilizing idle office and home PCs for processing tasks.
PgDog is a tool that allows you to scale PostgreSQL without modifying your application, providing connection pooling and load balancing.
A comprehensive database of physically based rendering (PBR) values for materials, light sources, and cameras, useful for 3D artists and developers.
This article demonstrates clever techniques to achieve partition pruning in PostgreSQL when filtering by non-partition key columns, going beyond conventional wisdom.
An internal Madison Square Garden database tracked hundreds of celebrities with risk scores and labels including 'LGBTQIA' and 'DO NOT HOST', revealing extensive surveillance of VIPs and critics of owner Jim Dolan after a data breach by the ShinyHunters hacker group.
pgrust is a Rust rewrite of PostgreSQL 18.3 that passes all 46k+ regression tests, aiming to make Postgres easier to modify with Rust and AI assistance. It is disk-compatible and can boot from existing Postgres data directories.
This paper argues that parameter-free encoders remain viable for relational database foundation models, providing theoretical limitations on trainable encoder parameters and empirical validation across benchmarking tasks.
sqlite-utils 4.0 introduces database schema migrations, nested transactions, and compound foreign keys, making it easier to manage SQLite database schema changes programmatically.
sqlite-utils 4.0 has been released, a Python library for manipulating SQLite databases.
Proposes ALORE, a table overlap ratio estimator using a Two-View Row-Column Hypergraph encoder and alignment-guided training, achieving up to 55% lower MAE and 89x speedup over state-of-the-art.
The article describes an expired patent for a new in-memory sort algorithm that features common prefix skipping, adaptivity, and key substring caching, which was implemented in Oracle 10gR2 and achieved significant performance improvements.
This article explores Dolt, a version-controlled database that uses Prolly trees to support Git-like operations for database branches, commits, merges, and diffs, enabling powerful data management workflows.
A website cataloguing real computer models as they appear in films and television series, organized by brand and model.
EF Core 11 optimizes split queries by removing unnecessary JOINs of reference navigations from collection queries, reducing database overhead and improving performance.