From: Bob Hobart <bhobart@1stbyte.com>
To: pgsql-sql@postgresql.org
Subject: How to make a portable application?
Date: Thu, 1 Jul 2004 11:11:13 -0700
Message-ID: <AF4512A05BA7554E8CEB829F795DCEC120DD@dib.1stByte.local> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bhobart@1stbyte.com
Subject: Re: How to make a portable application?
In-Reply-To: <AF4512A05BA7554E8CEB829F795DCEC120DD@dib.1stByte.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox