X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3571AD1B56E for ; Thu, 1 Jul 2004 15:11:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75739-10 for ; Thu, 1 Jul 2004 18:11:05 +0000 (GMT) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by svr1.postgresql.org (Postfix) with ESMTP id 4297DD1B531 for ; Thu, 1 Jul 2004 15:11:02 -0300 (ADT) Received: from 1stbyte.com (c-24-19-142-96.client.comcast.net[24.19.142.96]) by comcast.net (rwcrmhc13) with ESMTP id <200407011811020150079vf9e>; Thu, 1 Jul 2004 18:11:03 +0000 Subject: How to make a portable application? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C45F96.CB6DD330" Date: Thu, 1 Jul 2004 11:11:13 -0700 Message-ID: Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to make a portable application? thread-index: AcRflsse6OnxkSf9SZ6gkyfnenuYww== From: "Bob Hobart" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/9 X-Sequence-Number: 18261 This is a multi-part message in MIME format. ------_=_NextPart_001_01C45F96.CB6DD330 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 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. =20 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. =20 So how do they do it? Just enclose everything (all table and column names) in double-quotes? Do all SQL servers support that? =20 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) =20 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. =20 Thanks. ------_=_NextPart_001_01C45F96.CB6DD330 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am sure= that this=20 is way too broad of a question to ask here, but heck, if anyone has any tho= ughts=20 it would be helpful.

I wonder,= how do you=20 make a truly portable sql application? You see apps out there that ca= n run=20 on just about any SQL server. I have always wondered how they can do= =20 that? I mean, I have run into so many problems just moving the simple= st=20 things from one system to the next, from Linux to Windows, from Mysql to=20 Postgres, MSSQL to MySQL, whatever.

The reaso= n I ask is=20 this, because when you go from Postgres to say Firebird, you have all your= =20 column or tables names in lowercase. Now that can probably just move = right=20 into Firebird if the datatypes are all setup right, but then all the names = will=20 be in UPPERCASE. Now your client app has a problem, wrong=20 case.

So how do= they do=20 it? Just enclose everything (all table and column names) in=20 double-quotes? Do all SQL servers support that?

FYI: My c= lient app=20 is Zope. Which, as I write this, is occurring to me that IT may be my= =20 problem. (Python code is case-sensitive)

I am real= ly thinking=20 out loud here, so dont feel like you need to reply. But, having any= =20 thought from you more experienced developers is always=20 helpful.

Thanks.

------_=_NextPart_001_01C45F96.CB6DD330--