[h2] how do you store you documents?
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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: Issues joining the cluster IO Exception: "java.io.FileNotFoundException: backup.sql (The system cannot find the file specified)"; "backup.sql" [90031-191]
something like this: http://h2database.com/html/build.html#providing_patches sent to the mailing list, acts as our informal process for verifying contributions :-) thanks -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: Issues joining the cluster IO Exception: "java.io.FileNotFoundException: backup.sql (The system cannot find the file specified)"; "backup.sql" [90031-191]
Sorry for the delay, the pull request is created now - I had to re-learn
how to use GitHub, as this is my second time of using it this year. :)
About the license e-mail: I understand what it should be in principle ("I
grant license to use the code that I contributed in the H2 project")...
...but I don't know if you have a specific form the e-mail should follow,
and I couldn't even find which address to send it to. Can you advise?
--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
