Json mapping MariaDB

[ghost]

Hello all,

we are using MariaDB as database and I would like to store a Circe json in the database.
In the documentation I saw that for Postgres you can use the following code for a bidirectional mapping:

implicit val jsonMeta: Meta[Json] =
  Meta.Advanced.other[PGobject]("json").timap[Json](
    a => parse(a.getValue).leftMap[Json](e => throw e).merge)(
    a => {
      val o = new PGobject
      o.setType("json")
      o.setValue(a.noSpaces)
      o
    }
  )

Since I don't have PGObject with MariaDB, how else could I do this mapping ?
Thanks a lot

[jatcwang]

@jmw847 PGobject is PostgreSQL JDBC driver's way of allowing you to set the value of a custom type (in this case the custom type is JSON). You'd need to find the equivalent way to do that in MariaDB's JDBC driver. (Sorry I spent a few min looking but didn't find anything)