Data schema compatibility check calculator

Calculate reader compatibility break candidates and added fields with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use reader compatibility break candidates and added fields to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

JSON Old schema [field,type string,nullable boolean]
[["id","integer",false],["name","string",false]]
JSON New schema [field,type string,nullable boolean]
[["id","integer",false],["name","string",true],["age","integer",true]]
Reader compatibility break candidates
["name: may introduce null"]
Added fields
["age"]
Break candidate count
1

Try another scenario

JSON Old schema [field,type string,nullable boolean]
[["id","integer",false],["name","string",false]]
JSON New schema [field,type string,nullable boolean]
[["id","integer",false],["name","string",false],["age","integer",true]]
Reader compatibility break candidates
[]
Added fields
["age"]
Break candidate count
0
Calculation method

Calculation method

Reader compatibility break candidates

Old required fields removed, exact types changed, or old nonnullable field now nullable.

Added fields

New field keys absent from old schema.

Break candidate count

Number of reported old-reader break candidates.

Symbols and units
a
JSON Old schema [field,type string,nullable boolean]
b
JSON New schema [field,type string,nullable boolean]

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Conservative flat-schema old-reader compatibility, exact type strings only; additions assumed tolerated by old reader. No language/database schema coercion rules. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.