From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>
Received: from mp11.migadu.com ([2001:41d0:2:bcc0::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by ms9.migadu.com with LMTPS
	id IASBMjjHiGSn1wAASxT56A
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Tue, 13 Jun 2023 21:44:56 +0200
Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by mp11.migadu.com with LMTPS
	id UMd0MjjHiGR0aQAA9RJhRA
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Tue, 13 Jun 2023 21:44:56 +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 AA59A39843
	for <larch@yhetil.org>; Tue, 13 Jun 2023 21:44:56 +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 1q90jh-0007Ld-6Y; Tue, 13 Jun 2023 05:54:49 -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 1q90jf-0007LB-8a
 for emacs-orgmode@gnu.org; Tue, 13 Jun 2023 05:54:47 -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 1q90jW-000800-2q
 for emacs-orgmode@gnu.org; Tue, 13 Jun 2023 05:54:47 -0400
Received: from submission (posteo.de [185.67.36.169]) 
 by mout01.posteo.de (Postfix) with ESMTPS id 321B2240028
 for <emacs-orgmode@gnu.org>; Tue, 13 Jun 2023 11:54:34 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017;
 t=1686650074; bh=lDwcNWUmkPU8sNMD1/yQYE50v5T+NZZHRNU3KzBBFFU=;
 h=From:To:Cc:Subject:Date:Message-ID:MIME-Version:
 Content-Transfer-Encoding:From;
 b=kj4j1/rtEYuho985QWwbvie11n0xqlYbsUxa1/j5ZZs8dgA/BK7IbXR5HDiAsRlTK
 UMzCON3a4/zF+QSyvESn4u5QX7YVZsVvo9uReAtVBznCNI9+iS4jKOCfcfwKSHAr4J
 qfwYCz/l6dpDmqyJ9fJJBmLXD7PBCHda/wOHWkGvQhn6HcDcm0RVUOJ29eZtJJ9jAC
 ro1bWriRhI36zYSwJKzHvsa5Tks1RlSSschbIKp3fD4YiE6ZzfDhKpN3uC6knTOLlw
 dSgERVzkPJXpcVvLgNId9vt51ySSJtxr++BmtenYH+uldM/ZpVVNgMT96OZtVllWTm
 jdGOCBCaAPanA==
Received: from customer (localhost [127.0.0.1])
 by submission (posteo.de) with ESMTPSA id 4QgP6K1Vz8z9rxh;
 Tue, 13 Jun 2023 11:54:32 +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: <m2fs89i46t.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>
Date: Tue, 13 Jun 2023 09:59:27 +0000
Message-ID: <87a5x3wum8.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=1686685496;
	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=lDwcNWUmkPU8sNMD1/yQYE50v5T+NZZHRNU3KzBBFFU=;
	b=KbGP0cPGzuOkWhDRuYDbTO8VINFXSBFhRPABonIQb+J+V9ypPzOpsgDtfqR7YSpmL3DdgS
	sUPPhlSuZlEYkpYmjzqGz40zOiP7nFs/UoK4L+jyXgfhO1G46GGpewtlCYC4rLMOumf2bh
	Tw1I+V7DN7JANgiSJKTv9vzs6ROUPidIGtl6kCAKofOWS4/N+CgMDEdzL168kEZwIVEQ5b
	0SUv2N8WZLw7Lmj0iE/Degk8HWtsPjfZWaixeWlITo6do9WqTUHtL3RsCNfOWtQanzVOt9
	oRBoro5H6p9XsL+npAh48U6qa8CHut7ejLVU+2N4TCDL9ATE4GBWuBFZAUFMkg==
ARC-Authentication-Results: i=1;
	aspmx1.migadu.com;
	dkim=pass header.d=posteo.net header.s=2017 header.b="kj4j1/rt";
	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=1686685496; a=rsa-sha256; cv=none;
	b=u9NxTPxUIlZXyvacx4Blw4nFt08rJB+4gqalSr9bwtVhayg3vMO7aHjDB+n1xFXrPrgrJf
	n/wkDruzN+mvScno/yomxnku5vEuqHgL7ejbeDlsPSWiC8ptNqVFY5Q8P+uZ5vC1aQ5AG5
	xyB+cHX/dPHjXLrXRbBJUQ8QkyUMeipLgTbUB/YqYGR2pXVd7LW2IsIANgfVFgefZDFizb
	dCEg/bRWe91rydHDe5UPS8JNS5jrK/vCu9k58HPB2W7HXwYoGee4mSgpAKbliX7rqF29TF
	9IT8u3aqYhYIdYRXyU8MTSxuKDDCjwscmZ1iDJbx5BcBBC6ZiD2jxeZmDEUUFA==
X-Migadu-Scanner: scn1.migadu.com
X-Migadu-Spam-Score: -6.19
Authentication-Results: aspmx1.migadu.com;
	dkim=pass header.d=posteo.net header.s=2017 header.b="kj4j1/rt";
	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: AA59A39843
X-Spam-Score: -6.19
X-TUID: 39zWDf2GBBcg

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

> Max Nikulin <manikulin@gmail.com> writes:
>
>> Perhaps it is better to keep current behavior with error by default
>> and just to recommend [...] a user is experimenting with sqlite
>> features.
>
> This is exactly the case where the user SHOULD use
>
> #+PROPERTY: header-args:sqlite :db <FILE>
>
> to avoid mistyping <FILE> across their SQLite blocks.
>
> [Hence, defaulting to ":memory:" would NOT hurt.]

I do not mind falling back to ":memory:" when :db is not specified, but
we should display a warning to notify the users. Maybe not as a warning
every time src block is executed, but at least via org-lint.

Rudolf, WDYT?

--=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>