I am sure that this
is way too broad of a question to ask here, but heck, if anyone has any thoughts
it would be helpful.
I wonder, how do you
make a truly portable sql application? You see apps out there that can run
on just about any SQL server. I have always wondered how they can do
that? I mean, I have run into so many problems just moving the simplest
things from one system to the next, from Linux to Windows, from Mysql to
Postgres, MSSQL to MySQL, whatever.
The reason I ask is
this, because when you go from Postgres to say Firebird, you have all your
column or tables names in lowercase. Now that can probably just move right
into Firebird if the datatypes are all setup right, but then all the names will
be in UPPERCASE. Now your client app has a problem, wrong
case.
So how do they do
it? Just enclose everything (all table and column names) in
double-quotes? Do all SQL servers support that?
FYI: My client app
is Zope. Which, as I write this, is occurring to me that IT may be my
problem. (Python code is case-sensitive)
I am really thinking
out loud here, so dont feel like you need to reply. But, having any
thought from you more experienced developers is always
helpful.
Thanks.
