| Re: idl - Mysql interface [message #51408 is a reply to message #51406] |
Mon, 20 November 2006 09:52   |
Rick Towler
Messages: 821
Registered: August 1998
|
Senior Member |
|
|
There has been quite a few posts regarding IDL<->db connectivity.
Search the group.
Of course there is Dataminer. There is supposedly a package called
Datajiver that was recently released by a group from CNRS that provides
this interface too. An individual posted to the group regarding it, but
hasn't responded to my email queries. A google search digs up a
powerpoint presentation but that's it. A search of the CNRS website
turns up empty.
One other option if you are on windows *may* be using the ADODB COM
object. ITT and I seem to have differing opinions on this but I feel
that IDL's COM interface is a bit broken and incomplete. But, if you
can live with executing queries that return sets of data of a single
type (say all float or all char) this may be a winning solution. I have
taken this as far as I can with Oracle but I believe the Oracle driver
returns arrays of arrays as type VT_VARIANT (a vector of vectors) and
IDLcomIDispatch can't handle this, returning only the first element.
I'm guessing, but the ODBC driver returns a 2d array of VT_VARIANT where
IDL determines the type from the first element of the array. This is
why mixed type queries don't work. I have a good bit of code that you
can use to experiment with this if needed. It would be pretty trivial
to wrap all of this up into an object and performance is actually quite
good (Based on my limited experience with this in IDL and a lot of
experience with my ADODB implementation in MATLAB.) I'm just waiting
for IDLcomIDispatch to be completed before I do the work myself.
But like I said, search the group.
-Rick
Brian Larsen wrote:
> Hello, anyone have any experience interfacing IDL to a local mysql
> server? The idl help seems nearly incoherent when it comes to this.
>
> The situation is that I have a large (~15M records) database that I
> would like to play with the data in idl and using the power of the
> database I can do an appropriate select of the data before I read it
> into idl. I would have to imagine this is possible and am looking for
> any examples folks may have. I know how to do it with the idl-java
> bridge and idl-c interface but being able to avoid that would be a huge
> advantage (in programmer time).
>
> Cheers and thanks,
>
> Brian
>
>
> --
>
>
> ------------------------------------------------------------ ---------------
> Brian A. Larsen |
>
> | When you are in it up
>
> | to your ears,
> Dept. of Physics | keep
> your mouth shut.
> Space Science and Engineering Lab (SSEL)|
> Montana State University - Bozeman |
> Bozeman, MT 59717 |
>
> | ---------------------------------
> ------------------------------------------------------------ ---------------
> HOMEPAGE: http://solar.physics.montana.edu/larsen
> Maia: http://www.ssel.montana.edu/maia
> MEROPE: http://www.ssel.montana.edu/merope
>
> "I'm one of the most durable and fervent advocates of space
> exploration,
> but my take is that we could do it robotically at far less cost and far
>
> greater quantity and quality of results," - Dr. James Van Allen
>
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
