Ndifreke Ekott

Thoughts, stories, ideas and programming

22 Aug 2024

Understanding and Working With Sql/Json Language With Postgresql

I must say, I have enjoyed my journey of understanding PostgreSQL offerings for JSON data type. I am also realising how much ORMs do for you; there can be pros to using one and cons simultaneously depending on your personality. There is however a sense of satisfaction in understanding how the database we depend on for business works.

07 Aug 2024

Understanding Operations on Json Data Types With Postgresql

ostgreSQL provides some operators for working with `json` and `jsonb` data. The best way to review these operators is by memorising their use. There arenโ€™t names but symbols so hold on tight, while I write down a couple I think you are more likely to use them right away.

03 Aug 2024

Understanding and working with JSON data types with PostgreSQL

There was a time when if you had to work with a lot of JSON structured data, you had to turn to building NoSQL databases like MongoDB purposefully. However, the relational database world has caught on and given us the option to work with relational and non-relational data within the same database engine

31 Mar 2024
02 Mar 2024