Where I work, one guy wrote a perl script that uses a data dictionary to generate sql and C code for out application. The sql that is generated by the perl script is used to create the database based on the data dictionary. This include all the indexes and things like that. Of course there is stored procedures that are made the old fashoned way. The C code is used in the C programming we do. We have a generic table API that you call this function pass it the table name and the operation and the key index (0, 1, 2 etc) and then it fills up a structure that was also generated by the perl script. All this allows us to make changes to the data dictionary then run this script and build new databases out of it. Kinda cool.

In reply to Re: Re: Are we obsessed with CGI? by Anonymous Monk
in thread Are we obsessed with CGI? by rinceWind

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.