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 <[email protected]> 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 [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. > -- 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.
