2006-08-23 01:22:58.020684+02 by Dan Lyke 1 comments
I'm whipping together a little tool to make managing some SQL data easier, and one of the things I want it to do is to automatically create tables and table rows if they don't already exist.
Anyone know a DBI/Perl-ish way to query table information for MySQL, PostgreSQL and SQLite? So I'm far holding table information in a secondary table, but I'm not happy with that solution.
[ related topics: Perl Open Source Databases ]
comments in descending chronological order (reverse):
#Comment Re: [Entry #9208] SQL query made: 2006-08-23 02:01:02.585965+02 by: Unknown, from NNTP
Dan Lyke <danlyke@flutterby.com> writes:
> Anyone know a DBI/Perl-ish way to query table information for MySQL, > PostgreSQL and SQLite?
DBIx::Class::Schema::Loader will automatically generate DBIx::Class::Schema constructs for you by interrogating your database schema on the fly. (And then those DBIx::Class::Schema classes in turn give you full-blown ORM functionality, which is a Really Nice Thing.) Supports the RDBMSen you mention; in CPAN.
We will not edit your comments. However, we may delete your comments, or cause them to be hidden behind another link, if we feel they detract from the conversation. Commercial plugs are fine, if they are relevant to the conversation, and if you don't try to pretend to be a consumer. Annoying endorsements will be deleted if you're lucky, if you're not a whole bunch of people smarter and more articulate than you will ridicule you, and we will leave such ridicule in place.
Flutterby™ is a trademark claimed by
Dan Lyke for the web publications at www.flutterby.com and www.flutterby.net.