TheArtOfPostgreSQL

The Art Of @PostgreSQL is the second edition of this book by @tapoueh that received such an amazing review from @sivers. Get the book at theartofpostgresql.com

This article by @tapoueh 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…

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…

@PostgreSQL solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. tapoueh.org/blog/2018/08/p…

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…

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…

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…

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…

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…

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

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

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

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

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…

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

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

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

"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 @tapoueh

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

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

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