Daniel Vérité

Self employed, free software enthusiast, database expert. Mainly working on PostgreSQL-related projects.

[Noriyoshi Shinoda @nori_shinoda]

PostgreSQL 19 Beta 1 New Features with Examples (English Version)
https://t.co/Yx5bU3sT9s

[Daniel Vérité @DanielVerite]

Pour les franciliens: il y aura un meetup #PostgreSQL Paris le 21 mai prochain
https://t.co/GtocCgB6bZ

[Ryan Peterman @ryanlpeterman]

Mike Stonebraker is a Turing award winner famous for his fundamental contributions to databases (e.g. Postgres, C-Store and much more). I interviewed him recently about:

• The story behind Postgres & the hardest technical challenge in building it
• Where he disagreed with Google's technical decisions
• Future problems in databases
• Literature recommendations to learn databases
• Why LLMs score 0% on his text-SQL benchmark
• What if you replaced all state in an OS with a DB

Timestamps:

0:00 - Intro
1:03 - How he got into databases
6:43 - Competing with Oracle
9:07 - What made Postgres special
15:55 - One size fits none
21:37 - Why he disagreed with Google
29:14 - Why he chose academia over big tech
30:58 - Replacing state in an OS with a DB
42:02 - Future problems in databases
51:36 - Technical book recommendations to learn databases
52:20 - Advice for younger self
55:52 - Outro

Where to watch:

• YouTube: https://t.co/YCunRSEIUK
• Spotify: https://t.co/7cCzATzN8z
• Apple Podcasts: https://t.co/jOYDGtGVnt
• Transcript: https://t.co/36BL7eGNmq

[Planet PostgreSQL @planetpostgres]

Daniel Vérité (@DanielVerite): Producing UUIDs Version 7 disguised as Version 4 (or 8) https://t.co/XEQn8XSbyf

[Planet PostgreSQL @planetpostgres]

Daniel Vérité (@DanielVerite): Pipelining in psql (PostgreSQL 18) https://t.co/6KIBmPrbNV

[Planet PostgreSQL @planetpostgres]

Daniel Vérité (@DanielVerite): What Unicode versions do we use? https://t.co/b96V3FDOZE

[Stefan Fercot @pgstef]

🐘 In case you missed the info on other platforms, we're gonna have a #PostgreSQL #meetup in Paris next month on Thursday 13th March and I'll be there speaking about incremental backups (and a little bit about pgBackRest 🤫)

https://t.co/J2TXBX4K82

[Planet PostgreSQL @planetpostgres]

Daniel Vérité (@DanielVerite): Implementing UUIDs v7 in pure SQL https://t.co/tgeeWIFpqt

[Planet PostgreSQL @planetpostgres]

Daniel Vérité (@DanielVerite): Looking at the new built-in collation provider in PostgreSQL 17 https://t.co/6WwfpIYaCY

[Andy Pavlo (@andypavlo.bsky.social) @andy_pavlo]

It took three years to finish, but our follow-up to the 2006 "What Goes Around Comes Around" is finally out! Stonebraker and I examine the last 20 years in databases and discuss why relational databases + SQL will continue to remain on top.

📄PDF: https://t.co/ZwTWSxXLWb

[Jeremy Schneider @jer_s]

It's online! I'm a bit biased, but I think this came together nicely.

1. What surprised me while the Postgres community worked to address glibc-related DB corruption risks over the past few years

2. Why the new builtin collation provider coming this fall in pg17 is a big deal

[Daniel Vérité @DanielVerite]

Dans ce billet, on analyse ce que permet le nouveau fournisseur de collation interne de #PostgreSQL 17 (beta)
https://t.co/Jw4XMTXHj5

[Daniel Vérité @DanielVerite]

New #PostgreSQL blog post: Advanced psql scripting with coproc
https://t.co/U8lqI8ZzlM

[Joseph Conway @josepheconway]

Committed to PostgreSQL 17 complements of Jeff Davis. This is a huge step forward for PostgreSQL users!

https://t.co/8N4qyzGXxV

[Daniel Vérité @DanielVerite]

New blog post: Using binary-sorted indexes in #PostgreSQL databases: https://t.co/tv9A3hbgrc

[Daniel Vérité @DanielVerite]

Billet: une catégorisation des signalements de bugs #PostgreSQL en 2023
https://t.co/fE4sF7VKT9

[Gwen (Chen) Shapira @gwenshap]

🛠️ Ever dealt with glitches in your SaaS app where actions yield unexpected results? That can be a transaction isolation issue.

I blogged about transaction isolation, how it works in Postgres and how to use the right isolation to build better apps: https://t.co/Qgbd3aSvtX

[Daniel Vérité @DanielVerite]

New blog post: how to search globally inside a #postgresql database https://t.co/YTqkdUZkpt

[Daniel Vérité @DanielVerite]

@samokhvalov Yes. https://t.co/shJOjjEgYF