This is both a Perl question and a SQL question:

I'm working on a big web database system (CGI-perl and PostgreSQL and MySQL for the curious), and I now need to tackle relationship management. Ultimately, I'd like a similar user interface to that used in Access or Filemaker - basically, the user will go in and define what primary key of one table is a foreign key in another table, and the back end will take all that information, and use it in constucting the SQL statements, both for data output as well as for data input (i.e. the right options will appear in menus and checkboxes, etc. from another table for data input.)

It's a big job, and in the interest of not re-inventing the wheel, does anyone have examples of doing this for web-based dbs? How was it accomplished? Any appropriate modules I should be looking at? If people have tried it - perils and pitfalls?

Thanks!!

.Michelle

In reply to Relationship management by michellem

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.