How to Query a JSON Column in PostgreSQL
As a software engineer, it is common to store structured data in a relational database such as PostgreSQL, or unstructured data in a non-relational database such as Mongo DB. Luckily, PostgreSQL allows defining column types as json and jsonb, which are two JSON (JavaScript Object Notation) data types that allow storing unstructured data in a … Read more
