Interesting, PG3 takes the postgres jsonb type and converts it into a JsonObject for me.
So, instead of doing asDictionary, I suspect that I should I be able to work on the JsonObject directly without converting it.
heh...there was a moment of "oh! this changes everything" when I saw the
Object asPG3SqlLiteral
Where I thought I could store objects in the database Postgres database directly, but the attempt on an instance of the object only created the Object name
Since my objects are only data-buckets...I wonder if it is worth pursuing.
Has anybody done this?
I tried an experiment where I stored millions of objects in-image, which was fine except I needed 70Gb of RAM to store the image in-memory, and IIRC I only had about 35Gb of RAM.
If I could get that same sort of functionality by storing objects in Postgres, that would be awesome and a lot of fun to explore.
cordially