postgres-json-schema allows validation of JSON schemas in PostgreSQL. It is implemented as a PL/pgSQL function and you can use it as a check constraint to validate the format of your JSON columns.

This directory contains my collection of SQL puzzles. I hope you enjoy these puzzles as much as I have enjoyed creating them! To get started, open the Advanced SQL Puzzles Markdown.md. ⌨️ The ...

TL;DR Why EN 303 645 matters ETSI EN 303 645 has given consumer IoT security a much-needed baseline. It gives manufacturers, assessors, and product teams a shared view of reasonable IoT security and ...