search

ClosestStorm / v8cgi

Automatically exported from code.google.com/p/v8cgi
BSD 3-Clause "New" or "Revised" License
0 stars 1 forks source link

database support including ODBC #92

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
This is a recommendation for an enhancement.  The feature I use most in my Perl 
scripts is the DBI/DBD database interface and mainly with ODBC so I can access 
DB2, Oracle and other databases at work.  Would love to be able to switch my 
Perl scripts over to v8cgi scripts, but would need better database support to 
do so.  I noticed there was support for mysql and postgresql for v8cgi.  Is 
there an overall standard interface (like with Perl DBI) to accessing databases 
through v8cgi?  Does/will CommonJS have some standard like this for database 
access?  

It would be nice to have a standard API for database access so one could easily 
switch between databases by changing a line or two without having to rewrite 
the rest of the code (similar to DBI in Perl).  Would also like to see ODBC 
support added in (using a standard database API).  

There are two projects I know of that support ODBC on POSIX machines:
http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/
http://www.unixodbc.org/

I also have some code for accessing ODBC databases via DLL in MinGW from C/C++.

Am hoping some of these resources and ideas can be combined to give better, 
more flexible database support to v8cgi.

Original issue reported on code.google.com by lme...@gmail.com on 10 May 2011 at 7:10

GoogleCodeExporter commented 9 years ago 
Yeah, adding support for the ODBC abstraction sounds very reasonable. I do not 
have much time for such improvements, but I am adding it to TODO list.

Original comment by ondrej.zara on 10 May 2011 at 8:00

GoogleCodeExporter commented 9 years ago 
Have you seen http://code.google.com/googleapps/appsscript/service_jdbc.html

Original comment by ging...@iteams.org on 25 Aug 2011 at 3:45

GoogleCodeExporter commented 9 years ago 
Have you seen http://code.google.com/googleapps/appsscript/service_jdbc.html

Original comment by ging...@iteams.org on 25 Aug 2011 at 3:45

GoogleCodeExporter commented 9 years ago 
I took a look at Google's Apps Scripts that were recommended.  They only run on 
Google's Servers.  Their tools are really quite useless if you want to run 
anything locally on your own machine.  Also, it makes no use of V8CGI 
altogether and is an alternative to V8CGI that's geared very much to working 
with Google's Applications and only with their servers.  Unless you're doing 
something that's Google Application specific, I think V8CGI gives far more 
flexibility and functionality.  I didn't see any of Google's source code for 
their Apps Script project available as Open Source either.  They may have an 
open API for their tools, but I don't see a way to make use of any of their 
code (for connecting to databases or other functionality) with V8CGI.

Original comment by lme...@gmail.com on 30 Aug 2011 at 12:34

GoogleCodeExporter commented 9 years ago 
http://code.google.com/p/teajs/issues/detail?id=4

Original comment by ondrej.zara on 20 Jul 2012 at 7:48