~lobsters | Bookmarks (97)
-
A Deeper Look Inside PostgreSQL Visibility Check Mechanism - Highgo Software Inc.
Simply put, the visibility refers to whether a row of data (Heap Tuple by default) should...
-
Redis is forked
April 16, 2024 Hey friends. I need to do a better job keeping this newsletter up...
-
Some useful types for database-using Rust web apps
I’ve been writing a little web app in rust lately, and in it I decided to...
-
Setting up PostgreSQL for running integration tests
When it comes to testing, achieving performance and reliability is crucial. In this article, I'll explain...
-
Designing one-to-one relationships in PostgreSQL
Once in a while, you might need to design a one-to-one relationship in SQL. This is...
-
I lost my pg_control again (... yet another data recovery story)
Co-Authored-By: mei this blogpost is a spiritual continuation of the data recovery post from February.i really...
-
The case for native assertions in PostgreSQL
Once in a while, I encounter a query that looks something like this: SELECT DISTINCT ua1.id,...
-
A Sniff Test for Some Query Optimizers
April 1, 2024, 2 p.m. One important part of query planning is performing transformations over queries....
-
Hacking our PostgreSQL driver to get more out of Amazon RDS performance insights | Knock
👋 We’re Knock. We provide a set of simple APIs developers use to introduce notifications into...
-
Redesigning OLTP for a New Order of Magnitude
Greef: The world is becoming more transactional, from servers to serverless, and per second billing. You...