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.
- Matthew
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
