Ask HN: ODBC driver using websockets?

1 pointsapollo16y ago4 comments

Does a javascript ODBC driver exist that works over websockets? If not, is it feasible?

I'd like to be able to send queries to an SQL database directly from the browser, with no proxy.

4 comments

3 comments · 1 top-level

bdfh4216y ago· 2 in thread

OK - perhaps dumb question - but what is the problem with AJAX and a web service to return the SQL query results in (say) JSON format? It is pretty simple and works very well.

The concept of an ODBC driver being run directly from Javascript if not to something like a "sandboxed" instance of SQLight is a bit worrying on security grounds.

apolloOP16y ago

It's possible to do it that way, but it adds some annoying constraints. If you're accessing data locally, it would have to go through a remote server, which causes latency and privacy concerns.

bdfh4216y ago

Sorry, I am still not getting this - if the data is local then why not run the app on a server running on the local machine.

Alternately you are trying to access local personal data using a remote app - so you need Google's or HTML5's support for a local database (SQLight I think but in a wrapper).

1 more reply

j / k navigate · click thread line to collapse