comment on

You mean besides DBI?

The different database engines are exactly that: different. They implement basic features, such as DATE and TIME in the SQL standard differently. See this article.

Furthermore, for better concurrency, many database engines require the use of a database specific programming language: PL/SQL (Oracle), SQL PL (IBM DB2), even MySQL has this ability as of version 5.0. While there's some similarities within these languages, they are highly incompatible. So I would say what you are trying to do is very difficult.

Why is database independence so important?

--
print map{chr}unpack(q{A3}x24,q{074117115116032097110111116104101114032080101114108032104097099107101114})

In reply to Re: MySQL, MS SQL, PostgreSQL - Common interface by andreas1234567
in thread MySQL, MS SQL, PostgreSQL - Common interface by cosmicperl

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Syntactic Confectionery Delight
	PerlMonks