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:4a6f::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by ms9.migadu.com with LMTPS
	id 2HtrCYa7VmT5OwAASxT56A
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Sat, 06 May 2023 22:41:42 +0200
Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by mp11.migadu.com with LMTPS
	id 8O9XCYa7VmRbsgAA9RJhRA
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Sat, 06 May 2023 22:41:42 +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 BA2E7D7D9
	for <larch@yhetil.org>; Sat,  6 May 2023 22:41:41 +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 1pvOi6-0006Q4-CR; Sat, 06 May 2023 16:40:54 -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 <salutis@me.com>) id 1pvOi4-0006Pw-9L
 for emacs-orgmode@gnu.org; Sat, 06 May 2023 16:40:52 -0400
Received: from mr85p00im-zteg06011501.me.com ([17.58.23.182])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <salutis@me.com>) id 1pvOi1-00086k-4o
 for emacs-orgmode@gnu.org; Sat, 06 May 2023 16:40:51 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=me.com; s=1a1hai;
 t=1683405646; bh=boUXaIjlKv58RaQAPENDwN4oR635moydZJkBD4IKnqE=;
 h=From:To:Subject:Date:Message-ID:MIME-Version:Content-Type;
 b=1NxfNR95fJV2AIVGv+IGeTMqm+2iIrE4R1ipG3G508n5POIzIyPGFnU/9gB27cD8Y
 a9QJdFYO7UIAdzZ1Q49h4XQCfSxeEUuOfWn5aMef/2PiGsLlETJVFpAb5Org3vP8nF
 rj/KwtruvH4fn3IiJ0sPHGyFop4coRbLQJwdXxbyQEFAM8Uv5yN9Bi3sg+091n9sSe
 vNJMFXWio6KpG8qYySUS5ypM1ZjPxBI4jGUjLCAGiFMEZioCvaqT2dqAzLMp29nDqU
 1HjfCeZAqNDw7nJ7I6EVspk9A5do7ZbsZ3ONyZGu24jND6N7XR7LmL2mKYxwFPwGla
 5+7zosDCZU/2A==
Received: from Rudolfs-MacBook-Air.local (mr38p00im-dlb-asmtp-mailmevip.me.com
 [17.57.152.18])
 by mr85p00im-zteg06011501.me.com (Postfix) with ESMTPSA id 245024803D9;
 Sat,  6 May 2023 20:40:44 +0000 (UTC)
From: Rudolf =?utf-8?Q?Adamkovi=C4=8D?= <salutis@me.com>
To: 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: <u2u2ag$mfm$1@ciao.gmane.io>
References: <20230503125903.95063-1-salutis@me.com>
 <u2ttkr$12t$1@ciao.gmane.io> <u2u2ag$mfm$1@ciao.gmane.io>
Date: Sat, 06 May 2023 22:40:42 +0200
Message-ID: <m2fs89i46t.fsf@me.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Proofpoint-GUID: QYFk9TvEMnMZvFYKse3UE5SgQLmKArc5
X-Proofpoint-ORIG-GUID: QYFk9TvEMnMZvFYKse3UE5SgQLmKArc5
X-Proofpoint-Virus-Version: =?UTF-8?Q?vendor=3Dfsecure_engine=3D1.1.170-22c6f66c430a71ce266a39bfe25bc?=
 =?UTF-8?Q?2903e8d5c8f:6.0.425,18.0.572,17.0.605.474.0000000_definitions?=
 =?UTF-8?Q?=3D2022-01-14=5F01:2022-01-14=5F01,2020-02-14=5F11,2020-01-23?=
 =?UTF-8?Q?=5F02_signatures=3D0?=
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxscore=0
 mlxlogscore=828 bulkscore=0
 clxscore=1015 spamscore=0 phishscore=0 adultscore=0 malwarescore=0
 suspectscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2212070000 definitions=main-2305060162
Received-SPF: pass client-ip=17.58.23.182; envelope-from=salutis@me.com;
 helo=mr85p00im-zteg06011501.me.com
X-Spam_score_int: -27
X-Spam_score: -2.8
X-Spam_bar: --
X-Spam_report: (-2.8 / 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, FREEMAIL_FROM=0.001,
 RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-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-Seal: i=1; s=key1; d=yhetil.org; t=1683405701; a=rsa-sha256; cv=none;
	b=hCBQtnjvWF0ZmEv1vTMYhRmvlZnb52Yczu/FtqYKfRrCHF/P8q8BM273qI+irC92inkFHc
	T5FcoFxMlyqc9m7M/PiWJte9geQyZu5nVgj7pkRQwvofJNq/5c9qIILSlkHfbzI180K6TR
	NGbW0FjWfS52mflhzKSx+dsWRprxlM66griIODSeRbLtMUZNZG9uB0heICN8bRlaAiIFih
	nOT63GPqpoIgPhikUenzYi3YzPBeQIGoIjB2a81IfVNrhhiMPzRHGe3skZB+jnssaHeGpT
	uYF6OKNPTzu4PPMj0C19Z0NNwELsFIaxWDoTa1rKEAS0Bnp+/hx9v8FzQxVkGg==
ARC-Authentication-Results: i=1;
	aspmx1.migadu.com;
	dkim=pass header.d=me.com header.s=1a1hai header.b=1NxfNR95;
	dmarc=pass (policy=quarantine) header.from=me.com;
	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-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org;
	s=key1; t=1683405701;
	h=from:from:sender:sender:reply-to:subject:subject:date:date:
	 message-id:message-id:to:to: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=boUXaIjlKv58RaQAPENDwN4oR635moydZJkBD4IKnqE=;
	b=BOf9Q44RYKStC8Yl1abjI7SwPb+Npl3HLyt5z1oZBqyv1OAxIjMh7IKG9kyFJSvQ7fG8H6
	WJ/aBxtNLRa2nZ1ajCCt6e2zyNGVxxuD/L0y+Oda0tGpBW99I5Q7AiSwJnNngA6KzNYcrR
	4Eyzc1exEpngVy7XereSppeLXnuwMy4jTh1sqgs6UKTYRWa+lo8udnRcyjDThDjVKmE/0s
	TZ8YRTTuY9XDBvGZPdHVOliwOGpHk+zCr81siuyL3+eMAvCEjxtq5BXebiu+97OdIXCjM9
	KtR0epeqHGfaoCw4w2o25iyOqxyv0VC02ITFP5sdzvP82wG/rlQCPKVRXe/RvQ==
X-Migadu-Spam-Score: -8.50
X-Spam-Score: -8.50
X-Migadu-Queue-Id: BA2E7D7D9
X-Migadu-Scanner: scn0.migadu.com
Authentication-Results: aspmx1.migadu.com;
	dkim=pass header.d=me.com header.s=1a1hai header.b=1NxfNR95;
	dmarc=pass (policy=quarantine) header.from=me.com;
	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-TUID: LdeKlsWp9xFt

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.]

Org is primarily about INTERACTIVE use, not batch processing, so I think
it would make sense to match the usefulness of the official INTERACTIVE
SQLite shell, which defaults to in-memory for good reasons.

Rudy
--=20
"Thinking is a momentary dismissal of irrelevancies."
-- Richard Buckminster Fuller, 1969

Rudolf Adamkovi=C4=8D <salutis@me.com> [he/him]
Studenohorsk=C3=A1 25
84103 Bratislava
Slovakia