From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>
Received: from mp10.migadu.com ([2001:41d0:2:4a6f::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by ms9.migadu.com with LMTPS
	id kFXqEXqFkWQHRgEASxT56A
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Tue, 20 Jun 2023 12:54:50 +0200
Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by mp10.migadu.com with LMTPS
	id yML/EHqFkWQ/GQAAG6o9tA
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Tue, 20 Jun 2023 12:54:50 +0200
Received: from lists.gnu.org (lists.gnu.org [209.51.188.17])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by aspmx1.migadu.com (Postfix) with ESMTPS id E34832DE18
	for <larch@yhetil.org>; Tue, 20 Jun 2023 12:54:49 +0200 (CEST)
Received: from localhost ([::1] helo=lists1p.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.90_1)
	(envelope-from <emacs-orgmode-bounces@gnu.org>)
	id 1qBYzp-0005wv-Eo; Tue, 20 Jun 2023 06:54:01 -0400
Received: from eggs.gnu.org ([2001:470:142:3::10])
 by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <yantar92@posteo.net>)
 id 1qBYzo-0005wU-2j
 for emacs-orgmode@gnu.org; Tue, 20 Jun 2023 06:54:00 -0400
Received: from mout01.posteo.de ([185.67.36.65])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <yantar92@posteo.net>)
 id 1qBYzl-0007ye-TE
 for emacs-orgmode@gnu.org; Tue, 20 Jun 2023 06:53:59 -0400
Received: from submission (posteo.de [185.67.36.169]) 
 by mout01.posteo.de (Postfix) with ESMTPS id A3C6C240027
 for <emacs-orgmode@gnu.org>; Tue, 20 Jun 2023 12:53:55 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017;
 t=1687258435; bh=jNtBuAQ5jH9V13z0XHAuiQlXSpIgVaygemI/zyKIm1I=;
 h=From:To:Cc:Subject:Date:Message-ID:MIME-Version:
 Content-Transfer-Encoding:From;
 b=jf59hXPllrVmH1IZn3b50B90Yz1NUE9Mbdjw00U5L5c5HVBlNgvEIrBo1hI6iC8QR
 6UbzPkxLxtJKiIAIy0WwNXvXSKKSoZbAVN0IxIIPxGkP3r8glihJpKtokABx19v3Yr
 3+DWViqP3F95oujNu6s/5wj7A8CJfyowzHsZIzO5ozuSo2rtWI6j2OOIVGuXaXI6tF
 w+MoamSg54rUG+BDrP4oARbYVimdD7mCHoCZl+sLXBTRw+7hlhiCxEH53LJl+4C+9Z
 ZSPYA600g28JIJKhGjRhHy41JNTzE9wKM8wZaNpSpgv4sYVhNoECb9IhSGSxSQaMMo
 2tV+CTfPQXoyg==
Received: from customer (localhost [127.0.0.1])
 by submission (posteo.de) with ESMTPSA id 4Qlk5Z6FK8z9rxD;
 Tue, 20 Jun 2023 12:53:54 +0200 (CEST)
From: Ihor Radchenko <yantar92@posteo.net>
To: Rudolf =?utf-8?Q?Adamkovi=C4=8D?= <salutis@me.com>
Cc: Max Nikulin <manikulin@gmail.com>, emacs-orgmode@gnu.org
Subject: Re: [PATCH] ob-sqlite: Use a transient in-memory database by default
In-Reply-To: <m2ilbjhbdt.fsf@me.com>
References: <20230503125903.95063-1-salutis@me.com>
 <u2ttkr$12t$1@ciao.gmane.io> <u2u2ag$mfm$1@ciao.gmane.io>
 <m2fs89i46t.fsf@me.com> <87a5x3wum8.fsf@localhost> <m2ilbjhbdt.fsf@me.com>
Date: Tue, 20 Jun 2023 10:58:50 +0000
Message-ID: <87ilbis8lx.fsf@localhost>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Received-SPF: pass client-ip=185.67.36.65; envelope-from=yantar92@posteo.net;
 helo=mout01.posteo.de
X-Spam_score_int: -43
X-Spam_score: -4.4
X-Spam_bar: ----
X-Spam_report: (-4.4 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1,
 DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1,
 RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H5=0.001, RCVD_IN_MSPIKE_WL=0.001,
 SPF_HELO_NONE=0.001, SPF_PASS=-0.001,
 T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no
X-Spam_action: no action
X-BeenThere: emacs-orgmode@gnu.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <https://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org
Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org
X-Migadu-Country: US
X-Migadu-Flow: FLOW_IN
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org;
	s=key1; t=1687258490;
	h=from:from:sender:sender:reply-to:subject:subject:date:date:
	 message-id:message-id:to:to:cc:cc:mime-version:mime-version:
	 content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding:
	 in-reply-to:in-reply-to:references:references:list-id:list-help:
	 list-unsubscribe:list-subscribe:list-post:dkim-signature;
	bh=/YZea70x3jD1h+/XEoyy7Tu7unVZGAGVWMw5oaFunl0=;
	b=nCNEiK4Uq3MxemO2IhYvODWZ6nXQ3wAUpxpqihVn4hZst/g3ociKzPxqfXQUJwTJgkAfN0
	ahDRiYsqcaWAI8CjJulHSv/IjuXJCXq4x/sKEnO3D6w7n8sVseobgIHTdi0Tq91F2S87xX
	thqgzRYbL8OM3YWghmw0JEqNRD8uHo0fjMmMj4ZUf4e0hU50Wdc71qTwLnzlC+tpeBF41z
	fPGR4sTop2KRwF49Q49BhFwYjpArG9SMr2V8qQzsinoa+DsOGBb65ZkO/sSPBlEBBduDam
	HAiZSwgznIq7CugNTIffJeci7ep/0vfW1+NVwwlORL8YalnyGTcRGQaMKMjVqA==
ARC-Authentication-Results: i=1;
	aspmx1.migadu.com;
	dkim=pass header.d=posteo.net header.s=2017 header.b=jf59hXPl;
	dmarc=pass (policy=none) header.from=posteo.net;
	spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"
ARC-Seal: i=1; s=key1; d=yhetil.org; t=1687258490; a=rsa-sha256; cv=none;
	b=hT/rQYl8FwoU1ICso4+2+pvQbi4La3GEHT6JN5LBp2GwssTJtKkh7M7hu77ySkiHhJOrSn
	iNntXSgOf6eq33v+3jl2ndb+IlhhyQPxyrLqgGuJK1feN82nZHdlV0snshXiopwR1g2fh2
	hVetKag5p1Jei7N0pgVol3OykxqLCvohmlMxnLhkPjlXiVCzSoC3ciD41erLOt6NCTozba
	56jAJ0GAlsnGidop0EUBXApkNfXmI78UEWVdJObAl+dc/vL9Rn0YhwmwwRcl0JMRCpEr+U
	4jkLW2nOXRNKHAS3dPenb6Th4SlMJsNQkqPyumkOUoi5LX6bi6QGKx4d5PZ+3w==
X-Migadu-Scanner: scn1.migadu.com
X-Migadu-Spam-Score: -4.71
Authentication-Results: aspmx1.migadu.com;
	dkim=pass header.d=posteo.net header.s=2017 header.b=jf59hXPl;
	dmarc=pass (policy=none) header.from=posteo.net;
	spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"
X-Migadu-Queue-Id: E34832DE18
X-Spam-Score: -4.71
X-TUID: qIkEUEfMBFaD

Rudolf Adamkovi=C4=8D <salutis@me.com> writes:

> I am not a fan of making the use of in-memory databases into a "smell",
> as per Org Lint, because it would communicate to the user that "this is
> a potential issue that you should probably fix".  I think that is not
> true, given that SQLite defaults to in-memory for interactive use. It is
> common and useful.  Showing a warning has the same problem.

As Max described, it might be a potential issue.
The safest way is when the user sets :db ":memory:"
org-babel-default-header-args:sqlite explicitly. We should not throw a
warning if :db ":memory:" is set by the user.

> Now, showing a message, such as "Using in-memory database", could do,
> but it would feel like spam.  The SQLite shell prints "Connected to a
> transient in-memory database" exactly once, not on every (re-)query.
> Perhaps there is a precedent somewhere in Org Babel, and we could do
> something similar?

Effectively, ob-sqlite starts a new SQLite shell for every src blocks
(sessions are not supported).

--=20
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>