From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>
Received: from mp12.migadu.com ([2001:41d0:306:2d92::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by ms9.migadu.com with LMTPS
	id ONpAG6e7zWSPcwEASxT56A
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Sat, 05 Aug 2023 05:01:59 +0200
Received: from aspmx1.migadu.com ([2001:41d0:306:2d92::])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	by mp12.migadu.com with LMTPS
	id mGwmG6e7zWSaYQAAauVa8A
	(envelope-from <emacs-orgmode-bounces+larch=yhetil.org@gnu.org>)
	for <larch@yhetil.org>; Sat, 05 Aug 2023 05:01:59 +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 0495F37583
	for <larch@yhetil.org>; Sat,  5 Aug 2023 05:01:59 +0200 (CEST)
Authentication-Results: aspmx1.migadu.com;
	dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20221208 header.b=RTcK7IAS;
	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";
	dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none)
ARC-Seal: i=1; s=key1; d=yhetil.org; t=1691204519; a=rsa-sha256; cv=none;
	b=h9UhfISS9/6yL3/KBvLm4SZ1G8ZGrOT8vEqa7OgOrZYxlRZVPtB2WOOWfl+cYmUNm2ZfVa
	RKYs7Q5nvVaHa3Qb0/4S4cU8i31I1PtnGv7rlTNFh9hSyyq4Y20atULX5sFnPLvcLrALjc
	BbP/pt1SRNOtRAb5DiGG4xdqLKnGxmDQElAquNWgYYVIYyEBockodW0KMxjLgPKJzNz+B9
	HuEiGz/Bd4klx3s8d8+sGDxRizZed2eG3PtZWDrg1dBJTGaI7afHh9pHeAlRBZuZuBjXA0
	HvsxVep/pHEu4HGn7jXVPtM3AtmijWsj4kud+ultRZICO15fQZ7GSedj7YlQUQ==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org;
	s=key1; t=1691204519;
	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=KxtUfzFK3fuAibPg0qHjonfut0AduZDyRTVm3rT1C2M=;
	b=ksA4JSHLFH01dW2eRz3ds8kCOZ/6st0nG+ckwBXpMrr8/BYUIUHfGceIgp6ziRelhezdCh
	NyGidvPpSJGAucGPHhbazRcYeJ1iJK+WhNHLcnbBbF1upgsfktnsZ0q0iXPwFBRlUr2myt
	kzOaQN/mCkaGu5zwzDEXc6TW5P8w+zztOVuUyUdtpLQ+FDaPDI4aqhy8S5O7aXSDK/3YzV
	H/I9Z99DZyTSma/xXpzh77I81bQ9NHMNQ031QMCc13zw/cwSRAM+QQSN2gcPUrdlJ3Stqf
	XaAMbKNHHM4nEyI0LD389zPl2VQOXPAZL3TP6L3tb469yPnOfVUy6GUxt3DtFg==
ARC-Authentication-Results: i=1;
	aspmx1.migadu.com;
	dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20221208 header.b=RTcK7IAS;
	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";
	dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none)
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 1qS7XI-0000Xb-Mx; Fri, 04 Aug 2023 23:01:00 -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 <manikulin@gmail.com>)
 id 1qS7XH-0000Rt-5O
 for emacs-orgmode@gnu.org; Fri, 04 Aug 2023 23:00:59 -0400
Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
 (Exim 4.90_1) (envelope-from <manikulin@gmail.com>)
 id 1qS7XF-0005nn-1U
 for emacs-orgmode@gnu.org; Fri, 04 Aug 2023 23:00:58 -0400
Received: by mail-lf1-x12e.google.com with SMTP id
 2adb3069b0e04-4fe58faa5cfso2213236e87.3
 for <emacs-orgmode@gnu.org>; Fri, 04 Aug 2023 20:00:56 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=gmail.com; s=20221208; t=1691204454; x=1691809254;
 h=content-transfer-encoding:in-reply-to:mail-followup-to:from
 :references:cc:to:content-language:subject:user-agent:mime-version
 :date:message-id:sender:from:to:cc:subject:date:message-id:reply-to;
 bh=KxtUfzFK3fuAibPg0qHjonfut0AduZDyRTVm3rT1C2M=;
 b=RTcK7IASceCPvKKZ3xWgWR7UrwtLiDzXj4U81HTB2VqD1ls5w5A0JBc8fyZnulXGoS
 QxZ3+VcOWamCHlkyC/k6BaxFvMzHE1c1gdhTXX4MlF19avF6IHvKSHghOAM7FcIZd4LC
 gGitROkDgsomKVlvVdHxoCaxNphcDvKfW0RmDfxQR2WPSpeeqCBQsEH75nAuw/VrocwR
 FEn2weYrT15hoglxEAtou25YNX7ccdmT1ykKMcs20DUW8oNXL8f++tPaC6oLcIqXUe3j
 4x6MU/RK10ppCCxd2f/RW7gDOYhWgq/VEnab7/qIEEylwIEN/1V954YlRzVItclq6vty
 tC/g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20221208; t=1691204454; x=1691809254;
 h=content-transfer-encoding:in-reply-to:mail-followup-to:from
 :references:cc:to:content-language:subject:user-agent:mime-version
 :date:message-id:sender:x-gm-message-state:from:to:cc:subject:date
 :message-id:reply-to;
 bh=KxtUfzFK3fuAibPg0qHjonfut0AduZDyRTVm3rT1C2M=;
 b=BQS28OLefIYLwZcS1TBYer4t39o5imrlkRu+Eya4YkkkCU+1lNM8OdpiqKjq6MUZ+9
 jR6qJIPQMTdMtXExdG7VPwOYG9k7eLjsbFoELB1rpcsw4yf7oUVBo0rfRvXrhx8zFLxd
 AGib1coGFT7sqwHp9q5raZ5Zoubs2bzhHW7ufPMYP5AQMoPkBzWgZTyS04drLMT08m1a
 9XE8mMqARQSe//rtBlW08VqvMEKKBIYu3xyi8MUM0+XIyYLq7SDboUaSY6nmWtm4IIOZ
 C56xDipXwFsiwAA55S9qBoFVWhzPVjuP7dUSozPCwUZ8kjsuet8rT5EjchLV2px4/pkZ
 wf+Q==
X-Gm-Message-State: AOJu0YxBsxP3RvKmHtdL2/x38pEiMqxYPGYFGPZcrJebXi+9a60zfgkr
 YYp7eJY52huyJGYcIawXdNo=
X-Google-Smtp-Source: AGHT+IGYc994y5g8j2wh4JKlZb2yjC1zUkORCUiYKaTREc6W/4BNWD/cP2XG+f+xlLbgEVeTUmYgsQ==
X-Received: by 2002:a05:6512:39d6:b0:4fc:6e21:ff51 with SMTP id
 k22-20020a05651239d600b004fc6e21ff51mr3028130lfu.40.1691204454319; 
 Fri, 04 Aug 2023 20:00:54 -0700 (PDT)
Received: from [192.168.0.101] (nat-0-0.nsk.sibset.net. [5.44.169.188])
 by smtp.googlemail.com with ESMTPSA id
 l2-20020ac24302000000b004fba1278e6dsm599879lfh.107.2023.08.04.20.00.53
 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
 Fri, 04 Aug 2023 20:00:53 -0700 (PDT)
Message-ID: <f9b752ae-851e-4f6d-1909-9c7bce47c562@gmail.com>
Date: Sat, 5 Aug 2023 10:00:52 +0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.13.0
Subject: Re: [PATCH] ob-sqlite: Use a transient in-memory database by default
Content-Language: en-US, ru-RU
To: =?UTF-8?Q?Rudolf_Adamkovi=c4=8d?= <salutis@me.com>
Cc: emacs-orgmode@gnu.org
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>
 <87ilbis8lx.fsf@localhost> <m2o7jofglx.fsf@me.com> <87sf8zkz6a.fsf@localhost>
 <m2y1iq8lg2.fsf@me.com>
From: Max Nikulin <manikulin@gmail.com>
Mail-Followup-To: =?UTF-8?Q?Rudolf_Adamkovi=c4=8d?= <salutis@me.com>,
 emacs-orgmode@gnu.org
In-Reply-To: <m2y1iq8lg2.fsf@me.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Received-SPF: pass client-ip=2a00:1450:4864:20::12e;
 envelope-from=manikulin@gmail.com; helo=mail-lf1-x12e.google.com
X-Spam_score_int: 11
X-Spam_score: 1.1
X-Spam_bar: +
X-Spam_report: (1.1 / 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,
 NICE_REPLY_A=-0.093, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_SBL_CSS=3.335,
 SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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-Flow: FLOW_IN
X-Migadu-Country: US
X-Migadu-Spam-Score: -0.91
X-Migadu-Scanner: mx2.migadu.com
X-Migadu-Queue-Id: 0495F37583
X-Spam-Score: -0.91
X-TUID: G2nQd66VWijz

On 05/08/2023 05:57, Rudolf Adamkovič wrote:
> +*** Make ~ob-sqlite~ use in-database by default

"use in-memory database"

> +
> +SQLite source blocks with no ~:db~ argument now execute against a
> +transient in-memory database by default.

I am unsure, but perhaps it would be more clear to say that the default 
value of the header argument has changed and it is possible to omit 
setting :db per-block or as a header argument. It should give a hint how 
to revert this change in local configuration if somebody wish it.

>  This makes Org match the
> +default behavior of the ~sqlite3~ shell and makes SQLite blocks more
> +practical out of the box.
> +

Feel free to just ignore the following. Perhaps to get *really* default 
behavior ob-sqlite should not check :db value and should not pass it to 
the command in the case of nil. As a result the command spits a warning.

Earlier I was thinking on buffer-local variables whether the warning has 
been shown to the user (to do it once), but I think it would lead to 
unreasonable complication of code with a little value for users.