SPUG: Re: SPUG@cpan.org and projects
wwg at tscnet.com
wwg at tscnet.com
Wed Jul 19 11:28:03 CDT 2000
Hello, all --
I've been lurking for the better part of a year,
although I did post one response to a Linux-related
question a while back. My name's Bill Graham, and I am
currently primarily a Java developer in my day job, but
use Perl for many things, and have personal projects
Anyway, I have a project that I'd be willing to move
under the SPUG at cpan auspices, if anyone's interested.
It's a Perl/TK database browser/query tool using DBI.
In its current form, once you connect to the database,
you are presented with a tree view of tables, which you
can expand to view columns by clicking on the table. If
you select columns from one or more tables, you can
click a "Generate Query" button, and a SELECT statement
is created in the query window for all table.columns you
highlighted (you then have to specify the join and any
other filter criteria - possible future enhancement is
to examine foreign keys to try to determine the most
likely join ...). The query can then be executed &
results displayed, etc. If you have multiple sql
statements in the query window, you can highlight any
one of them and execute only that statement. Finally,
I'm working on a routine to create a default data entry
form based on specifying a table name (similar to the
table wizard in Access, but simpler / not as slick).
Currently, that piece can retrieve all the column names
and construct a form with column name labels and text
entry fields for each. The code to
query/update/insert/delete/navigate in the form isn't
there yet ...
I've used it with MySQL and Oracle8i, both on Linux. I
haven't worked on it much in the last couple of months
due to job time constraints. Anyone interested??
360 Powered Corp.
This mail sent through Sinclair's WebMail
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
POST TO: spug-list at pm.org PROBLEMS: owner-spug-list at pm.org
Subscriptions; Email to majordomo at pm.org: ACTION LIST EMAIL
Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
For full traffic, use spug-list for LIST ; otherwise use spug-list-digest
Seattle Perl Users Group (SPUG) Home Page: http://www.halcyon.com/spug/
More information about the spug-list