Ask HN: ODBC driver using websockets?

https://news.ycombinator.com/item?id=1232153

by apollo • 16 years ago

1 4 16 years ago

news.ycombinator.com

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.

bdfh422• 16 years ago

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.

apollo• 16 years 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.

bdfh422• 16 years 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).

Ask HN: ODBC driver using websockets?

Related Stories