Using mysql to store id-to-json tables.
script | ||
src/Database/MySQL | ||
test | ||
.gitignore | ||
changelog.md | ||
license | ||
mysql-json-table.cabal | ||
readme.md |
mysql-json-table
Using mysql to store id-to-json tables.
A table would look something like this:
id | data |
---|---|
Row identifier | JSON-encoded value |
Why would you do this?
To re-use mysql-server capabilities without having to deal with table reshaping. If changes come down the road, the data content might change, but the table stays the same. JSON can easily be made compatible between versions, making for smoother releases and rollbacks. It's also simple, and I like simple.
Documentation
Haddock documentation can be found here (based on the main branch).