For serious uses, absolutely I wouldn't recommend SQLite, but put yourselves in the mind of the end user - or even someone wanting to just get up and running with minimum of fuss. Why should I install a database server platform on my machine? It'll be running on startup, eating my resources, it's an extra "thing" I don't want to care about - I just want to try OpenSim. SQLite is a wonderful quick and simple introduction and it means you can easily carry an OpenSim install on a memory stick with minimum fuss.
I would be gutted if SQLite was ditched because no-one cared to update it - I'm already committed to maintaining MSSQL, which I'll happily do, but SQLite needs love too. I have very little time to spare, would love a volunteer to step forward and help out on keeping it alive... I appreciate the point that shipping broken code as part of an application is a terrible idea - only encouraging people to get frustrated and angry that their application doesn't work. But some features need to be fixed, not just ditched - I vote that this is one of them. Chris -----Original Message----- From: opensim-dev-boun...@lists.berlios.de [mailto:opensim-dev-boun...@lists.berlios.de] On Behalf Of d...@metaverseink.com Sent: 05 January 2010 3:58 PM To: opensim-dev@lists.berlios.de Subject: Re: [Opensim-dev] User services refactoring status I'm neutral about keeping support for SQLite in core. For me, it's all a matter of someone taking the lead on maintaining it. Honestly, I agree with Justin, and that's the reason why I'm not doing that maintenance work myself. Having a no-installation OpenSim is very nice just to make it work and to have a feel for what OpenSim can do, but I think that the particular implementation of that concept -- with SQLite -- is quite deceiving. No one in his/her right mind would use SQLite as the DB for serious uses of OpenSim, just like no one uses it as the backend to web applications (there are always exceptions to every rule, of course!). As such, starting off with SQLite, liking OpenSim, and then discovering that one needs to migrate the data from SQLite to another DB system is not situation that we should induce people into. In order to implement the no-installation concept, which is a good concept, I'd much rather have an in-memory DB layer with no persistence at all. All data would disappear once the sim shuts down. That way it would be very clear to everyone that if they want persistence they need to think and research about which database system works for them. In some rare cases, people may come to the conclusion that SQLite is what works best for them. Those people should take the lead on maintaining the SQLite OpenSim connector. Justin Clark-Casey wrote: > Daniel Smith wrote: >> As a developer of other things, but a user of OpenSim, I would say 'keep >> sqlite'. >> >> Keep the barriers to entry as low as possible. If someone wants to try out >> OpenSim, make it easy for them. Put your end-user hat on for a moment. > > I would usually make the same argument and this was why I did feel a preference keeping sqlite. > > However, on reflection, I'm not sure whether it actually helps that much. OpenSim is always going > to be somewhat complicated to set up and run so the added necessity to install a database as well > doesn't seem too onerous to me. Mysql is a pretty simple install on all platforms. > > We also quite often seem to get situations where someone has started off with sqlite and later > realizes that they need to convert everything to mysql in order to grow. This can be an awkward > process. In addition, we already have a situation where some things are not implemented in sqlite > (afaik, attachment persistence still isn't implemented there). It might be better if we don't make > the end-user suffer these issues. > > Anyway, as Diva said, all this really depends on people stepping up to make the necessary code > changes for sqlite. If people do then it will remain in the codebase. If nobody does then I think > that we may be better off removing it for now. > >> cheers, >> >> Daniel >> >> On Mon, Jan 4, 2010 at 11:57 AM, Robert Martin <robertl...@gmail.com >> <mailto:robertl...@gmail.com>> wrote: >> >> Just adding my thoughts given that XAMP is very easy to setup (heck it >> would be simple to just have a pre-setup XAMP module as an add-on >> download) sqlite is not really needed. >> >> side question i have a diva install where the DB crashed midway during >> the first migration stage do i need to dump the tables and start >> over?? >> >> >> -- >> Robert L Martin >> _______________________________________________ >> Opensim-dev mailing list >> Opensim-dev@lists.berlios.de <mailto:Opensim-dev@lists.berlios.de> >> https://lists.berlios.de/mailman/listinfo/opensim-dev >> >> >> >> >> -- >> Daniel Smith - Sonoma County, California >> http://daniel.org/resume >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Opensim-dev mailing list >> Opensim-dev@lists.berlios.de >> https://lists.berlios.de/mailman/listinfo/opensim-dev > > _______________________________________________ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.120/2587 - Release Date: 01/04/10 19:35:00 _______________________________________________ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev