>>You'll need to ensure security, using json web tokens for example
I have never used spark, looks fun (bad name for a project considering
apache spark dominates the "spark" name). I was thinking Jetty would be
pretty ideal, and/or restlet. I also like Grizzly. Vertx. is great, but
maybe overkill and would require too many dependencies.
I was thinking that the http server could optionally be run using an SSL
connector (JSSE SSL). Most micro-server frameworks make pretty easy to use
ssl. This should sufficiently handle security over the wire.
The format for querying the http server could be something like this in
JSON:
{
user: 'dbUserName',
pass: 'password',
sql: "slect * from users where name=? AND isIdiot=?",
params: ['Adam', true]
}
the response would just be an json array of rows.
The server could be run standalone something like this:
java -jar httpH2.jar -options <options.json>
The options.json would contain information like follwoing:
- path to DB:port
-user name, password of h2 database
- embedded or TCP (if embedded, the http server would run H2, else it will
simply connect to an existing H2 TCP server over JDBC
- ip whitelist - list of ips that can access the http server
-http port
- etc
On Thursday, February 23, 2017 at 6:13:28 AM UTC-5, Christian MICHON wrote:
>
> on point 2: it can be easily done with spark (sparkjava.com not apache
> spark) + jooq
>
> You'll need to ensure security, using json web tokens for example.
>
> On Thursday, February 23, 2017 at 3:47:33 AM UTC+1, Adam McMahon 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.
