TheArtOfPostgreSQL @TheArtOPostgres

The book that teaches SQL to application developers. Turn thousands of lines of code into simple SQL queries! Written and published by @tapoueh. theartofpostgresql.com Joined August 2021

Tweets

179
Followers

415
Following

63
Likes

69

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

1 2 4 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 1 1 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 2 1 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 1 1 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

1 4 9 0 4

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 2 10 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 6 18 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 3 15 0 5

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

1 4 14 0 1

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 0 3 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 1 3 0 1

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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…

0 0 0 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 2 1 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 0 0 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 3 3 0 0

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

"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

0 4 7 0 0

Craig Kerstiens @craigkerstiens

3 years ago

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)

0 5 10 0 2

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 3 10 0 3

Download Image

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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

0 4 12 0 1

TheArtOfPostgreSQL @TheArtOPostgres

3 years ago

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 @tapoueh at tapoueh.org/blog/2013/08/u…