If you want to be really database-independent, then think about this:

First:

• SQL is currently not database independent
• parsing SQL is too hard
• means you have to build on top of that

Second:

• it is very easy to solve your problem for each specific database engine
• it is very hard to solve it in general

Therefore:

• design an API (a bunch of functions) that does the tasks you need
• build a simple interpreter function that calls these functions (an "apply()" for your API)
• then you can simply re-implement these functions for each new database engine (which is trivial for a single engine)
• and add a handler for the engine to a table of database engine handlers
• make the interpreter take a reference to the appropriate engine

I used this approach for a lot of database-handling tasks from CGI scripts to online-database-coupling-interfaces, and it scales very well.

Specifically, I believe that anything relying on somehow working with "standardized" SQL is doomed from the beginning. The different SQL dialects are simply to different to achieve this.

If you want to be database independent, you will need an abstraction layer above the database level - and this means no particular database engine features may surface at this layer of abstraction.

Just my 2 cent ...

Christian Lemburg
Brainbench MVP for Perl
http://www.brainbench.com

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&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.