TheArtOfPostgreSQL

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

[TheArtOfPostgreSQL @TheArtOPostgres]

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 https://t.co/ypl2x5FMY8

[Derek Sivers @sivers]

@tapoueh Full edition of "Mastering PostgreSQL…" is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!

[TheArtOfPostgreSQL @TheArtOPostgres]

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.

https://t.co/QsNCVc5FrP

[TheArtOfPostgreSQL @TheArtOPostgres]

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 https://t.co/XfAZdums0L

[TheArtOfPostgreSQL @TheArtOPostgres]

@PostgreSQL solves concurrent access to a set of data and maintains consistency while allowing concurrent operations. https://t.co/fgD2vtBsOO

[TheArtOfPostgreSQL @TheArtOPostgres]

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.

https://t.co/0XkhbJ6lje

[TheArtOfPostgreSQL @TheArtOPostgres]

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.

https://t.co/2RbQoFA92i

[TheArtOfPostgreSQL @TheArtOPostgres]

The state of the art Cardinality Estimation Algorithm called HyperLogLog is available as a @PostgreSQL extension! Read more about it at https://t.co/4tlSrhxYAa

[TheArtOfPostgreSQL @TheArtOPostgres]

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 https://t.co/0DU0zXk2yV

[TheArtOfPostgreSQL @TheArtOPostgres]

How to Write SQL as code and maintain it the same way as the rest of your code checkout? Read more at https://t.co/hCvzASJ4R1

[TheArtOfPostgreSQL @TheArtOPostgres]

SQL Regression Tests https://t.co/7Lo7rydk9O

[TheArtOfPostgreSQL @TheArtOPostgres]

Exporting a Hierarchy in JSON: with recursive queries https://t.co/NdqkNdQLQf

[TheArtOfPostgreSQL @TheArtOPostgres]

Setting up psql, the PostgreSQL CLI https://t.co/2ID0CvkreW

[TheArtOfPostgreSQL @TheArtOPostgres]

Database Modelization Anti-Patterns https://t.co/Ni0TXVnkUK

[TheArtOfPostgreSQL @TheArtOPostgres]

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! https://t.co/tnaV9m1scm

[TheArtOfPostgreSQL @TheArtOPostgres]

How far is the nearest pub? https://t.co/4HqfjvHg7V

[TheArtOfPostgreSQL @TheArtOPostgres]

Nearest Big City https://t.co/pjdL6rK9d6

[TheArtOfPostgreSQL @TheArtOPostgres]

The Most Popular Pub Names https://t.co/VVdZvNzqzQ

[TheArtOfPostgreSQL @TheArtOPostgres]

"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 https://t.co/QsNCVc5FrP from @tapoueh

[Craig Kerstiens @craigkerstiens]

Taking a few minutes today to practice some SQL. Loving having the @crunchydata playground - https://t.co/VSdkLJMUqR and with ?sql=filehere. I'm able to go through @tapoueh's The Art of PostgreSQL with some really awesome exercises https://t.co/ZJtzbgmtAs (PG15 code gets 30% off)

[TheArtOfPostgreSQL @TheArtOPostgres]

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.
https://t.co/UizfWoHTPl

[TheArtOfPostgreSQL @TheArtOPostgres]

The first notion to understand when processing text in any program is of course the notion of encoding. https://t.co/ixMl4dlt1l