Dynamic image
hero image example
Case Study

How Oracle is Bridging the Gap Between JSON Schema and Relational Databases

Loïc Lefèvre

2025-02-07 · 22 min read

Welcome to the JSON Schema Blog!

Want to publish a blog post? Check out the guidelines and submit yours!

rssRSS Feed
Filter blog posts by category...
How Oracle is Bridging the Gap Between JSON Schema and Relational Databases
Case Study
How Oracle is Bridging the Gap Between JSON Schema and Relational Databases
As modern multi-model databases increasingly support JSON, it's time to explore what role JSON schema will play.
Loïc Lefèvre
February 7, 2025
22 min readRead More
Celebrating JSON Schema’s Google Summer of Code 2024 Journey
Community
Celebrating JSON Schema’s Google Summer of Code 2024 Journey
Discover the projects, mentors, and contributors that shaped Google Summer of Code (GSoC) 2024!
Onyedikachi Hope Amaechi-Okorie
January 17, 2025
6 min readRead More
Moving Toward a Stable Spec
Update
Moving Toward a Stable Spec
Amidst all of the change at JSON Schema, what's happening with the spec?
Greg Dennis
January 13, 2025
8 min readRead More
JSON Schema conference: A milestone event at Apidays Paris 2024
Community
JSON Schema conference: A milestone event at Apidays Paris 2024
Apidays Paris 2024 was the venue for a significant milestone for our project: the first-ever JSON Schema Conference.
Valeria Hernandez
December 19, 2024
5 min readRead More
Update from the Google Season of Docs 2024 Project
Documentation
Update from the Google Season of Docs 2024 Project
An announcement blog post to share the JSON Schema documentation efforts from the GSOD team.
Blessing Ene Anyebe & Valeria Hernandez...
September 3, 2024
2 min readRead More
JSON Schema Ambassadors Are Here!
Community
JSON Schema Ambassadors Are Here!
Just what is a JSON Schema Ambassador? And how can I help? Keep reading!
Ben Hutton
June 20, 2024
8 min readRead More
Understanding JSON Schema Lexical and Dynamic Scopes
Engineering
Understanding JSON Schema Lexical and Dynamic Scopes
A deep dive on lexical and dynamic scopes, essential for understanding more advanced topics like dynamic referencing
Juan Cruz Viotti
February 15, 2024
15 min readRead More
Transforming the technical recruiting industry with JSON Schema
Case Study
Transforming the technical recruiting industry with JSON Schema
Learn how Manfred used JSON Schema to transform the technical recruiting industry.
Benjamin Granados & Yeray Darias
February 6, 2024
4 min readRead More
Transformando la industria de la contratación técnica con JSON Schema
Case Study
Transformando la industria de la contratación técnica con JSON Schema
Descubre cómo Manfred ha usado JSON Schema para transformar la industria de la contratación técnica.
Benjamin Granados & Yeray Darias
February 5, 2024
5 min readRead More
API Days Paris 2023 - Recap
Community
API Days Paris 2023 - Recap
API Days Paris 2023 has been an amazing experience for JSON Schema
Benjamin Granados
December 18, 2023
4 min readRead More
Interpreting JSON Schema Output
Engineering
Interpreting JSON Schema Output
Why does my passing validation contain errors?
Greg Dennis
November 8, 2023
7 min readRead More
Introducing the JSON Schema Adopters
Community
Introducing the JSON Schema Adopters
Explore our Adopters list to discover organizations successfully leveraging JSON Schema
Benjamin Granados
November 7, 2023
2 min readRead More
Announcing our new website
Community
Announcing our new website
We are so pleased to announce the launch of our new website!
Benjamin Granados
October 2, 2023
3 min readRead More
50+ million requests in 7 days on json-schema.org
Engineering
50+ million requests in 7 days on json-schema.org
See what we discovered when looking at over 50 million requests to the JSON Schema org domain from the last 7 days
Ben Hutton
September 15, 2023
12 min readRead More
Modelling Inheritance with JSON Schema
Engineering
Modelling Inheritance with JSON Schema
Can it be done? Well, sort of.
Greg Dennis
September 13, 2023
7 min readRead More
How JSON Schema Was an Obvious Choice at GitHub
Case Study
How JSON Schema Was an Obvious Choice at GitHub
At GitHub's Docs Engineering team, while shipping releases to production 20 times per day or more, JSON Schema is critical in increasing confidence in changes to data, content and APIs.
Julian Berman
September 9, 2023
5 min readRead More
Static Analysis of JSON Schema
Engineering
Static Analysis of JSON Schema
What can we know about a schema without having an instance to evaluate?
Greg Dennis
August 2, 2023
8 min readRead More
How Postman uses JSON Schema
Case Study
How Postman uses JSON Schema
Learn how JSON Schema continues to be a crucial component of the Postman API Platform and the API ecosystem.
Juan Cruz Viotti
July 17, 2023
6 min readRead More
How 6 River Systems saves time and boosts collaboration with JSON Schema
Case Study
How 6 River Systems saves time and boosts collaboration with JSON Schema
Explore the powerful impact of JSON Schema on 6 River Systems' fulfillment operations. Discover how they enabled enhanced collaboration, time savings, and data quality assurance, propelling their successful scaling journey.
Melinda Gutermuth & Ben Hutton
May 8, 2023
9 min readRead More
Using JSON Schema at Remote to scale forms and data validations
Case Study
Using JSON Schema at Remote to scale forms and data validations
Using JSON Schema at Remote was the first step to solving data validation and form generation problems across all levels at Remote.
Ben Hutton
May 6, 2023
8 min readRead More
The Last Breaking Change
Engineering
The Last Breaking Change
We need to make a breaking change so that we can promise we won't again.
Greg Dennis
February 23, 2023
5 min readRead More
Custom Annotations Will Continue
Engineering
Custom Annotations Will Continue
Custom annotations are one of JSON Schemas most-used features. Here's how we're still supporting them.
Greg Dennis
February 22, 2023
7 min readRead More
Hello 2023, Hello JSON Schema Community
Community
Hello 2023, Hello JSON Schema Community
I am excited to announce that I am joining as Developer Advocate with a focus on serving the Community
Benjamin Granados
January 10, 2023
2 min readRead More
Introducing: Bowtie
Engineering
Introducing: Bowtie
A new tool for executing JSON Schema implementations & a call to help improve it
Julian Berman
November 16, 2022
12 min readRead More
How the W3C Web of Things brings JSON Schema to the Internet of Things
Case Study
How the W3C Web of Things brings JSON Schema to the Internet of Things
Using JSON Schema at the W3C Web of Things to create an interoperability layer so that different IoT platforms, protocols and standards can operate together
Juan Cruz Viotti
November 1, 2022
6 min readRead More
Towards a stable JSON Schema
Update
Towards a stable JSON Schema
About this time last year, I hosted a discussion at the API Specification Conference about the future of JSON Schema. The most popular topic of discussion was, when JSON Schema is going to be 'done'. Of course we've heard that question a lot. The question stems from the 'draft' label we put on your releases. The term 'draft' has led to quite a bit of confusion for our community over the years, so let's take a moment to understand where it comes from.
Jason Desrosiers
October 21, 2022
6 min readRead More
Using Dynamic References to Support Generic Types
Engineering
Using Dynamic References to Support Generic Types
A step in the right direction for modelling data with JSON Schema
Greg Dennis
August 31, 2022
6 min readRead More
Fixing JSON Schema Output
Engineering
Fixing JSON Schema Output
I have a problem: when I read GitHub issues, they occasionally resonate with me, and I obsess about them until they're resolved. That may not sound like a problem to some, but when that resolution causes JSON Schema implementation developers to ask fundamental design questions for three years... yeah, that's a problem.
Greg Dennis
July 23, 2022
11 min readRead More
The Architectural Scope of JSON Schema
Opinion
The Architectural Scope of JSON Schema
What actually is JSON Schema?!
Greg Dennis
July 15, 2022
5 min readRead More
Joining Postman
Community
Joining Postman
In the last couple of weeks, you may have seen that Postman has been investing heavily in JSON Schema's future by hiring some of its top contributors giving them the opportunity to work full time on improving the JSON Schema specification and tooling ecosystem. I'm happy to announce that I'm the next addition to that team.
Jason Desrosiers
July 3, 2022
5 min readRead More
And Then There Were Three
Community
And Then There Were Three
More full-time contributors is better, right?
Greg Dennis
June 23, 2022
7 min readRead More
Hello World, Hello Postman
Community
Hello World, Hello Postman
Oh hello there! A second person is now working full-time on JSON Schema.
Julian Berman
June 16, 2022
7 min readRead More
Astonishing Serializations & Schemas of Hyperborea
Engineering
Astonishing Serializations & Schemas of Hyperborea
Using JSON Schema for validating role-playing character sheets.
Yanick Champoux
May 18, 2022
14 min readRead More
Get started with JSON Schema in Node.js
Engineering
Get started with JSON Schema in Node.js
Learn how to use JSON Schema for validation in your Node.js applications.
Simon Plenderleith
May 16, 2022
7 min readRead More
How Tyler Technologies reduced its client feedback loop with JSON Schema
Case Study
How Tyler Technologies reduced its client feedback loop with JSON Schema
Using JSON Schema at Tyler Technologies meant showing added value to clients could take minutes rather than days or in some cases weeks.
Ben Hutton
May 9, 2022
5 min readRead More
It all starts with applicability - JSON Schema Fundamentals part 1
Engineering
It all starts with applicability - JSON Schema Fundamentals part 1
We explore the fundamental JSON Schema concepts: Applicability, Subschemas, and Assertion Boolean Logic - Everyone needs good fundamentals.
Ben Hutton
March 21, 2022
16 min readRead More
JSON Schema joins the OpenJS Foundation and 2022 updates
Update
JSON Schema joins the OpenJS Foundation and 2022 updates
Find out what we've been doing in 2021 and read about our biggest development yet... joining the OpenJS Foundation. Oh, and WE'RE HIRING!
Ben Hutton
February 11, 2022
8 min readRead More
JSON Schema in 5 minutes
Engineering
JSON Schema in 5 minutes
Everyone needs good fundamentals, and understanding the basics of JSON Schema changes how you read, reason, and develop Schemas.
Ben Hutton
January 21, 2022
9 min readRead More
クックパッド株式会社におけるJSON Schemaの活用事例
Case Study
クックパッド株式会社におけるJSON Schemaの活用事例
クックパッド株式会社ではJSON Schemaを活用することによって、クックパッドマートにおける販売者の商品登録時の正確性と体験を改善し、商品審査にかかる運営上の負担を大幅に軽減することができました。
Ben Hutton
January 17, 2022
11 min readRead More
JSON Schema deduplicated complex logic and validation at Cookpad
Case Study
JSON Schema deduplicated complex logic and validation at Cookpad
Using JSON Schema at Cookpad improved the accuracy and experience when registering products, and has greatly reduced the operational burden of product screening.
Ben Hutton
December 9, 2021
6 min readRead More
Validating OpenAPI and JSON Schema
Engineering
Validating OpenAPI and JSON Schema
Dynamic references make it possible to validate the schemas in an OpenAPI document even though OpenAPI does not constrain which JSON Schema dialects can be used.
Jason Desrosiers
December 8, 2021
8 min readRead More
Why JSON Schema needs a Code of Conduct
Community
Why JSON Schema needs a Code of Conduct
The community of JSON Schema is growing, and the community needs a culture for interactions to avoid past mistakes.
Ben Hutton
November 24, 2021
10 min readRead More
JSON Schema bundling finally formalised
Engineering
JSON Schema bundling finally formalised
Existing tooling developers have created their own approaches to bundling JSON Schema and OpenAPI documents, but that can lead to errors. Bundling is now standardised.
Ben Hutton & Mike Ralphson
August 4, 2021
10 min readRead More