Type Constraints in 65 lines of SQL

• pg_jsonschema

  15 929 6.6 Rust

  PostgreSQL extension providing JSON Schema validation

  

• pg_graphql

  8 2,765 9.5 Rust

  GraphQL support for PostgreSQL

  

One of the restrictions of composite types is that they can not contain an instance of themselves. So unfortunately, this is not currently possible.

I had this issue when trying to implement an AST type for pg_graphql[1] back when it was written in SQL [2]. In the end we used a JSON type which was much less constrained. That might be solvable using pg_jsonschema [3] if you really wanted to have a good time though

[1] https://github.com/supabase/pg_graphql

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• pg-sql-variants

  1 28 10.0 PLpgSQL

  Variants types for PostgreSQL

• serde

  191 8,572 9.1 Rust

  Serialization framework for Rust

  

Suggest a related project