2941
Postgres sequences can skip 32 unexpectedly
The other day, we started getting strange reports from some customers of incident.io. Their incident identifiers — unique numbers to identify each incident — appeared to have jumped unexpectedly.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2942
2943
WordPress Core to start using SQLite
This post is an update to the proposal for officially support SQLite in WordPress. The initial implementation was included in the Performance Lab plugin and then released as a stand-alone plugin. T…
2944
Advancing AI Benchmarking with Game Arena
We’re expanding Game Arena with Poker and Werewolf, while Gemini 3 Pro and Flash top our chess leaderboard.
2945
Fixing Hallucination with Knowledge Bases
Large Language Models (LLMs) have a data freshness problem. Even some of the most powerful models, like GPT-4, have no idea about recent events. Let's learn how to fix this.
2946
Type constraints in 65 lines of SQL
Creating validated data types in Postgres
2947
Loading Pydantic models from JSON without running out of memory
Pydantic’s JSON loading uses a huge amount of memory; here’s how to reduce it.
2948
Jepsen: Aerospike 3.99.0.3
Aerospike , formerly Citrusleaf, is a distributed, sharded document store designed for high-throughput, low-latency applications. Each record is a map of keys to values, which may be either primitive types (integers, strings, bytes, etc.) or nested collections like lists and maps. Secondary indices are also available…
2949
Just make it scale: An Aurora DSQL story
AWS Senior Principal Engineers, Niko Matsakis and Marc Bowes, take us inside Aurora DSQL's development: scaling write operations without two-phase commit, overcoming garbage collection hurdles, and embracing Rust for both data and control planes.
2950
A Look at MyRocks Performance
Taking a look at MyRocks performance through some benchmark testing.
2951
2952
Finding Similar Music Using Matrix Factorization
In a previous post I wrote about how to build a ‘People Who Like This Also Like …’ feature for displaying lists of similar musicians. My goal was to show how simple Information Retrieval techniques can do a good job calculating lists of related artists. For instance, using BM25 distance on The Beatles shows the most…
2953
Bottomless, consumption-based storage for PostgreSQL built on Amazon S3
Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.
2954
Catena: A time series storage engine written in Go
First, I suggest reading Baron’s “Time-Series Database Requirements” blog post to get some more context for this post. I read that and, as I usually do, had my mind set on low-level thoughts. I wrote the following comment:
2955
PostgreSQL 10 Beta 4 Released
The PostgreSQL Global Development Group announces today that the fourth beta release of PostgreSQL 10 is available for download. This …
2956
Jepsen: Jetcd 0.8.2
Etcd is a coordination service designed to offer Strict Serializable reads, writes, and micro-transactions over a small, in-memory key-value store. In 2022, Jepsen re-tested etcd as a part of a private engagement covering an assortment of databases. We reported several issues to the etcd team during that engagement…
2957
Building a Managed Postgres Service in Rust
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
2958
Working with the Clinton State Dept Email Dumps in R, Part 1
This isn’t a post about politics. I do have opinions about the now infamous e-mail server (which will no doubt come out here), but when the WSJ folks made it possible to search the Clinton email releases I though it would be fun to get the data into R to show how well the igraph and ggnetwork packages could work…
2959
Learning Python for Social Scientists (2015)
I’ve compiled a list of Python tutorials and annotated analyses. I've tried to list pages that are accessible to social scientists with little background in Python and/or machine learning.
2960
Pg_stat_monitor – better insights into query performance in PostgreSQL
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.
2961
Lessons learned teaching data analysis with Python
A San Diego State journalism professor shares her experience with “First Python Notebook”
2962
Kafka at the low end: how bad can it get?
There is oft-quoted advice that Kafka does poorly as a job queue. I’ve experienced this myself, and I wanted to formalize it a bit.
2963
Results of the SQL Performance Quiz
SQL indexing: 60% don’t know how to get it right
2964
UUID Benchmark War
This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have deci…
2965
Spanish traders set the standard for GnuCash database design
TLDR: Spanish traders in the 1600s did not want to count their thumbs, which influenced GnuCash's database design choices in 1997. Much like a horse's arse set the standard for railways . How seemingly odd design turns out to be a genius solution that serves people pretty well.
2966
ULIDs and Primary Keys
Not all non-sequential primary keys are created equal, the ULID format is a fantastic substitute for the typical UUIDv4 choice.
2967
Netflix's Distributed Counter Abstraction
By: Rajiv Shringi, Oleksii Tkachuk, Kartik Sathyanarayanan
2968
2969
2970
What's New in ClickHouse 21.12
What’s New in ClickHouse 21.12