U++ forum: Welcome to the forum

A list of SQL dialects to support (eventually).. [message #4452]

Wed, 09 August 2006 13:26

mirek
Messages: 14261
Registered: November 2005

Ultimate Member

As I have made important breakthrough in "sql dialect problem", I have become interested in the real number of SQL dialects we should support.

So far, my list goes like

enum {
ORACLE, 1,
SQLITE, 2,
MYSQL, 4,
MSSQL, 8,
POSTGRESS, 16,
FIREBIRD, 32,
};

Are there any other important RDBMS engines to support?

As for "breakthrough" - I have found a nice way how to keep dialect stored in Session object and keep SqlExp in the SIMPLE "universal" form, performing the final "compilation" for specific
target dialect. (Note that important word here is SIMPLE - I knew how to do that the hard way before - SqlExp producing intermediate language that get compiled to final SQL commands - but that one would involve too much code).

The trick is to simply store all variants in SqlExp String together with some very simple if/else/endif codes (in the char range 1..31). Sounds stupid and simple, but took me 2 years to invent Wink

(Even more fun is that the resulting code is shorter than the currect braindead dialect handling).

Mirek

Report message to a moderator