http://simonwillison.net/2023-01-28T03:50:46+00:00Simon Willison2023-01-28T03:50:46+00:002023-01-28T03:50:46+00:00https://simonwillison.net/2023/Jan/28/sqlite-jsonschema/#atom-tag

<p><strong><a href="https://github.com/asg017/sqlite-jsonschema">sqlite-jsonschema</a></strong></p> “A SQLite extension for validating JSON objects with JSON Schema”, building on the jsonschema Rust crate. SQLite and JSON are already a great combination—Alex suggests using this extension to implement check constraints to validate JSON columns before inserting into a table, or just to run queries finding existing data that doesn’t match a given schema. <p>Tags: <a href="https://simonwillison.net/tags/json">json</a>, <a href="https://simonwillison.net/tags/jsonschema">jsonschema</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/rust">rust</a>, <a href="https://simonwillison.net/tags/alex-garcia">alex-garcia</a></p>

2021-03-24T02:57:50+00:002021-03-24T02:57:50+00:00https://simonwillison.net/2021/Mar/24/understanding-json-schema/#atom-tag

<p><strong><a href="https://json-schema.org/understanding-json-schema/">Understanding JSON Schema</a></strong></p> Useful, comprehensive short book guide to JSON Schema, which finally helped me feel like I fully understand the specification. <p><small></small>Via <a href="https://twitter.com/kelseyhightower/status/1374371638297255938">@kelseyhightower</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/json">json</a>, <a href="https://simonwillison.net/tags/jsonschema">jsonschema</a></p>

2018-04-23T21:38:10+00:002018-04-23T21:38:10+00:00https://simonwillison.net/2018/Apr/23/react-jsonschema-form/#atom-tag

<p><strong><a href="https://github.com/mozilla-services/react-jsonschema-form">react-jsonschema-form</a></strong></p> Exciting library from the Mozilla Services team: given a JSON Schema definition, react-jsonschema-form can produce a cleanly designed React-powered form for adding and editing data that matches that schema. Includes support for adding multiple items in a nested array, re-ordering them, custom form widgets and more. <p>Tags: <a href="https://simonwillison.net/tags/cms">cms</a>, <a href="https://simonwillison.net/tags/forms">forms</a>, <a href="https://simonwillison.net/tags/json">json</a>, <a href="https://simonwillison.net/tags/jsonschema">jsonschema</a>, <a href="https://simonwillison.net/tags/mozilla">mozilla</a>, <a href="https://simonwillison.net/tags/react">react</a></p>

2009-12-23T14:44:06+00:002009-12-23T14:44:06+00:00https://simonwillison.net/2009/Dec/23/orderly/#atom-tag

<p><strong><a href="http://orderly-json.org/">Orderly JSON</a></strong></p> Essentially the JSON equivalent of RelaxNG’s compact syntax—a pleasant mini-language for describing JSON objects which compiles to the more verbose JSONSchema format. <p>Tags: <a href="https://simonwillison.net/tags/javascript">javascript</a>, <a href="https://simonwillison.net/tags/json">json</a>, <a href="https://simonwillison.net/tags/jsonschema">jsonschema</a>, <a href="https://simonwillison.net/tags/orderly">orderly</a>, <a href="https://simonwillison.net/tags/relaxng">relaxng</a></p>