Flutterby™! : SQL query 2006-08-22 23:22:58.020684+00

SQL query

2006-08-22 23:22:58.020684+00 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 ascending chronological order (reverse):

#Comment Re: [Entry #9208] SQL query made: 2006-08-23 00:01:02.585965+00 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.

Comment policy

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.

Connectivity provided by highertech.net , awesome bandwidth, well away from fault lines and other potential for natural disasters, reliable, and run by cool people.