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

Monks,

I am looking for an example where the code can infer the database tables and some simple relationships between those tables based on a set of forms say html or xforms.

Does anyone know of any code that can do this, even if that code only handles simple cases?

Best Regards
Ty

Replies are listed 'Best First'.
Re: Infer Database Tables from Form GUI
by marto (Cardinal) on Jan 05, 2011 at 22:13 UTC

    Do you mean you want to somehow determine what a database schema looks like based on html/xforms? I don't know how that can be done, however if you have database access look at SQL::Translator which can help you visualise schemas.

    Update: s/scheme/schema/

      I have come across some abstracts on this idea on ACM but unfortunately I am not a member. I am going to try to roll my own solution
Re: Infer Database Tables from Form GUI
by gman (Friar) on Jan 05, 2011 at 22:05 UTC

    How about DBIx::Browse::CGI?

    Honestly I have not had much success with it, but I am in the procceses of working with it for a current project.