To that extent, does anyone know of a flexible C++ data access library which can be configured to talk to many different databases? I am talking not only MySql, Postgres etc but also commercial ones like Oracle and Microsoft SQL Server (or MS SQL Express, which is free)?
On 10/04/06, Lalo Martins <[EMAIL PROTECTED]> wrote:
On Sun, 09 Apr 2006 18:55:29 -0400, Reed Hedges wrote:
>> my personal goal for .24 would be refurbishing the sqlpersist machinery. I
>> just don't trust mysql at all ;-)
>
> What do you mean, you don't trust it?
>
> What about PostgreSQL then?
I know MySQL is now a complete proper database system, with ACID and all.
But up to just a few months ago, it was just a place to dump your data
that happened to (mostly) respond to SQL queries. It gained so much
popularity because it was fast; but anyone who really cared
about this database stuff knew that it was faster because it was
incomplete. Like, well, DOS is faster than WinXP.
And even now, at least last time I looked, the "completeness"
(ACID compliance and whatever else) is optional... the default
setup is just as bad (and fast) as it was in the bad old days.
The Free Software / Open Source world can do better. Where you
need ACID compliance, safety, robustness, and flexibility, go
with PostgreSQL, it's a much better database. Where you need
speed and don't care much about the other stuff, sqlite simply
humiliates MySQL.
As for the "trust"... most admins will go for the "fast" setup,
or even not touch the defaults. Then something bad happens to
the data, and it's our fault. Sigh.
best,
Lalo Martins
--
So many of our dreams at first seem impossible,
then they seem improbable, and then, when we
summon the will, they soon become inevitable.
--
personal: http://www.laranja.org/
technical: http://lalo.revisioncontrol.net/
GNU: never give up freedom http://www.gnu.org/
_______________________________________________
vos-d mailing list
vos-d@interreality.org
http://www.interreality.org/cgi-bin/mailman/listinfo/vos-d
_______________________________________________ vos-d mailing list vos-d@interreality.org http://www.interreality.org/cgi-bin/mailman/listinfo/vos-d
