Fwd: Module submission DBIx::DB

Fwd: Module submission DBIx::DB

am 31.12.2005 21:18:01 von Tyler

Hi,

I was hoping to start a discussion about this; there is currently no
place on CPAN specifically designated for a distribution that supplies a
database schema, and perl modules specifically for interacting with that
schema. As such they generally end up in DBIx::foo, along with things that
extend DBI itself, or bundled inside a larger package (Catalyst,
CGI::Session, Business:: distributions that do more than just touch the
schema, etc). I've sent a module submission request into PAUSE to get the
people in control of the module namespaces thinking about it, here it is.
I'm not sure if DBIx::DB is the best place for this (DBIx::Schema would have
been great but it's name is taken for a schema management system), but
there's got to be *somewhere* we could standardize on to put these things...

Cheers,
Tyler


----- Forwarded message from Perl Authors Upload Server -----

modid: DBIx::DB
DSLIP: idhhp
description: DBI Database schemes with perl interfaces
userid: CRAKRJACK (Tyler MacDonald)
chapterid: 7 (Database_Interfaces)
communities:
dbi-users@perl.org

similar:

rationale:

I've looked around on CPAN and there doesn't seem to be "one place"
for distributions that provide:

- A database schema, and - A perl interface to that database schema

Instead, people seem to make up their own convention, or even
worse, bundle their database-driven objects into a much larger
package (eg; coupling an authentication database to a particular
server's implementation, or coupling a URL keyword indexing database
to a particular web spider).

I'm a big fan of having more smaller pieces, and of knowing where
to look to find them. Instead of names like "DBIx::UserDB" and
"CGI::Session::DBI" I'd eventually like to see "DBIx::DB::User" and
"DBIx::DB::Session". Those examples were contrived for a reason:
They're two packages that could be very useful when used together!
but as it stands, there is no DBIx::UserDB distribution, instead
SearchProfiles and Apache-iNcom both bundle the package in
themselves (requiring you to install one or the other to use it),
and "CGI::Session::DBI" only occurs to somebody who has already
learned about CGI::Session, which might not be the same string
somebody thinks of when they decide they need a database schema for
session management.

Just my two cents... I'm going to be releasing a couple of
database-object-driven distributions in the near future and it
occured to me that there's no "standard" place for them to live. Can
a namespace be registered without a package for this purpose?

Thanks, Tyler

enteredby: CRAKRJACK (Tyler MacDonald)
enteredon: Sat Dec 31 20:27:24 2005 GMT

The resulting entry would be:

DBIx::
::DB idhhp DBI Database schemes with perl interfaces CRAKRJACK


Thanks for registering,
--
The PAUSE

PS: The following links are only valid for module list maintainers:

Registration form with editing capabilities:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USER ID=b9c00000_d69b2385910f57e2&SUBMIT_pause99_add_mod_preview= 1
Immediate (one click) registration:
https://pause.perl.org/pause/authenquery?ACTION=add_mod&USER ID=b9c00000_d69b2385910f57e2&SUBMIT_pause99_add_mod_insertit =1


----- End forwarded message -----

Re: Fwd: Module submission DBIx::DB

am 31.12.2005 22:10:03 von me

On Saturday 31 December 2005 2:18 pm, Tyler MacDonald wrote:
> Hi,
>
> I was hoping to start a discussion about this; there is currently no
> place on CPAN specifically designated for a distribution that supplies a
> database schema, and perl modules specifically for interacting with that
> schema. As such they generally end up in DBIx::foo, along with things that
> extend DBI itself, or bundled inside a larger package (Catalyst,
> CGI::Session, Business:: distributions that do more than just touch the
> schema, etc). I've sent a module submission request into PAUSE to get the
> people in control of the module namespaces thinking about it, here it is.
> I'm not sure if DBIx::DB is the best place for this (DBIx::Schema would
> have been great but it's name is taken for a schema management system), but
> there's got to be *somewhere* we could standardize on to put these
> things...
>
> Cheers,
> Tyler

I you talking about cataloging pre-defined table layouts for specific modules
or processes?

If so, for naming why does it need to be DBIx why not RDBMS::Schema::Blah

Jay

Re: Fwd: Module submission DBIx::DB

am 02.01.2006 21:28:23 von Tyler

Jay Strauss wrote:
> I you talking about cataloging pre-defined table layouts for specific modules
> or processes?

That, or modules that do all of their work on a database schema. Eg;
if you had a module that accepted longitudes and latitudes and built up a
waypoint database, and let you query that database for the distances between
two points, or attempted to solve the travelling salesman problem on the
waypoints in the database, that would probably belong in this
not-yet-existant module namespace. However, if it could also read data from
your GPS device to use against the database, that probably wouldn't belong.
(Or, the GPS device part could be a separate module that depends on your
schema objects).

> If so, for naming why does it need to be DBIx why not RDBMS::Schema::Blah

Well, the "RDBMS::" namespace doesn't seem to exist on CPAN yet...
Of course, neither does the "Schema::" namespace. So maybe just
"Schema::Blah"?

- Tyler

RE: Fwd: Module submission DBIx::DB

am 02.01.2006 22:23:27 von ted.behling

Perhaps use Schema::RDBMS::Foo. This would allow for non-RDBMS schema =
modules, based on XML, DB files, or others.

-----Original Message-----
From: Tyler MacDonald [mailto:tyler@yi.org]
Sent: Monday, January 02, 2006 3:28 PM
To: Jay Strauss
Cc: dbi-users@perl.org
Subject: Re: Fwd: Module submission DBIx::DB


> If so, for naming why does it need to be DBIx why not =
RDBMS::Schema::Blah

Well, the "RDBMS::" namespace doesn't seem to exist on CPAN yet...
Of course, neither does the "Schema::" namespace. So maybe just
"Schema::Blah"?

- Tyler

Re: Fwd: Module submission DBIx::DB

am 03.01.2006 20:52:31 von Tyler

Ted Behling wrote:
> Perhaps use Schema::RDBMS::Foo. This would allow for non-RDBMS schema
> modules, based on XML, DB files, or others.

I like it. Both "Schema" and "RDBMS" belong in the name, but for
some reason putting "Schema" first reads better. Definately much better than
DBIx::DB. Thanks you two... when I release such a package in the (hopefully
not-too-distant) future, it'll be a Schema::RDBMS::. :-)

Cheers,
Tyler


>
> -----Original Message-----
> From: Tyler MacDonald [mailto:tyler@yi.org]
> Sent: Monday, January 02, 2006 3:28 PM
> To: Jay Strauss
> Cc: dbi-users@perl.org
> Subject: Re: Fwd: Module submission DBIx::DB
>
>
> > If so, for naming why does it need to be DBIx why not RDBMS::Schema::Blah
>
> Well, the "RDBMS::" namespace doesn't seem to exist on CPAN yet...
> Of course, neither does the "Schema::" namespace. So maybe just
> "Schema::Blah"?
>
> - Tyler
>