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.

Reply via email to