3 ms·
It only works with SQLite, but my sqlite-utils Python library works a bit like that: you can feed it JSON objects and it will create a table schema to match: ht
by simonw 6y ago
It only works with SQLite, but my sqlite-utils Python library works a bit like that: you can feed it JSON objects and it will create a table schema to match: https://sqlite-utils.datasette.io/en/stable/python-api.html#creating-tables https://sqlite-utils.datasette.io/en/stable/python-api.html#...
It has a CLI tool as well: https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data https://sqlite-utils.datasette.io/en/stable/cli.html#inserti...
- hantusk 6y agoNeat! you could prototype out the db in sqlite, and then have sqlalchemy introspect and write out a db-agnostic model from this. Happy to see the support around foreign key relationships and lookup tables here. Thanks!