Skip to content

better/jsonschema2db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Travis status

JSON Schema ➣ Database

We use JSON Schema pretty extensively at Better to store complex data. Unfortunately the data is hard to query from SQL. To facilitate querying, this library converts objects stored in a JSON schema into flat Postgres tables with proper types.

For instance, Better uses it to generate 50+ tables automatically, with millions of rows, from a very complex JSON schema that is 7000+ lines long.

Postgres and Redshift are supported, although the latter is somewhat experimental still.

Installation

The easiest way to install is pip install jsonschema2db

Documentation

See full documentation for more info about how to use jsonschema2db!

Other

  • The code is tested with a full integration test running a Postgres server inside Docker. To run tests, run docker build -t jsonschema2db . && docker run jsonschema2db
  • Pull requests are very welcome.
  • This repo uses the MIT license.

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •