ptPerlDeveloper has asked for the wisdom of the Perl Monks concerning the following question:

Anyone know of a perl module for maintaining a database table? Ideally it would display buttons for adding, deleting, updating and searching a record.
  • Comment on perl module for maintaining a database table

Replies are listed 'Best First'.
Re: perl module for maintaining a database table
by Zaxo (Archbishop) on Jan 01, 2005 at 04:58 UTC

    The problem of maintaining and questioning a database is distinct from that of producing a GUI for the user. The two are best given seperate solutions with a bit of interface code to match them up.

    DBI is the module you want for talking to databases. It is the common interface to a whole family of specific database drivers in the DBD namespace. There are lots of helper modules for various purposes which the DBI search should turn up.

    For the GUI, it depends on what you want. For CGI, there is CGI.pm, which comes with Perl. For a desktop on a local machine, Tk is platform agnostic and in common use.

    Some assembly required.

    After Compline,
    Zaxo

Re: perl module for maintaining a database table
by xdg (Monsignor) on Jan 01, 2005 at 07:31 UTC

    If you're asking about a handy perl GUI for database table maintenance, you might check out Maypole, which is a web-based MVC framework that you can use to quickly roll your own simple web app to interact with a database.

    -xdg

    Code posted by xdg on PerlMonks is public domain. It has no warranties, express or implied. Posted code may not have been tested. Use at your own risk.

Re: perl module for maintaining a database table
by jbrugger (Parson) on Jan 01, 2005 at 10:25 UTC
    Wandering what you exactly want.... Do you want to maintain your database by some programm you want to write, or do you want a out of the box solution?
    On what OS, which database, etc?
    When it is a MySQL or PosgreSQL on a Linux machine and you want a simple out of the box solution to maintain your database, you might give webmin a try.
    else the answers above would be ok.
Re: perl module for maintaining a database table
by dimar (Curate) on Jan 01, 2005 at 13:12 UTC

    Also, you might want to see this, since you mentioned GUI buttons. As others have already mentioned, maintaining a database table and having a GUI with clickable buttons are not necessarily the same thing.