@tapoueh
Account based inFrance
About this account
- Account based in
- France
- Connected via
- Web
Account-level information from X, not a live location or the device used for a specific post.
Author of https://nitter.cf/t.co/iKDs72GUuy. #PostgreSQL Contributor, #pgloader, #pg_auto_failover. Dad. Guitar player. Board games & Craft beers. he/him. BLM ✊🏿
Paris, France
Joined July 2011
- Tweets25.3K
- Following591
- Followers4K
- Likes20.8K
Pinned Tweet
“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?
Dimitri Fontaine retweeted
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…
Dimitri Fontaine retweeted
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?
News: PostgreSQL 15 Released! postgresql.org/about/news/po…
Dimitri Fontaine retweeted
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…
Dimitri Fontaine retweeted
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
Dimitri Fontaine retweeted
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…
Dimitri Fontaine retweeted
Postgres 15 is almost ready. Let's check some changes that might break compatibility with previous releases: 🧵
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!
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!
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.
Dimitri Fontaine retweeted
SQL Regression Tests tapoueh.org/blog/2017/08/sql…
Dimitri Fontaine retweeted
FYI, if you were waiting till the proverbial last minute to do your Postgres v15 beta testing, the time has arrived 😉
News: PostgreSQL 15 RC 2 Released! postgresql.org/about/news/po…
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?
Dimitri Fontaine retweeted
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…
Dimitri Fontaine retweeted
The Most Popular Pub Names tapoueh.org/blog/2013/08/the…
Dimitri Fontaine retweeted
"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
Dimitri Fontaine retweeted
I quite like @TheArtOPostgres and it's targetting developers
Dimitri Fontaine retweeted
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)