Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: MySQL, MS SQL, PostgreSQL - Common interface

by andreas1234567 (Vicar)
on Jun 15, 2007 at 05:32 UTC ( #621400=note: print w/replies, xml ) Need Help??

in reply to MySQL, MS SQL, PostgreSQL - Common interface

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})
  • Comment on Re: MySQL, MS SQL, PostgreSQL - Common interface

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://621400]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2023-09-25 06:51 GMT
Find Nodes?
    Voting Booth?

    No recent polls found