Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 11/03/2016 01:45, toki wrote: On 10/03/2016 01:27, Wols Lists wrote: On top of that, an integrity layer that enforces datatypes. This isn't part of standard multi-value, What? Back when I played with Pick, one of the selling points was that one couldn't put the wrong type of data into a r

Re: Firebird doesn't support MSVC 2015

Hi David, On Wed, Mar 02, 2016 at 07:37:40PM +0100, David Ostrovsky wrote: > > The wiki states that 32-bit >build is broken, that sounds like a > >blocker as well. (Or is it just >that the wiki is outdated? > >configure.ac:5277 suggests it's up to date.) > > Yes, wiki was outdated, should be fi

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 10/03/2016 11:37, Wols Lists wrote: > And it would be nice to include an "easy to use" database with LO. a) Doesn't LibO still include the db3 compatible database engine? If so, that can be used; b) I understand the dislike of SQLite, but for non-database programmers, for most purposes, it i

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 10/03/2016 01:27, Wols Lists wrote: > On top of that, an integrity layer that enforces datatypes. This isn't part > of standard multi-value, What? Back when I played with Pick, one of the selling points was that one couldn't put the wrong type of data into a record field. Was that feature si

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

> On 10 Mar 2016, at 10:37 PM, Wols Lists wrote: > > Well, all modern Picks implement SQL access. > > And as far as I'm aware, all modern RDBMS implement some form of stored > procedure, ie have some form of internal programming language. I suspect > end users will find the Pick way of dealing

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 10/03/16 08:51, Lionel Elie Mamane wrote: >> > Pick, now generically known as MultiValue, is an n-dimensional >> > database, and can be shown to be a proper superset of relational. > Sorry to be blunt, but as long as it can be used as relational through > SQL in a way that is close to the consen

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Thu, Mar 10, 2016 at 01:27:46AM +, Wols Lists wrote: > On 09/03/16 18:06, Lionel Elie Mamane wrote: >> On Wed, Mar 09, 2016 at 06:59:08PM +0100, Lionel Elie Mamane wrote: >>> On Tue, Mar 08, 2016 at 08:44:03PM +, Wols Lists wrote: On 08/03/16 13:32, Lionel Elie Mamane wrote: >

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 09/03/16 18:06, Lionel Elie Mamane wrote: > On Wed, Mar 09, 2016 at 06:59:08PM +0100, Lionel Elie Mamane wrote: >> On Tue, Mar 08, 2016 at 08:44:03PM +, Wols Lists wrote: >>> On 08/03/16 13:32, Lionel Elie Mamane wrote: > At this point, I'd say, even more strongly than usual: the one t

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 09/03/16 17:59, Lionel Elie Mamane wrote: > On Tue, Mar 08, 2016 at 08:44:03PM +, Wols Lists wrote: >> On 08/03/16 13:32, Lionel Elie Mamane wrote: > >>> At this point, I'd say, even more strongly than usual: the one that >>> will do it will decide. Upgrading to a modern Java-based database

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Tue, Mar 08, 2016 at 08:44:03PM +, Wols Lists wrote: > On 08/03/16 13:32, Lionel Elie Mamane wrote: >> At this point, I'd say, even more strongly than usual: the one that >> will do it will decide. Upgrading to a modern Java-based database >> would maybe not be that bad after all... > Soun

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Wed, Mar 09, 2016 at 06:59:08PM +0100, Lionel Elie Mamane wrote: > On Tue, Mar 08, 2016 at 08:44:03PM +, Wols Lists wrote: >> On 08/03/16 13:32, Lionel Elie Mamane wrote: >>> At this point, I'd say, even more strongly than usual: the one that >>> will do it will decide. Upgrading to a moder

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 08/03/16 13:32, Lionel Elie Mamane wrote: > At this point, I'd say, even more strongly than usual: the one that > will do it will decide. Upgrading to a modern Java-based database > would maybe not be that bad after all... Sounds like I'd better get my finger out then! IF I can get the basics

Re: Firebird doesn't support MSVC 2015

On Sun, Mar 06, 2016 at 06:39:14PM +0100, David Ostrovsky wrote: > On Fri, 2016-03-04 at 19:59 +0100, Lionel Elie Mamane wrote: > > On Wed, Mar 02, 2016 at 08:02:39AM +0100, David Ostrovsky wrote: >>> "I tried to compile fb with MSVC2015. After fixing macro issues, >>> you'll see more errors and

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Mon, Mar 07, 2016 at 02:32:05PM +0200, Noel Grandin wrote: > On 2016/03/07 2:11 PM, Lionel Elie Mamane wrote: >> A few examples of how SQLite differs from the SQL standard (be it de facto >> or de jure standard) in quite deep, fundamental ways: >> * lack of other datatypes than "integer", "re

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Mon, 2016-03-07 at 16:11 +0100, Lionel Elie Mamane wrote: > On Tue, Mar 08, 2016 at 02:06:07AM +1100, Chris Sherlock wrote: > > Is HSQLDB out of the question? > > HSQLDB2 and H2 are good choices if we decide to stay with a Java- > based > one (which brings performance problems because of the sl

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

I understand, but the situation with Firebird seems less than ideal, at least in terms of Windows builds at any rate. Are the tests really that much slower? Obviously we are relying on having a Java installation to test out Base. Can we isolate those things that we can test on sqlite to sqlit

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Tue, Mar 08, 2016 at 02:06:07AM +1100, Chris Sherlock wrote: > Is HSQLDB out of the question? HSQLDB2 and H2 are good choices if we decide to stay with a Java-based one (which brings performance problems because of the slowness of crossing the C++-to-Java barrier). > > On 7 Mar 2016, at 11:32

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

Is HSQLDB out of the question? Chris Sent from my iPhone > On 7 Mar 2016, at 11:32 PM, Noel Grandin wrote: > > > >> On 2016/03/07 2:11 PM, Lionel Elie Mamane wrote: >> On Mon, Mar 07, 2016 at 08:23:53AM +0200, Noel Grandin wrote: >> A few examples of how SQLite differs from the SQL standard

Re: alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On 2016/03/07 2:11 PM, Lionel Elie Mamane wrote: On Mon, Mar 07, 2016 at 08:23:53AM +0200, Noel Grandin wrote: A few examples of how SQLite differs from the SQL standard (be it de facto or de jure standard) in quite deep, fundamental ways: * lack of other datatypes than "integer", "real" (fl

alternatives to Firebird: sqlite [was: Firebird doesn't support MSVC 2015]

On Mon, Mar 07, 2016 at 08:23:53AM +0200, Noel Grandin wrote: > In the space of open-source SQL database engines, SQLite is far and > away the most widely used and supported option. > Maybe we should try using that instead? A few examples of how SQLite differs from the SQL standard (be it de fac

Re: Firebird doesn't support MSVC 2015

In the space of open-source SQL database engines, SQLite is far and away the most widely used and supported option. Maybe we should try using that instead? ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/ma

Re: Firebird doesn't support MSVC 2015

Hi Lionel, On Fri, 2016-03-04 at 19:59 +0100, Lionel Elie Mamane wrote: > On Wed, Mar 02, 2016 at 08:02:39AM +0100, David Ostrovsky wrote: > > > So, after fixing number of MSVC 14.0 related bugs in FB > > module: [1], I filed this bug upstream: [2] and got there > > this comment from Egor Pugin:

Re: Firebird doesn't support MSVC 2015

On Wed, Mar 02, 2016 at 08:02:39AM +0100, David Ostrovsky wrote: > So, after fixing number of MSVC 14.0 related bugs in FB > module: [1], I filed this bug upstream: [2] and got there > this comment from Egor Pugin: > "I tried to compile fb with MSVC2015. > After fixing macro issues, you'll see m

Re: Firebird doesn't support MSVC 2015

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. The reason we wanted a new DB was to allow using Base without the Java

Re: Firebird doesn't support MSVC 2015

On 04/03/16 16:09, Andrzej Hunt wrote: > 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 ve

Re: Firebird doesn't support MSVC 2015

On 03/03/16 17:53, Jonathan Aquilina wrote: > 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 Is SQLite a relational db? In which case it's no interest to me ... :-) As for other nosql dbs,

Re: Firebird doesn't support MSVC 2015

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 This email has been sent from a virus-free computer protected by Avast. www.avast.com

Re: Firebird doesn't support MSVC 2015

On 02/03/16 12:12, Noel Grandin wrote: > > > On 2016/03/02 2:11 PM, Michael Stahl wrote: >> >> personally i'd be inclined towards alternatives that are less likely to >> trigger toolchain problems - maybe there's a SQL database implemented >> in, say, Java somewhere... >> > > Maybe even one that

Re: Firebird doesn't support MSVC 2015

On 03/02/2016 07:25 PM, Alexander Thurgood wrote: Toolchain problems on OSX with firebird too...currently not building with firebird enabled in my own master builds, as the build fails each time when I do. * "When building LibreOffice on OS X 10.11 you currently need to use at least --disable-

Re: Firebird doesn't support MSVC 2015

Alex Thurgood wrote > Le 02/03/2016 13:12, Noel Grandin a écrit : > > > Toolchain problems on OSX with firebird too...currently not building > with firebird enabled in my own master builds, as the build fails each > time when I do. > > Alternatives to an experimental feature that never got off t

Firebird doesn't support MSVC 2015

Hi Miklos, On Wed Mar 2 08:56:14 UTC 2016, Miklos Vajna wrote: >>On Wed, Mar 02, 2016 at 08:02:39AM +0100, David Ostrovsky wrote: >> I see two options: >> * Declare FB only supported on platforms, where it can be built with >> current compiler toolchain that is used and decided by this project. [

Re: Firebird doesn't support MSVC 2015

Le 02/03/2016 13:12, Noel Grandin a écrit : Toolchain problems on OSX with firebird too...currently not building with firebird enabled in my own master builds, as the build fails each time when I do. Alternatives to an experimental feature that never got off the ground, interesting, but please n

Re: Firebird doesn't support MSVC 2015

On 2016/03/02 2:11 PM, Michael Stahl wrote: personally i'd be inclined towards alternatives that are less likely to trigger toolchain problems - maybe there's a SQL database implemented in, say, Java somewhere... Maybe even one that shares a committer with LO ? http://h2database.com/html/m

Re: Firebird doesn't support MSVC 2015

On 02.03.2016 12:44, Stephan Bergmann wrote: > On 03/02/2016 12:32 PM, Michael Stahl wrote: >> i think we can do without firebird for now, it's an experimental feature >> anyway so it can be fixed at a later time when somebody gets around to it. > > Given how firebird keeps popping up as one of th

Re: Firebird doesn't support MSVC 2015

On 03/02/2016 12:32 PM, Michael Stahl wrote: i think we can do without firebird for now, it's an experimental feature anyway so it can be fixed at a later time when somebody gets around to it. Given how firebird keeps popping up as one of the worst external modules whenever you fiddle with a n

Re: Firebird doesn't support MSVC 2015

On 02.03.2016 08:02, David Ostrovsky wrote: > > So, after fixing number of MSVC 14.0 related bugs in FB > module: [1], I filed this bug upstream: [2] and got there > this comment from Egor Pugin: > > "I tried to compile fb with MSVC2015. > After fixing macro issues, you'll see more errors and mo

Re: Firebird doesn't support MSVC 2015

Hi, On Wed, Mar 02, 2016 at 08:02:39AM +0100, David Ostrovsky wrote: > I see two options: > > * Declare FB only supported on platforms, where it can be built with > current compiler toolchain that is used and decided by this project. > * Cancel MSVC 14.0 upgrade for now and wait until it's sup

Firebird doesn't support MSVC 2015

So, after fixing number of MSVC 14.0 related bugs in FB module: [1], I filed this bug upstream: [2] and got there this comment from Egor Pugin: "I tried to compile fb with MSVC2015. After fixing macro issues, you'll see more errors and more serious. The list of errors is almost endless. (Of cour