From: Rene Rivera (grafikrobot_at_[hidden])
Date: 2007-03-16 12:15:56
> Sebastian Redl wrote:
>> Rene Rivera wrote:
>>> Thorsten Ottosen wrote:
>>>> Portability is another reason to go away from sql queries
>> as strings.
>>> Since SQL is a standard language I don't see how using it
>> in strings
>>> makes it non-portable. Could you explain you reasoning?
>> Different DBs actually use different "dialects" of SQL. There
>> is a subset of SQL that can be used pretty portably, but also
>> a large amount of stuff that can't.
Sure... But we could use that same argument to propose that we write C++
programs by writing an abstraction on top of C++ compilers in Python so
that we can remove the incompatibilities in the various C++
implementations. Having had the displeasure of dealing with PL/SQL there
is one serious drawback to the language embedded approach, it ties ones
to the capabilities of the abstraction.
-- -- Grafik - Don't Assume Anything -- Redshift Software, Inc. - http://redshift-software.com -- rrivera/acm.org - grafik/redshift-software.com -- 102708583/icq - grafikrobot/aim - grafikrobot/yahoo
Boost list run by bdawes at acm.org, david.abrahams at rcn.com, gregod at cs.rpi.edu, cpdaniel at pacbell.net, john at johnmaddock.co.uk