SQL-Ledger is an open source web application with a large user base, lots of interesting features (multi user accounting) that uses postgres and perl. It is discussed here in (OT) Perl Open Source accounting packages?.

Unfortunately, as Ovid notes, the code has a lot of aspects that deviate from "best practices" including 

    *  Poorly written
    * Doesn't use strict
    * Extensive use of global variables
    * Has security concerns
    * Is non-portable
    * Hand-rolled template system
    * Difficult to test
    * Will be difficult to extend
    * And guess how it handles CGI data ...

[download]
So it probably isn't the best example for a web framework. However, it may be good for seeing how they set up the postgres stuff, including how they use postgres's rollback features which ensures the integrity of the general ledger by protecting against cases when updates conflict with each other. This would be impossible to do in mysql for the foreseeable future, as far as I know and is one of the main reason certain projects choose to go with the less mainstream postgres.

Sql-ledger is licensed under the GPL but it's documentation, including developer guide, are not open source and are only available for a price, which is fairly steep. I suspect the documentation packages are one of the main sources of income for the developer, along with consulting for customizations for his heavier users.

In reply to Re: PostgreSQL web application examples? by tphyahoo
in thread PostgreSQL web application examples? by halley

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.