Taking a few minutes today to practice some SQL. Loving having the Crunchy Data playground - crunchydata.com/developers/pla… and with ?sql=filehere. I'm able to go through Dimitri Fontaine's The Art of PostgreSQL with some really awesome exercises cek--theartofpostgresql.thrivecart.com/full-edition/ (PG15 code gets 30% off)

"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/p… from Dimitri Fontaine

Craig Kerstiens I quite like TheArtOfPostgreSQL and it's targetting developers

The Most Popular Pub Names tapoueh.org/blog/2013/08/t…

Interesting news (depending on your level of tech nerdy I suppose🤣); the PostgreSQL project seems to have settled on a future build system; Meson Build. git.postgresql.org/gitweb/?p=post…

Just released pgcopydb v0.9 with lots of improvements and bug fixes. See github.com/dimitri/pgcopy… Thanks to Christoph Berg packages are already uploaded to debian and all! Maybe Devrim Gündüz is next for the RPMs?

FYI, if you were waiting till the proverbial last minute to do your Postgres v15 beta testing, the time has arrived 😉

SQL Regression Tests tapoueh.org/blog/2017/08/s…

Postgres 15 is almost ready. Let's check some changes that might break compatibility with previous releases: 🧵

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/h…

Hana Mohan App devs are afraid of putting logic in SQL 🙂 Dimitri Fontaine ‘s The Art of PostgreSQL covers it well:

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/d…

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?

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/p…