Re: What so special about PostgreSQL and other RDBMS?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 22 May 2004 08:15:15 -0500
Message-ID: <uad00obbt.fsf@standardandpoors.com>

On 22 May 2004, quirk_at_syntac.net wrote:
> "Doug Hutcheson"
> <doug.blot.hutcheson_at_nrm.blot.qld.blot.gov.blot.au> wrote in
> message news:<QySqc.2189$IH5.98940_at_news.optus.net.au>...

[...]

>> Proposition 2: There are circumstances under which my client
>> is better protected against commercial or accidental events,
>> if I have coded my application in such a way (by use of a
>> database abstraction layer) that migrating my application to a
>> different database management system is made very easy.
>> 
>> I agree with that proposition.

>
> And also note that simply issolating database functions in your
> code is a easy and light way to abstract data access, just to
> make this clear for those that keep insisting that database
> access abstraction means automaticaly including a third tier:
>
> For instance, in pseudocode:
>
> function myapp_query(query)
> if not connected
> prop_connect
> result = prop_query(query)
> for each result
> data(ii++) = prop_fetch(result)
> if not set cleanup
> set cleanup connection callback
> prop_disconnect
> return data

Do you think the above is solid programming, ie, do you have code in your codebase with something like the myapp_query function in it?

If you do, could you post it?

-- 
Galen Boyer

Received on Sat May 22 2004 - 08:15:15 CDT