[vos-d] Re: Re: next priorities; mySQL

[Neil Mosafi]

Surely the best approach is trying to support as many different database
servers as possible, rather than pushing a single one onto the VOS user?

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 <lalo.martins at gmail.com> 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 at interreality.org
> http://www.interreality.org/cgi-bin/mailman/listinfo/vos-d
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.interreality.org/pipermail/vos-d/attachments/20060410/f031d6e6/attachment.htm