From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql to Delphi |
Date: | 2007-03-20 21:45:01 |
Message-ID: | 010001c76b39$03800d20$8e904618@owner |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Listen/notify implies a dynamic table that is constantly on the change. Am I
correct?
The table I am talking about is completed through one interface then
imported as a relatively static information base for the application in
which I am seeking help.
Bob
----- Original Message -----
From: "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>; <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 20, 2007 2:16 PM
Subject: Re: [GENERAL] Postgresql to Delphi
> Bob Pawley wrote:
>> Hi
>> I have posed this question to the Delphi list but they don't appear to
>> be able to help.
>> I am attempting to have the information in a PostgreSQL database table
>> trigger a function in Delphi.
>> At present the delphi application is triggered by a mouseup on a TImage
>> file, residing in a notebook, through an alias
>> (DeviceNotebookMouseUpAlias). I want to have the Postgres use this alias
>> to trigger the function.
>> Could someone point me to any literature that would help me with this
>> project?
>> Bob Pawley
> I would have replied to the Delphi List if I had seen it :-)
>
> The best way would be to use the listen/notify that PostgreSQL provides,
> but only a couple of the Delphi libraries support
> notifications from PostgreSQL, zeoslib does not work at all, nor will the
> PGSQL driver that shipped with Kylix.
> PostgresDAC from Microolap (http://www.microolap.com) will work with
> notifications and they have pretty decent support.
> If you prefer Dbexpress you could try the driver from www.vitavoom.com
> which has support for notifications, but it is a bit pricey compared to
> the Microolap product. There is also a library for libpq.dll out there
> if you want to code really low level.
>
> And for those out there who don't know what Delphi is, check out
> http://www.codegear.com
> It's basically Visual Object Pascal and works very similar to VB version
> 6, except it has full support for inheritance etc and can program down to
> the bare metal using inline Assembler if you really need to do that :-) It
> also has full support for pointers etc so you can pretty much get the
> performance of C or C++ all in the same package. Using Delphi for
> database applications is like being in Paradise all the time :-)
>
>
> Later,
>
> --
> Tony Caduto
> AM Software Design
> http://www.amsoftwaredesign.com
> Home of PG Lightning Admin for Postgresql
> Built with CodeGear Delphi 2007
> Your best bet for Postgresql Administration
>
From | Date | Subject | |
---|---|---|---|
Next Message | Anton Melser | 2007-03-20 21:45:31 | "sniffing" postgres queries |
Previous Message | Geoffrey | 2007-03-20 21:39:52 | Re: Postgresql to Delphi |