I have been so lucky to port Oracle 4 from source to MCX Unix. It was not one of my most joyable experiences.

IMHO there is no perfect database, they all have advantages and disadvantages. Unify does not have VARCHAR (or something alike), SQLite has issues with more than single-user usage, MySQL has too many issues to mention with quotation use and non-ANSI standards as worst, Oracle is expensive and a PITA to maintain, PostgreSQL requires old versions installed when restoring backups on different servers, CSV has no type system, NoSQL databases have no SQL, MS-Server allows rediculous table and column names, Firebird has a weird API that often doesn't allow actions in /some/ cases, Sybase has lack of local tools, ODBC requires unavailable drivers, etc etc etc. And for all of that: YMMV. A good system administrator that works together with a good database administrator is a luxury that would probably prevent most of those drawbacks.

My personal choice is PostgreSQL: hands down the easiest to work with and the most predictable and compliant behavior. Additional PostgreSQL has fantastic community support.


Enjoy, Have FUN! H.Merijn

In reply to Re^6: Getting id of postgres record inserted via DBI by Tux
in thread Getting id of postgres record inserted via DBI by cormanaz

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.