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.
You might like
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
@tapoueh Full edition of "Mastering PostgreSQL…" is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!
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…
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…
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…
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…
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…
United States Trends
- 1. Thanksgiving 2.38M posts
- 2. Post Malone 3,582 posts
- 3. Packers 68.5K posts
- 4. Dan Campbell 7,589 posts
- 5. #GoPackGo 11.3K posts
- 6. Malik Davis 1,901 posts
- 7. Wicks 11.6K posts
- 8. Tony Romo 1,088 posts
- 9. #ChiefsKingdom 4,384 posts
- 10. #KCvsDAL 4,112 posts
- 11. Jordan Love 17.9K posts
- 12. Micah Parsons 13.1K posts
- 13. Goff 11.6K posts
- 14. Kenneth Murray N/A
- 15. Jack White 10.4K posts
- 16. Caleb Wilson 1,628 posts
- 17. Turkey 315K posts
- 18. McDuffie 3,057 posts
- 19. Kelce 12.5K posts
- 20. #UFC324 3,542 posts
You might like
-
DBLab by Postgres.AI 💙💛
@Database_Lab -
Crunchy Data
@crunchydata -
pgBackRest
@pgBackRest -
Nik Samokhvalov
@samokhvalov -
Joseph Conway
@josepheconway -
Arpit Bhayani
@arpit_bhayani -
Alexander Kukushkin
@cyberdemn -
Data Egret | PostgreSQL support
@dataegret -
Haider.
@slow_developer -
Postgres Ibiza 2025
@pg_ibz -
100 School 💯
@100schoolHQ -
NG Tutorial 🔥
@NG_Tutorial -
Redis
@Redisinc -
Peter Geoghegan
@petervgeoghegan -
OpenVAERS
@OpenVAERS
Something went wrong.
Something went wrong.