<html><head></head><body>Having spent some more time using SQLite recent I don't think it would be a bad choice for the default embedded DB. Yes it lacks type checking, but it's well tested, seems to be easier to build, and is much more widely used.<br> <br> The reason we wanted a new DB was to allow using Base without the Java dependency, i.e. to allow more people to try Base easily. The reason we went for firebird instead of SQLite was the lack of type checking/dynamic type system that SQLite has. In hindsight I feel like this isn't actually a huge issue for the average user who probably just wants to build something simple in Base. (A bunch of well known of real life applications rely on SQLite without issues.)<br> <br> Note: if someone is truly concerned about the underlying database I suspect they should be running their own external DB, which lets them choose from a large number of DBs (I'm not a base expert though, don't quote me on this...). All we're doing here is setting the default DB when you create a .odb work an embedded DB.<br> <br> One issue that would need investigating is forwards compatibility - which I discovered potentially doesn't exist between eg SQLite 3.8 and 3.6. So maybe this isn't actually a good solution either, unless we'd stick to one version of SQLite across LO versions.<br> <br> - Andrzej<br><br><div class="gmail_quote">On 3 March 2016 09:53:40 GMT-08:00, Jonathan Aquilina <eagles051387@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> <div dir="ltr">Instead of reinventing the wheel why not look at SQLite or there is a nosql db couchdb as well but not sure how easy that would be to integrate with LO<br /></div><div id="DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top:1px solid #aaabb6"><tbody><tr><td style="width:470px;padding-top:20px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">This email has been sent from a virus-free computer protected by Avast. <br /><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a> </td></tr></tbody></table><a href="#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><div class="gmail_extra"><br clear="all" /><div><div class="gmail_signature">Jonathan Aquilina</div></div> <br /><div class="gmail_quote">On Thu, Mar 3, 2016 at 6:50 PM, Wols Lists <span dir="ltr"><<a href="mailto:antlists@youngman.org.uk" target="_blank">antlists@youngman.org.uk</a>></span> wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 02/03/16 12:12, Noel Grandin wrote:<br /> ><br /> ><br /> > On 2016/03/02 2:11 PM, Michael Stahl wrote:<br /> >><br /> >> personally i'd be inclined towards alternatives that are less likely to<br /> >> trigger toolchain problems - maybe there's a SQL database implemented<br /> >> in, say, Java somewhere...<br /> >><br /> ><br /> > Maybe even one that shares a committer with LO ?<br /> ><br /> :-)<br /> <br /> Sounds like I ought to get my finger out :-)<br /> <br /> I want to write a NoSQL database (a Pick derivative) and the plan is to<br /> do it and make it part of LibreOffice. Problem is, as a carer, I find it<br /> very hard to get the time available to concentrate, and I also don't<br /> have all the skills I need.<br /> <br /> Anyways, I will try and have a crack at it - life seems to be getting a<br /> bit easier at the moment - and see where it takes us.<br /> <br /> For those who know me, I am very much anti relational practice - imho<br /> it's impossible to write an efficient truly relational database - the<br /> theory has technical flaws that seriously impact any FNF engine.<br /> Basically, that (in contravention of Einstein's dictum) the engine is<br /> *too* *simple*, which means that any applications *must* be *overly*<br /> *complex*. I'll wax lyrical if you like but you'd be wise not to get me<br /> started :-)<br /> <br /> My main problem is that a Pick database is actually a complete operating<br /> environment. Fundamental to its operation is its language, called<br /> DATABASIC, and while I could probably write the database engine without<br /> too much difficulty, writing the language compiler is a step too far at<br /> the moment.<br /> <br /> Anyways, here's to having a go - if anyone's mad enough to join me, great!<br /> <br /> Cheers,<br /> Wol<br /> _______________________________________________<br /> LibreOffice mailing list<br /> <a href="mailto:LibreOffice@lists.freedesktop.org">LibreOffice@lists.freedesktop.org</a><br /> <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br /> </blockquote></div><br /></div> <p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />LibreOffice mailing list<br />LibreOffice@lists.freedesktop.org<br /><a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br /></pre></blockquote></div></body></html>