From mboxrd@z Thu Jan  1 00:00:00 1970
Return-path: <ptxdist-bounces@pengutronix.de>
Date: Fri, 21 Feb 2020 12:41:33 +0100
From: Uwe =?iso-8859-1?Q?Kleine-K=F6nig?= <u.kleine-koenig@pengutronix.de>
Message-ID: <20200221114133.o3pm3bqoik7e47i7@pengutronix.de>
References: <20200215125205.31606-1-bruno.thomsen@gmail.com>
 <20200221072308.GB4597@pengutronix.de>
 <CAH+2xPDzysTPKfj+JEQyC3Ggg0sUcUtQSH=91H=z8Nf3gJipFg@mail.gmail.com>
MIME-Version: 1.0
Content-Disposition: inline
In-Reply-To: <CAH+2xPDzysTPKfj+JEQyC3Ggg0sUcUtQSH=91H=z8Nf3gJipFg@mail.gmail.com>
Subject: Re: [ptxdist] [PATCH] sqlite: enable foreign keys by default
List-Id: PTXdist Development Mailing List <ptxdist.pengutronix.de>
List-Unsubscribe: <http://metis.pengutronix.de/cgi-bin/mailman/options/ptxdist>, 
 <mailto:ptxdist-request@pengutronix.de?subject=unsubscribe>
List-Archive: <http://metis.pengutronix.de/cgi-bin/mailman/private/ptxdist/>
List-Post: <mailto:ptxdist@pengutronix.de>
List-Help: <mailto:ptxdist-request@pengutronix.de?subject=help>
List-Subscribe: <http://metis.pengutronix.de/cgi-bin/mailman/listinfo/ptxdist>, 
 <mailto:ptxdist-request@pengutronix.de?subject=subscribe>
Reply-To: ptxdist@pengutronix.de
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Errors-To: ptxdist-bounces@pengutronix.de
Sender: "ptxdist" <ptxdist-bounces@pengutronix.de>
To: ptxdist@pengutronix.de
Cc: Bruno Thomsen <bruno.thomsen@gmail.com>, Bruno Thomsen <bth@kamstrup.com>

On Fri, Feb 21, 2020 at 12:20:33PM +0100, Bruno Thomsen wrote:
> Hi Michael
> =

> Den fre. 21. feb. 2020 kl. 08.23 skrev Michael Olbrich
> <m.olbrich@pengutronix.de>:
> >
> > On Sat, Feb 15, 2020 at 01:52:05PM +0100, Bruno Thomsen wrote:
> > > Support for foreign_keys pragma was already enabled at
> > > compile-time, but it was not enabled by default on new
> > > database connections. It's still possible to turn off
> > > enforcement at runtime.
> > > This makes it easier to work on databases that uses
> > > this feature without causing them to end up in an
> > > invalid state.
> >
> > Hmm, what's the impact of this? What are the performance implications? =
And
> > what's the default in other distros? I mean, if the default is generally
> > off, then I don't expect any existing software to disable this.
> =

> Fedora 31 has =3D0, I don't know about other distros,
> but you can test it fast with an in-memory database.
> =

> $ sqlite3
> sqlite> pragma foreign_keys;
> 1
> sqlite> .exit

FTR: on Debian the pragma command yields 0. (Tested with sqlite3
3.31.1-2 that is currently in testing/unstable)

Best regards
Uwe

-- =

Pengutronix e.K.                           | Uwe Kleine-K=F6nig            |
Industrial Linux Solutions                 | https://www.pengutronix.de/ |

_______________________________________________
ptxdist mailing list
ptxdist@pengutronix.de