a curated list of database news from authoritative sources

December 18, 2023

December 15, 2023

A Quick SQL Server Puzzle About MIN_ACTIVE_ROWVERSION()

MIN_ACTIVE_ROWVERSION() is a system function that returns the lowest active rowversion value in the current database. Its use then is very similar to @@DBTS. In fact, the docs for MIN_ACTIVE_ROWVERSION() (currently) say: If there are no active values in the database, MIN_ACTIVE_ROWVERSION() returns the same value as @@DBTS + 1. Does it though? You may […]

The post A Quick SQL Server Puzzle About MIN_ACTIVE_ROWVERSION() first appeared on Michael J. Swart.

December 14, 2023

December 13, 2023

$ pscale ping

How close am I to PlanetScale? Use our new CLI command, pscale ping, to find out.

PostgREST 12

PostgREST 12 is out and we take a look at some of the major new features like JWT Caching and Aggregate Functions

December 12, 2023

December 11, 2023

December 08, 2023

How design works at Supabase

The transformative journey of Supabase's Design team and its unique culture to enhance the output and quality of the entire company.