Get the latest tech news

Life Altering PostgreSQL Patterns

Believe it or not, I don't think that title is clickbait. There is a set of things that you can do when working with a Postgres database which I have found made my and my coworker's lives much more pleasant.

There is a set of things that you can do when working with a Postgres database which I have found made my and my coworker's lives much more pleasant. This has definite downsides like losing type information, needing to realize your results all at once, and the overhead of writing into json. But the giant upside is that you can get all the information you want from the database in one trip, no cartesian product nightmares or N+1 problems in sight.

Get the Android app