Author of theartofpostgresql.com. #PostgreSQL Contributor, #pgloader, #pg_auto_failover. Dad. Guitar player. Board games & Craft beers. he/him. BLM ✊🏿
Joined July 2011
- Tweets 25,349
- Following 593
- Followers 4,025
- Likes 20,856
169 Photos and videos
Pinned Tweet
28 Oct 2019
“This book is on a higher level than generic software books. It explains the how's and why's of using Postgres's many feature. It is an excellent companion to the official Postgres documentation.” wrote Bruce Momjian about my book theartofpostgresql.com. You have your copy yet?
14
21
86
Dimitri Fontaine retweeted
19 Oct 2022
The state of the art Cardinality Estimation Algorithm called HyperLogLog is available as a @PostgreSQL extension! Read more about it at tapoueh.org/blog/2013/02/pos…
1
4
9
Dimitri Fontaine retweeted
14 Oct 2022
Postgres 15 was released yesterday. Now that you've read the release notes and picked your favorite features, what questions can I answer for you?
13 Oct 2022
News: PostgreSQL 15 Released! postgresql.org/about/news/po…
5
7
Dimitri Fontaine retweeted
14 Oct 2022
How to quickly find data matching a complex set of user provided tags, all within @PostgreSQL query engine, you may ask! In the following article we use some denormalization tricks to answer that, read more at tapoueh.org/blog/2013/10/den…
2
10
Dimitri Fontaine retweeted
14 Oct 2022
App devs are afraid of putting logic in SQL 🙂 @tapoueh ‘s The Art of PostgreSQL covers it well:
ALT Screenshot of the intro of chapter 4 of The art pf postgresql
1
4
12
Dimitri Fontaine retweeted
12 Oct 2022
How to Write SQL as code and maintain it the same way as the rest of your code checkout? Read more at tapoueh.org/blog/2017/06/how…
6
16
Dimitri Fontaine retweeted
11 Oct 2022
Postgres 15 is almost ready. Let's check some changes that might break compatibility with previous releases: 🧵
1
15
56
11 Oct 2022
I am proud to announce release 2.0 of pg_auto_failover! With Postgres 15 support, and already in debian thanks to @df7cb amazing work.
Get started at pg-auto-failover.readthedocs… with the docs. You're looking to implement HA for Postgres? Try pg_auto_failover!
1
9
23
11 Oct 2022
Implementing these reference architectures require a single command line per box in many cases. See the docker-compose files in the tutorials. More architectures are possible, too, with quite some flexibility!
1
11 Oct 2022
Final tweet in that thread: see pg-auto-failover.readthedocs… if you're wondering about “a single command line per box, really?”. Yes, really. And you can reproduce that at home. The full Dockerfile and docker-compose.yml setup is provided.
1
Dimitri Fontaine retweeted
6 Oct 2022
FYI, if you were waiting till the proverbial last minute to do your Postgres v15 beta testing, the time has arrived 😉
6 Oct 2022
News: PostgreSQL 15 RC 2 Released! postgresql.org/about/news/po…
1
4
30 Sep 2022
Just released pgcopydb v0.9 with lots of improvements and bug fixes. See github.com/dimitri/pgcopydb/…
Thanks to @df7cb packages are already uploaded to debian and all! Maybe @DevrimGunduz is next for the RPMs?
1
4
14
Dimitri Fontaine retweeted
22 Sep 2022
Interesting news (depending on your level of tech nerdy I suppose🤣); the @PostgreSQL project seems to have settled on a future build system; @mesonbuild. git.postgresql.org/gitweb/?p…
1
5
19
Dimitri Fontaine retweeted
9 Sep 2022
"In @PostgreSQL Data Types: Point we did download a complete geolocation data set and normalized it, making good use of other PostgreSQL data types we’ve been learning about in the previous articles of this series." See tapoueh.org/blog/2018/05/pos… from @tapoueh
4
7
Dimitri Fontaine retweeted
9 Sep 2022
I quite like @TheArtOPostgres and it's targetting developers
1
2
7
Dimitri Fontaine retweeted
8 Sep 2022
Taking a few minutes today to practice some SQL. Loving having the @crunchydata playground - crunchydata.com/developers/p… and with ?sql=filehere. I'm able to go through @tapoueh's The Art of PostgreSQL with some really awesome exercises cek--theartofpostgresql.thri… (PG15 code gets 30% off)
5
10