Thread: Virtual table with pl/perl?

Hi!

I'm looking into implementing an updateable "virtual" table using pl/perl.

What i basically want to do is read out/update some external resources.
For programs using the SQL interface, this should look just like a
regular table except that it isn't ACID compliant (no rollbacks).

I'm pretty sure i can make a table, write a bunch of functions and some
do-instead rules. But is there a more elegant/simple solution?

LG
Rene

Rene Schickbauer escribió:
> Hi!
>
> I'm looking into implementing an updateable "virtual" table using pl/perl.
>
> What i basically want to do is read out/update some external
> resources. For programs using the SQL interface, this should look
> just like a regular table except that it isn't ACID compliant (no
> rollbacks).

Did you see DBI-Link in pgfoundry.org?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera wrote:
> Rene Schickbauer escribió:
>> Hi!
>>
>> I'm looking into implementing an updateable "virtual" table using pl/perl.
>>
>> What i basically want to do is read out/update some external
>> resources. For programs using the SQL interface, this should look
>> just like a regular table except that it isn't ACID compliant (no
>> rollbacks).
>
> Did you see DBI-Link in pgfoundry.org?

Looks interesting. Thanks.

Though i'm not yet sure i wanna go this way, i'd still have to implement
the database drivers for the stuff i need. Specifically, i need two
things: I need to access external devices via snmp and web, as well as
the ActiveDirectory for our windows domain controllers.

LG
Rene