[Opensim-users] opensim migration strategy

[Dr Scofield]

Generic Email wrote:
> This is a bit of a soap box, so if your are easily offended or annoyed,
> just pass by, there is nothing to see here.
> 
> I see in the OpenSim world the assertion that SQLite is not production
> worthy often. Most recently here:
> 
>> http://opensimulator.org/wiki/Upgrading
> SQLite (default - a lightweight database that comes bundled with OpenSim
> and can be used without requiring any extra configuration. It is mostly
> intended to get you up and running quickly, not for production use.)
> 
> I prefer to describe SQLite as: 
> SQLite is a software library that implements
> a self-contained, serverless, zero-configuration, transactional SQL
> database engine. SQLite is the most widely deployed SQL database engine
> in the world. The source code for SQLite is in the public domain.
> 
> These companies believe SQLite is production
> worthy/ready: http://www.sqlite.org/famous.html
> 
> I am a huge fan of SQLite, and for what it does, I believe it does it
> very well.
> 
> Thanks for letting me get that out, and I hope I can influence more of
> you to take a better look at SQLite.

i think the comment about production worthy might actually be context dependent:
if your production is one or two regions, then SQlite is probably production
worthy. if we are talking about more regions, lots of assets, lots of scripts
creating assets we've found that MySQL is actually more efficient and, thus,
production worthy with respect to that context.

	cheers,
	dirk

-- 
dr dirk husemann ---- virtual worlds research ---- ibm zurich research lab
SL: dr scofield ---- drscofield at xyzzyxyzzy.net ---- http://xyzzyxyzzy.net/
RL: hud at zurich.ibm.com - +41 44 724 8573 - http://www.zurich.ibm.com/~hud/