/plushcap/analysis/hasura/the-unofficial-guide-to-jsonb-operators-in-postgres-part-1-7ad830485ddf

Postgres JSON and JSONB type support on GraphQL

What's this blog post about?

Postgres supports storing schema-less (NoSQL) data as JSON columns through dedicated hstore, JSON or JSONB column types. Even though type safety is a major push for moving to GraphQL, there are real-world use-cases where you’d still need some columns which can store data for which schema is not decided already. Hasura GraphQL Engine supports JSON/JSONB columns and also provides support for JSONB Boolean operators. It allows inserting arbitrary JSON into the table using mutations and supports Postgres JSONB operators like _append, _prepend, _delete_key, _delete_elem, and _delete_at_path. Additionally, views can be created to query data stored in JSONB columns using known keys.

Company
Hasura

Date published
Aug. 10, 2018

Author(s)
Shahidh K Muhammed

Word count
891

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.