mysql-json-table

Using MySQL to store id-to-json tables.

https://codeberg.org/daniel-casanueva/mysql-json-table

LTS Haskell 23.20:0.1.4.1
Stackage Nightly 2025-05-01:0.1.4.1
Latest on Hackage:0.1.4.1

See all snapshots mysql-json-table appears in

MIT licensed
Maintained by Daniel Casanueva (coding `at` danielcasanueva.eu)
This version can be pinned in stack with:mysql-json-table-0.1.4.1@sha256:d0dc4604755d5804483e5acbf3d59205638a6bba474c744e2c8ad655f66de583,1158

Module documentation for 0.1.4.1

Used by 1 package in nightly-2025-03-28(full list with versions):
mysql-json-table

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).

Changes

0.1.4.1

  • Metadata update.

0.1.4.0

  • Add Hashable instance for the Id type.

0.1.3.0

  • New instances for Id:
    • FromJSONKey
    • ToJSONKey
    • FromHttpApiData
    • ToHttpApiData

0.1.2.0

  • Re-export: ConnectInfo, defaultConnectInfo, Connection.
  • New function: withSQL.
  • Fix id table creation.
  • Fixes for id table queries.

0.1.1.0

  • Add new function: moveId.

0.1.0.1

  • Add lower bound for mysql-simple dependency.

0.1.0.0

  • Initial release.