From: Matthew French (mfrench42 at domain yahoo.co.uk)
Date: Fri 19 Oct 2001 - 15:38:59 IST
On Fri, Oct 19, 2001 at 02:28:57PM +0100, Fergal Moran wrote:
> ...what I want is something that allows me to develop a database
> independent application (c++). I want to be able to swap out an SQL
> Server running on an NT box and swap in an Oracle db running on a
> Solaris box - am I kidding myself - or am I actually going to be
> able to do this?
Most probably an act of technical masochism.
If you just want to run standard "INSERT" and "SELECT" queries it is
not a problem, but the moment you start using sequences or fancy joins
in your queries it can become a nightmare.
You could use a clever abstraction layer but then you lose the power of
SQL and the performance benefits of specific platforms.
Or you could have a config file with sprintf style queries for each
type of database. (UPDATE [foo] SET 'bar'="%s")
This would give you lots of flexibility but is not very elegant.
Do You Yahoo!?
Get your free at domain yahoo.com address at http://mail.yahoo.com
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:12:50 GMT