| Re: Using SQL databases from IDL? [message #82248 is a reply to message #82245] |
Tue, 27 November 2012 01:04  |
lecacheux.alain
Messages: 325
Registered: January 2008
|
Senior Member |
|
|
Le lundi 26 novembre 2012 00:47:00 UTC+1, Bogdanovist a écrit :
> Does anyone have experience using SQL databases from IDL? Note that I am referring to vanilla IDL without additional license requirements such as Dataminer. I have found, for instance, a package idl-sql (http://code.google.com/p/idl-sql/) that allows SQL queries from IDL, but I also would need to be able to write to the database, as well as read.
>
>
>
> I currently use simple CSV files to store data however the kind of data queries I need to do means that I am effective re-coding a relational database within my IDL project in order to be able to provide myself a simple interface to grab the relevant data at any point that is likely to be distributed across multiple files. Can I use an SQL database to avoid re-engineering that wheel or does IDL not play nice with this?
A general solution for accessing SQL databases may consist in using ODBC (or JDBC) universal drivers via IDL COM (or Java) bridges. That is likely the solution adopted in the "idl-sql" software.
You can develop a more powerful solution, still by using IDL bridges, but by bypassing ODBC and directly accessing the driver specific to your particular database. In MS world, I am personnally happy with the combination IDL(COM)bridge/Delphi from Embarcadero for accessing various SQL databases like Firebird, SQLserver or Oracle.
Another plain IDL solution would consist in accessing some Web service, if any does exist for your database. I mean a Web server able to transmit SQL query and deliver HTML data to and from a remote database server. In this case the IDLnetURL and IDLffXMLSAX IDL objects, as well as the new (8.2) JSON_PARSE and JSON_SERIALIZE functions are very appropriate.
alain.
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
