TheArtOfPostgreSQL
@TheArtOPostgres
Followers
416
Following
69
Media
8
Statuses
179
The book that teaches SQL to application developers. Turn thousands of lines of code into simple SQL queries! Written and published by @tapoueh.
Joined August 2021
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
The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!
@tapoueh Full edition of "Mastering PostgreSQL…" is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!.
1
2
9
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
Today it’s time to conclude our series of PostgreSQL Data Types articles with a recap. The series cover lots of core PostgreSQL data types and shows how to benefit from the PostgreSQL concept of a...
1
2
4
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
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...
0
1
1
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
Sometimes you need to dive in an existing data set that you know very little about. Let’s say we’ve been lucky to have had a high level description of the business case covered by a database, and...
0
2
1
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
I’ve been given a nice puzzle that I think is a good blog article opportunity, as it involves some thinking and window functions.
0
1
1
The state of the art Cardinality Estimation Algorithm called HyperLogLog is available as a @PostgreSQL extension! Read more about it at
tapoueh.org
If you’ve been following along at home the newer statistics developments, you might have heard about this new State of The Art Cardinality Estimation Algorithm called HyperLogLog. This technique is...
1
4
9
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
In our Tour of Extensions today’s article is about advanced tag indexing. We have a great data collection to play with and our goal today is to be able to quickly find data matching a complex set of...
0
2
10
How to Write SQL as code and maintain it the same way as the rest of your code checkout? Read more at
tapoueh.org
Kris Jenkins cooked up a very nice way to embed SQL in your code: YeSQL for Clojure. The main idea is that you should be writing your SQL queries in .sql files in your code repository and maintain...
0
6
18
Exporting a Hierarchy in JSON: with recursive queries
tapoueh.org
In another article here, entitled on JSON and SQL, we saw in great details how to import a data set only available as a giant JSON file. Then we normalized the data set, so as to be able to write SQL...
1
4
14
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
In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of PostgresQL, so it’s only fair...
0
0
0
"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 from @tapoueh.
tapoueh.org
Today it’s time to conclude our series of PostgreSQL Data Types articles with a recap. The series cover lots of core PostgreSQL data types and shows how to benefit from the PostgreSQL concept of a...
0
4
7
RT @craigkerstiens: Taking a few minutes today to practice some SQL. Loving having the @crunchydata playground - an….
crunchydata.com
Your safe place to test out Postgres in the browser
0
5
0
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.
0
3
10
The first notion to understand when processing text in any program is of course the notion of encoding.
tapoueh.org
Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in any program is of course the notion...
0
4
12
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
There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can be quite hard to grasp the...
1
8
17