Storing Perl objects

#1

I understand that PostgreSQL has OO capabilities. Is it possible to
store full-blown Perl objects in a PostgreSQL table? (I suppose that
one can always serialize Perl objects and store the serialized text,
but this is hardly OO.)

Thanks,

kynn

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

#2

Hi,

maybe SPOPS will work, which is an acronym for Simple Perl Object Persistence with Security
which wraps calls like 'fetch' and 'store', and the real code lies in your subclassing SPOPS implementing DBI specific methods for the Postgres DBI (i'd imagine). There are a few other modules on CPAN which you would probably also inherit from and override methods to get them to work.

Unfortunately, I don't know what OO capabilities PostgreSQL has on its own. I suppose that's what you're asking, though.

On Sun, Feb 08, 2004 at 12:07:30PM -0500, kynn (AT) panix (DOT) com wrote:

Quote:

I understand that PostgreSQL has OO capabilities. Is it possible to
store full-blown Perl objects in a PostgreSQL table? (I suppose that
one can always serialize Perl objects and store the serialized text,
but this is hardly OO.)

Thanks,

kynn

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

--
joe speigle

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

#3

Kynn,

Quote:

I understand that PostgreSQL has OO capabilities.

Nope! Bzzzzzzzz. Thank you for playing. ;-)

We are Object-Relational, not Object Oriented. Object-Relational has to do
with our custom data types, operators, aggregates, and table inheritance. It
is not OO, or even really analogous.

Quote:

Is it possible to
store full-blown Perl objects in a PostgreSQL table? (I suppose that
one can always serialize Perl objects and store the serialized text,
but this is hardly OO.)

I suggest using Alzabo. Look it up on Freshmeat.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

#4

SPOPS, too
On Sun, Feb 08, 2004 at 09:36:45PM -0800, Josh Berkus wrote:

Quote:

Kynn,

I understand that PostgreSQL has OO capabilities.

Nope! Bzzzzzzzz. Thank you for playing. ;-)

We are Object-Relational, not Object Oriented. Object-Relational has to do
with our custom data types, operators, aggregates, and table inheritance. It
is not OO, or even really analogous.

Is it possible to
store full-blown Perl objects in a PostgreSQL table? (I suppose that
one can always serialize Perl objects and store the serialized text,
but this is hardly OO.)

I suggest using Alzabo. Look it up on Freshmeat.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Storing Perl objects

comp.databases.postgresql.novice comp.databases.postgresql.novice

Storing Perl objects - 02-08-2004 , 11:07 AM

Re: Storing Perl objects - 02-08-2004 , 06:03 PM

Re: Storing Perl objects - 02-08-2004 , 11:36 PM

Re: Storing Perl objects - 05-12-2004 , 11:18 AM