Home » Developing U++ » U++ Developers corner » A list of SQL dialects to support (eventually)..
| A list of SQL dialects to support (eventually).. [message #4452] |
Wed, 09 August 2006 13:26  |
 |
mirek
Messages: 14255
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  (Even more fun is that the resulting code is shorter than the currect braindead dialect handling).
Mirek
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: A list of SQL dialects to support (eventually).. [message #4504 is a reply to message #4502] |
Sat, 12 August 2006 16:32  |
|
|
| luzr wrote on Sat, 12 August 2006 09:19 |
| unodgs wrote on Sat, 12 August 2006 08:41 |
I think IMB DB2 should be on the list..
|
Yes.
Do you by any chance know how IBM DB2 interface looks like?
Mirek
|
You mean native API? DB2 use CLI which is almost the same like ODBC interface. But it has OLEDB drivers too.
SQL dialect is SQL-92 if I remeber correctly with some enchacements.
|
|
|
|
Goto Forum:
Current Time: Mon Apr 28 16:40:46 CEST 2025
Total time taken to generate the page: 0.00643 seconds
|
Members
Pages
Help
Register
Login
Home
