From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: 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 ) for ; 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 ) for ; 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 ; 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 ) 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 ) 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 ) 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 ; 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: 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?= Cc: emacs-orgmode@gnu.org References: <20230503125903.95063-1-salutis@me.com> <87a5x3wum8.fsf@localhost> <87ilbis8lx.fsf@localhost> <87sf8zkz6a.fsf@localhost> From: Max Nikulin Mail-Followup-To: =?UTF-8?Q?Rudolf_Adamkovi=c4=8d?= , emacs-orgmode@gnu.org In-Reply-To: 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." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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.