better / Jsonschema2db
Licence: mit
Generate tables dynamically from a JSON Schema and insert data
Stars: ✭ 152
Programming Languages
python
139335 projects - #7 most used programming language
Labels
Projects that are alternatives of or similar to Jsonschema2db
Full Stack Fastapi Postgresql
Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.
Stars: ✭ 7,635 (+4923.03%)
Mutual labels: json-schema, postgresql
Invenio
Invenio digital library framework
Stars: ✭ 469 (+208.55%)
Mutual labels: json-schema, postgresql
Dapper.fsharp
Lightweight F# extension for StackOverflow Dapper with support for MSSQL, MySQL and PostgreSQL
Stars: ✭ 145 (-4.61%)
Mutual labels: postgresql
Node Express Postgresql Sequelize
Node.js, Express.js, Sequelize.js and PostgreSQL RESTful API
Stars: ✭ 148 (-2.63%)
Mutual labels: postgresql
Sqlcell
SQLCell is a magic function for the Jupyter Notebook that executes raw, parallel, parameterized SQL queries with the ability to accept Python values as parameters and assign output data to Python variables while concurrently running Python code. And *much* more.
Stars: ✭ 145 (-4.61%)
Mutual labels: postgresql
Algernon
🎩 Small self-contained pure-Go web server with Lua, Markdown, HTTP/2, QUIC, Redis and PostgreSQL support
Stars: ✭ 1,880 (+1136.84%)
Mutual labels: postgresql
Go Cache
This project encapsulates multiple db servers, redis、ledis、memcache、file、memory、nosql、postgresql
Stars: ✭ 143 (-5.92%)
Mutual labels: postgresql
Rust Webapp Starter
Rust single page webapp written in actix-web with vuejs.
Stars: ✭ 151 (-0.66%)
Mutual labels: postgresql
Json Schema Viewer
JavaScript tool for visualizing json-schemas
Stars: ✭ 147 (-3.29%)
Mutual labels: json-schema
Pg2ch
Data streaming from postgresql to clickhouse via logical replication mechanism
Stars: ✭ 149 (-1.97%)
Mutual labels: postgresql
Indigo
Universal cheminformatics libraries, utilities and database search tools
Stars: ✭ 146 (-3.95%)
Mutual labels: postgresql
Lapidus
Stream your PostgreSQL, MySQL or MongoDB databases anywhere, fast.
Stars: ✭ 145 (-4.61%)
Mutual labels: postgresql
Querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Stars: ✭ 2,111 (+1288.82%)
Mutual labels: postgresql
Aptos
☀️ A tool for validating data using JSON Schema and converting JSON Schema documents into different data-interchange formats
Stars: ✭ 144 (-5.26%)
Mutual labels: json-schema
Ajv Cli
Use 'Another Json Validator' (ajv) from the command line
Stars: ✭ 148 (-2.63%)
Mutual labels: json-schema
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.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].