Re: [Libreoffice] Base - sqlite - licence grief

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