| Re: postgresql queries [message #58028] |
Mon, 14 January 2008 01:06 |
Allan Whiteford
Messages: 117
Registered: June 2006
|
Senior Member |
|
|
Robbie wrote:
> Hi Allan,
>
> I didn't realize that your driver existed.
>
> I've been doing much that same, but using libpq++. I've been playing
> with large object support.
>
> I tried using IDLdbDatabase. I found it difficult to get working and
> completely useless when I finally managed to write a query. The data
> type mapping was all wrong and I could not include quotes (') in my
> query. The error messages and segmentation faults were so cryptic that
> I gave up.
>
> Robbie
Robbie,
It's not mine, sorry if it seemed like I was claiming credit.
I just came across it while looking for a MySQL API a while back. I had
similar issues when looking at IDLdbDatabase but I don't think I got as
far as you.
Thanks,
Allan
|
|
|
|
| Re: postgresql queries [message #58039 is a reply to message #58028] |
Sat, 12 January 2008 03:32  |
skymaxwell@gmail.com
Messages: 127
Registered: January 2007
|
Senior Member |
|
|
i did sometimes ago connect to MySQL and Oracle Express Edition
databases from IDL
I use ODBC drivers from Oracle site and MySQL site, becouse Dataminer
don't support them (as show in IDL help). So you can try Postgres ODBC
driver
|
|
|
|
| Re: postgresql queries [message #58041 is a reply to message #58039] |
Fri, 11 January 2008 14:17 |
Robbie
Messages: 165
Registered: February 2006
|
Senior Member |
|
|
Hi Allan,
I didn't realize that your driver existed.
I've been doing much that same, but using libpq++. I've been playing
with large object support.
I tried using IDLdbDatabase. I found it difficult to get working and
completely useless when I finally managed to write a query. The data
type mapping was all wrong and I could not include quotes (') in my
query. The error messages and segmentation faults were so cryptic that
I gave up.
Robbie
|
|
|
|
| Re: postgresql queries [message #58060 is a reply to message #58041] |
Fri, 11 January 2008 08:20 |
Brian Larsen
Messages: 270
Registered: June 2006
|
Senior Member |
|
|
On Jan 11, 11:08 am, Allard de Wit <allard.de...@wur.nl> wrote:
> On Jan 11, 4:55 pm, Dave <Confused.Scient...@gmail.com> wrote:
>
>> Does anyone know if there is a general way to connect and query a
>> postgresql database from within IDL using linux and os x? My group
>> has a few linux licenses for 6.4/7.0 but I'm using an older version of
>> the student version on my laptop (os x).
>
>> Many thanks,
>> Dave
>
> Dear Dave,
>
> You will probably need the IDL dataminer which is licensed separately.
> I am not sure whether it supports PostgreSQL though.
> The other route is to write a DLM using the open source drivers for
> postgress, but I have no experience with that.
>
> If IDL is not strictly needed, you may consider Python which has
> excellent DB support including PostgreSQL.
>
> with best regards,
>
> Allard
I have done this before with mysql with spawn statements calling
queries. It worked, dataminer is better but costs money.
Cheers,
Brian
------------------------------------------------------------ --------------
Brian Larsen
Boston University
Center for Space Physics
|
|
|
|
| Re: postgresql queries [message #58061 is a reply to message #58060] |
Fri, 11 January 2008 08:08 |
wita
Messages: 43
Registered: January 2005
|
Member |
|
|
On Jan 11, 4:55 pm, Dave <Confused.Scient...@gmail.com> wrote:
> Does anyone know if there is a general way to connect and query a
> postgresql database from within IDL using linux and os x? My group
> has a few linux licenses for 6.4/7.0 but I'm using an older version of
> the student version on my laptop (os x).
>
> Many thanks,
> Dave
Dear Dave,
You will probably need the IDL dataminer which is licensed separately.
I am not sure whether it supports PostgreSQL though.
The other route is to write a DLM using the open source drivers for
postgress, but I have no experience with that.
If IDL is not strictly needed, you may consider Python which has
excellent DB support including PostgreSQL.
with best regards,
Allard
|
|
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
