Virtual table with pl/perl?

Started by Rene Schickbauerabout 16 years ago3 messagesgeneral
Jump to latest
#1Rene Schickbauer
rene.schickbauer@gmail.com

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

#2Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Rene Schickbauer (#1)
Re: Virtual table with pl/perl?

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

#3Rene Schickbauer
rene.schickbauer@gmail.com
In reply to: Alvaro Herrera (#2)
Re: Virtual table with pl/perl?

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