From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id IDyWJlUEQWPJYQAAbAwnHQ (envelope-from ) for ; Sat, 08 Oct 2022 07:02:13 +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 SJqhJlUEQWNDhAAA9RJhRA (envelope-from ) for ; Sat, 08 Oct 2022 07:02:13 +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 4DE50F9CA for ; Sat, 8 Oct 2022 07:02:13 +0200 (CEST) Received: from localhost ([::1]:52088 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oh1yW-00021u-1c for larch@yhetil.org; Sat, 08 Oct 2022 01:02:12 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:39420) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oh1xI-00021l-V9 for emacs-orgmode@gnu.org; Sat, 08 Oct 2022 01:00:56 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:38965) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oh1xG-0008IX-Qt for emacs-orgmode@gnu.org; Sat, 08 Oct 2022 01:00:56 -0400 Received: from localhost ([::ffff:154.225.55.149]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000BBD14.0000000063410404.000060D5; Fri, 07 Oct 2022 22:00:51 -0700 Date: Sat, 8 Oct 2022 04:05:31 +0300 From: Jean Louis To: Hendursaga Cc: Payas Relekar , emacs-orgmode@gnu.org Subject: Re: Org and Hyperbole Message-ID: Mail-Followup-To: Hendursaga , Payas Relekar , emacs-orgmode@gnu.org References: <878rlw3ws3.fsf@gmail.com> <87tu4fdty1.fsf@aol.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <87tu4fdty1.fsf@aol.com> User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -2 X-Spam_score: -0.3 X-Spam_bar: / X-Spam_report: (-0.3 / 5.0 requ) BAYES_00=-1.9, DATE_IN_PAST_03_06=1.592, SPF_HELO_PASS=-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" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1665205333; 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; bh=WzZdELO0Ye97zdQTBoDOQnRtSAn5qk1k+Z1KFrePLhA=; b=r/1w1/t0L3+C23ugPPB+R9HRlNV0Bj6msdL9JwHln4O/Nng9Acx+IKU3xkQnHpAY84SxYh 6u924dJE9mLZt6pkiwxSdl3lGBbNQYNdTCqiSjzbwWds5OaqdfNQJxiqcmN/ungskNLbC0 y/95xHKE+5gqe2PuBC0jf9fWDAboaPNf1jXLwz8dTLUkOnDgpOuI7qIUSyXYRjDhvZK2UK 2/eKQjUYx7gEAgzVvWVPi3xkiSSrrjCIyH+F8+uZyKqewxbPv7S/2Id5d6lzqLsUZvF4O2 0U/TXbYlVw+H++p8F4YYhqkjuIgJOyHboNIFQHuZwGklneSiUmDigrDioYkoWg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1665205333; a=rsa-sha256; cv=none; b=RjkLklIsaxTM4VB/eFV92lLFbfAip9v6uFcJVKgqDXD9la4JwqiB87Aj+kgQiLlTeG3572 oac8QaEYyYVCW2kL2FhA+nDap4Fi765aW+vgls0fAOdbBtqIU3ao+Ze6hYKJl/XAwUOeNn oGARDJre/UJetw68aUGjoxMnFQBt5hjl2ZU2TaH2Gku6wSuT0NAGplLSVUzGnuOvtQKVGJ mL9ddyAKcgFgLCbkdaXbkFQjjhVoD36eYQyWxI0A5v/vnLwjJICWfUxSLPKEvVHhrPYrhy Wz7GFPe/RosYiCc0AlN7pwLebtE0ARke48KHT+hO0mUhgQaCJDTY+NhfKWag4A== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=none; 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-Spam-Score: -2.98 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; 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: 4DE50F9CA X-Spam-Score: -2.98 X-Migadu-Scanner: scn0.migadu.com X-TUID: MYNOOZDrSq1x * Hendursaga [2022-10-08 03:46]: > Jean Louis writes: > > > Of course it is so much better option than keeping stuff in text. All properties shall be in the database. SQLite is not a network database, thus it disables collaboration. It is better developing with PostgresSQL or MariaDB, or other network databases. > > Vanilla SQLite, that is. There are multiple[1] SQLite[2] addons[3] around[4] that add some sort of distributed layer to it, most being zero-cost (or at least low-cost) abstractions. Pretty cool, I'd say! > > ~ Hendursaga > > [1] https://dqlite.io/ > [2] https://litestream.io/ > [3] https://github.com/losfair/mvsqlite > [4] https://github.com/rqlite/rqlite Thanks, insightful, I have reviewed links. But none tells me that it is truly network based database. Of course one may replicate files through network and send data, that is not what is meant with network database. One can make layers on top of it, but that does not make it multi user or suitable for collaboration. From: https://www.sqlite.org/whentouse.html ,---- | Many concurrent writers? → choose client/server | | If many threads and/or processes need to write the database at the | same instant (and they cannot queue up and take turns) then it is best | to select a database engine that supports that capability, which | always means a client/server database engine. | | SQLite only supports one writer at a time per database file. But in | most cases, a write transaction only takes milliseconds and so | multiple writers can simply take turns. SQLite will handle more write | concurrency than many people suspect. Nevertheless, client/server | database systems, because they have a long-running server process at | hand to coordinate access, can usually handle far more write | concurrency than SQLite ever will. `---- -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/