Show HN: Pg-jason-validator fastest JSON schema validation via C Macros

Category: library

Tags: postgresql, json-schema, code-generation, c-extension, performance

Score: 6.8/10 (Innovation: 6, Technical: 8, Documentation: 7, Utility: 6)

pg_jason_validator is a PostgreSQL extension that uses compile-time code generation via C macros to create fast JSON schema validators for jsonb data. By resolving schema structure at build time and eliminating runtime schema parsing, it achieves significant performance improvements over competing libraries, which is interesting for high-throughput production databases.

Target audience: backend devs, data engineers

Repository: https://github.com/furstenheim/pg-jason-validator · Python · MIT

View on Hacker News