There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Read more about it in this article by Dimitri Fontaine at tapoueh.org/blog/2013/08/u…

The first notion to understand when processing text in any program is of course the notion of encoding. tapoueh.org/blog/2018/04/p…

Once the user data is properly stored as timestamp with time zone, PostgreSQL allows implementing all the processing you need to. In this article we dive into a set of examples to help you get started with time based processing in your database. ed.gr/dkvjt

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

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

Nearest Big City tapoueh.org/blog/2013/05/n…

How far is the nearest pub? tapoueh.org/blog/2013/08/h…

Database Normalization and Primary Keys... including a review of bad habits you might have when using sequences or automated id... which defeats the point entirely! tapoueh.org/blog/2018/03/d…

Database Modelization Anti-Patterns tapoueh.org/blog/2018/03/d…

Setting up psql, the PostgreSQL CLI tapoueh.org/blog/2017/12/s…

Exporting a Hierarchy in JSON: with recursive queries tapoueh.org/blog/2018/01/e…

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

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…

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…

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…

Reset Counter: I’ve been given a nice puzzle that I think is a good blog article opportunity, as it involves some thinking and window functions. tapoueh.org/blog/2012/10/r…

In this article we are going to use PostgreSQL to dive in an existing data set that we know very little about: the music catalog parts of the Chinook sample database. You can easily reproduce our queries locally should you want to. tapoueh.org/blog/2017/06/e…

The modern calendar is a trap for the young engineer’s mind. We deal with the calendar on a daily basis and until exposed to its insanity it’s rather common to think that calendar based computations are easy. Here we show case PostgreSQL abilities tapoueh.org/blog/2017/06/p…

This article by Dimitri Fontaine shows how to benefit from the PostgreSQL concept of a data type: more than input validation, a PostgreSQL data type also implements expected behaviours and processing functions. tapoueh.org/blog/2018/05/p…