Re: Metadata and DBI Abstraction

You should have a look to similar existing modules/framework. For instance :

I had a look to SPOPS (hi chis! ;-)). And especially SPOPS::SQLInterface it's pretty well writen. And this Class seems to implement a solution to your problem. SPOPS don't seem to support Postgresql (only mysql) but in CVS version At last, have look to past nodes on similar subject.

Comment on Re: Metadata and DBI Abstraction

Replies are listed 'Best First'.
Re: Re: Metadata and DBI Abstraction by lachoy (Parson) on Jun 09, 2001 at 20:25 UTC
As pop mentioned, SPOPS is moving along. PostgreSQL support will be in the next version (0.40) which should be released today or tomorrow (June 9-10). I've been using it for a month or so and it's given me no problems. It also supports Sybase ASE/ASA and MS SQL Server (thru DBD::ODBC on Win32). Other database support probably isn't that difficult -- the main differences are auto-generating primary keys and ensuring that the DBD driver supports datatype value binding. One of the features of SPOPS (and Class::DBI AFAIK) is that you can retrofit an object representation to existing data. That is: you don't need to modify your schema to use SPOPS. Accessing legacy data is a major strength of Perl, and this makes it easier... Chris M-x auto-bs-mode	[reply]

Replies are listed 'Best First'.

Re: Re: Metadata and DBI Abstraction
by lachoy (Parson) on Jun 09, 2001 at 20:25 UTC

As pop mentioned, SPOPS is moving along. PostgreSQL support will be in the next version (0.40) which should be released today or tomorrow (June 9-10). I've been using it for a month or so and it's given me no problems. It also supports Sybase ASE/ASA and MS SQL Server (thru DBD::ODBC on Win32). Other database support probably isn't that difficult -- the main differences are auto-generating primary keys and ensuring that the DBD driver supports datatype value binding.

One of the features of SPOPS (and Class::DBI AFAIK) is that you can retrofit an object representation to existing data. That is: you don't need to modify your schema to use SPOPS. Accessing legacy data is a major strength of Perl, and this makes it easier...

Chris
M-x auto-bs-mode

[reply]