in reply to Database Web interface

Does anyone have any experience on how to go about this?
Sure. Its not that hard, you grab yourself a CGI::Application, HTML::Template (or some such), maybe CGI::FormBuilder, maybe Data::FormValidator and you hammer it out.
(p.s. another problem is that i use oracle & can never get Maypole to work with it).
Got Class::DBI::Oracle installed? The wiki has info on common pitfalls

MJD says "you can't just make shit up and expect the computer to know what you mean, retardo!"
I run a Win32 PPM repository for perl 5.6.x and 5.8.x -- I take requests (README).
** The third rule of perl club is a statement of fact: pod is sexy.

Replies are listed 'Best First'.
Re^2: Database Web interface
by monkey_boy (Priest) on Sep 30, 2004 at 10:32 UTC
    Cheers for the speedy responce,
    One of my main problems with Maypole (apart from not not been able to get it working), is that i dont think you should have to set up your DB Class' twice.
    (i.e. once for your Scripting API & again for the Web interface, surly this is the point of abstraction?
    Anyway, ill look into those modules, Cheers!
    P.S.
    Got Class::DBI::Oracle installed?
    Yes, but the problem seems to be with the lack of Class::DBI::Loader::Oracle

    I should really do something about this apathy ... but i just cant be bothered
[reply]

      In general, you shouldn't need to set up your classes for Class::DBI and Maypole more than once. Class::DBI::Loader should read your database configuration out of the DB, or you should manually tell Class::DBI what to do. Maypole can be coaxed to avoid Class::DBI::Loader and then you can give it your existing Class::DBI setup.

      Of course you will still have to declare which tables are to be shown to the user, but that needs to be done anyway. Maybe you can fix that with some namespace walking magic, if you aren't using Class::DBI::Loader and want to export all classes/tables directly.

[reply]
        Again, thanks for the quick response,

        or you should manually tell Class::DBI what to do

        Can you point me to any examples of this?
        Is there a BeerDB example that im missing!

        Cheers!
        I should really do something about this apathy ... but i just cant be bothered
[reply]

In Section Seekers of Perl Wisdom