[Opensim-users] opensim migration strategy

[Generic Email]

Yup, that was a mis-paste.

http://opensimulator.org/wiki/Configuration

I think the key to you statement is "multi-user". SQLite has no  
concept of user account, but supports multiple access. It the current  
configuration, no 2 users access the database. One user, the front end  
application may have multiple access, but never 2 users.

Anyway, you are right that it is limited in size, only supporting  
terabyte size databases and gigabyte size strings and blobs ( http://www.sqlite.org/features.html 
  ) , but I put to you that these limitations may not be draw backs  
for most opensim admins.

Thanks so much for the twit link, I really enjoyed listening to it!

On Dec 5, 2008, at 11:48 AM, Justin Clark-Casey wrote:

> 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.)
>
> Dear Generic,
>
> I'm a little confused - that text doesn't appear anywhere on that  
> wiki page, and never has.  I guess you're probably
> referring to some other page.
>
>>
>> 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.
>
> That's true, although it's best suited to some needs and not  
> others.  In particular, I suspect that multi-user access
> with large data sets is not one of its targets.
>
> As far as I recall, the creator of SQLite himself pretty much said  
> this on one of Leo Laporte's FLOSS podcasts.
>
> http://twit.tv/floss26
>
>>
>> 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.
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20081205/60eda0f1/attachment.html>