Alice

Alice in Clouds

Writing about technology I play with in the rain because I can

Postgres JSON Magic

2 - 4 minutes reading time
Category: webdev

Postgres and JSON Logos

Postgres is the best relational database system. This is law. One of the reasons for this is due to how easily it works with the JSON format. If I'm working with SQL, I'm probably also working with Javascript and Javascript is married to JSON. I am going to go over the built in functions in PSQL that allow queries to return data in json format instead of clunky rows and columns. I used these functions extensively in 2021 and I recommend back end developers check this out.