[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.
[h2] Logfile Analysis // help!?
Hi all, I am currently working on a (chatlog) logfile analysis and the major issue is that I need to separate "sequences" in which there is some sort of "interactivity" (user inputs and answers of the chatbot 'alternate' or take it in turns to communicate) from sequences in which the chatbot is merely asking several questions in a row without any user reacting to his notes. E.g.: bot: blablabla? bot: blablabla bot: blablabla? bot: blablablaa?! bot:. user1: hi there bot: nice to meet you user1, what's your name? user1:... bot:... user1:... bot:... user1: okay have a nice evening bot bot: thanks user1 bot: hi user1 are you still there? bot: hello? bot: blablabla ... In this example above it would be nice to separate the sequence when user1 comes in talking to the bot (and finishing the conversation at some point with a farewell) from sequences in which the bot is trying to attract users (asking questions or dropping statements) without getting any user input. As I am a total SQL newbie I would really appreciate some advice of how to separate and categorize properly. Best wishes, Henning -- 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.
