Thanks Andrus and John for the feedback.
It looks like Postgres has better JSON support than MySQL.
regards Malcolm
On Wed, May 6, 2020 at 12:32 AM John Huss wrote:
> I have been using the Postgres JSONB type as an entity attribute (mapped as
> jdbc type OTHER) for some time, both with Lists a
I have been using the Postgres JSONB type as an entity attribute (mapped as
jdbc type OTHER) for some time, both with Lists and Maps. You can define an
ExtendedType subclass to read the value as a string and parse into a
map/list using Jackson's ObjectMapper.
On Mon, May 4, 2020 at 11:23 PM Malcol
Hi Malcolm,
I haven't done it, but I suspect it should just work in the scenario you
described. If it doesn't, we can look at details.
On that note, I've been working with geospatial data structures lately (mostly
on PostgreSQL). Parts of them map to JSON, and some - to geometries which are
a
Hi All,
I was hoping to use the JSON features in MySQL 5.7 and wondered if anyone had
used with with Cayenne. I was hoping to use Named Queries to perform JSON
specific queries, but treat it as a String otherwise with the Cayenne classes.
Any comments or recommendations would be appreciated.
