Hi,
This is a little off topic, but I thought I would get feedback from the H2
group. When you need to store JSON in a database, how do you go about it?
Do you use H2, if not what do you use?
I was looking for a dependable embedded JVM based DB that handles docs,
but came up empty. OrientDB looks good, but many complain that it is too
buggy to use for anything serious.
JASDB looks cool, but does not seem to be highly used (and thus likely not
dependable).
Of coures, JSON can be stored in an RDMS in a varchar or CLOB. The problem
is running querries that can reach into the JSON. It does not seem like it
would be too hard to make a User-Defined function in H2 that allows one to
query into a JSON doc that is stored in a text based column.
t does not seem to be that hard to implement and could look something like
this, where JSONquery is a java function that would allow one to drill into
a text column with a simple DSL query language.
select * from myDocs where JSONquery(doc, 'o.name.first ==
Bob') AND JSONquery(doc, 'o.age > 25')
-Adam
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
