On 13/12/10 14:17, Alexander Thurgood wrote: >> I've seen a couple of things about sqlite *2* that implies it's not a >> > particularly friendly database. 3 may well be an improvement. But >> > anyways, once we've got sqlite in place I'm then going to try and write >> > an engine for LO. That'll be a job-and-a-half! :-) > You might to try and trawl around in the OOo dba-dev mailing lists as to > why it was decided at the time not to use SQLite. Check out Frank > Schönheit's or Ocke Janssen's comments. I seem to recall it had > something to do with not SQLite not lending itself easily to being able > to keep everything in memory and then write an IO stream into and ODF > compatible container. Of course, that was back in the days of SQLite 2 > so maybe things have got better :-) Good luck !!! Can we put a hsqldb database in an odf container? The stuff I saw about sqlite 2 was things like "you can't modify a table". It's a very basic engine without a lot of the user-friendly padding.
Anyways, in the first instance, I'm treating this as a "teach yourself C++" exercise - rather a "jump in the deep end" version :-) And as for the other bits - ummm ... - are you serious!?!? :-) I wouldn't even DREAM of attempting to keep a database in RAM! But then, maybe that's because I'm used to a serious database that kicks seven bells out of relational! I heard a war story about a year or two ago about a company not far from me (200 miles north). Oracle consultants spent SIX MONTHS trying to get their twin Xeon 800 machine to go faster than the machine it was replacing. What was it replacing? A PENTIUM NINETY! And most people who know the other database, on hearing this sort of story, just smile and say "yeah, that sounds about right :-)". I'm quite happy to try and stick my database files in a odf container, but seriously, I think that is a triumph of ideology over reality. It'd actually be dead easy to dump to XML, but I think the load and save times would kill any user-friendliness, even if the database itself was cuddly-lamb-friendly. Cheers, Wol _______________________________________________ LibreOffice mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice
