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.
