Hi, [1] I'm afraid the web-console doesn't use JSON or any other "standard" format (it would be nice thought).
[2] This I can't say. Regards, Thomas On Thu, Feb 23, 2017 at 3:47 AM, Adam McMahon <a...@cs.miami.edu> wrote: > Hi Group, > > i am considering a project that may require me to connect to an H2 > database froma non-JVM language (in this case php). I know the postgres > driver might work and querus is an option, but I would like to consider a > more general option: an http connector. > > It should be pretty easy to create a HTTP-JDBC bridge (perhaps an > afternoon of work) that accepts a a post request (with a json payload > describing the query) and return a json array of the results. A simple > servlet would do the trick that acts as a type of proxy to an underlying > JDBC connection. > > My question is: > > [1] Perhaps this is already done in the web-console? Is there > documentation for how the server of the web-console could be used as a more > general API over HTTP for H2? > > [2] Do you think anyone else would have use for this outside of my private > projects? I could fairly easily create a standalone sever (perhaps using > embedded jetty) that would allow someone to extend an H2 database over > http. A few security things would need to be worked out, but it seems > straight-forward. This may be nice as it would open H2 to a variety of non > JDBC languages (node.js, perl, php), using simple REST-like http > requests...thoughts? > > -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. > -- 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.
