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.