Postgres JSON and JSONB type support on GraphQL
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
Hacker News points
None found.
Language
English