How to prettify the JSON output in PostgreSQL®
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_pretty (jsonb_pretty for JSONB) to prettify the output.
How to parse JSON arrays in PostgreSQL?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to parse arrays from a JSON document:
How to JSON in PostgreSQL®
This series covers how to solve common problems on JSON datasets with PostgreSQL® and it includes (links will appear once the target pages are up):
How to extract a field from a JSON object in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to extract fields from a JSON document:
How to get the JSON field types in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_typeof (jsonb_typeof for JSONB) to extract the fields type.
How to index and query a JSON object in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB. This doc showcases how to index a JSONB column with a GIN index.
How to check if JSON contains in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to check if a value/field from a JSON document:
What are the differences between JSON or JSONB in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data:
JSONstores the JSON as text, performing a validation on the correctness of the JSON syntaxJSONBoptimizes the JSON storage in a custom binary format. Therefore, on top of validating the correctness of the JSON format, time is spent to properly parse and store the content.
From data stack to data stuck: the risks of not asking the right data questions
Companies are in a continuous motion: new requirements, new data streams, new technologies are popping up every day. When designing new data platforms supporting the needs of your company, failing to perform a complete assessment of the options available can have disastrous effects on a company’s capability to innovate, and making sure their data assets usable and reusable in the long term.
PostgreSQL Community and you
I started following the #PGSQLPhriday initiative a couple months back but never had the time to properly sit down and write due to conference traveling. Therefore I was super happy to be at home this week and find out that PGSQL Phriday #003 theme is about the PostgreSQL community!
