From: Jean Louis <bugs@gnu.support>
To: Andrew Hyatt <ahyatt@gmail.com>
Cc: Eli Zaretskii <eliz@gnu.org>, 59346@debbugs.gnu.org
Subject: bug#59346: Adding sqlite-backup
Date: Sat, 19 Nov 2022 08:29:58 +0300 [thread overview]
Message-ID: <Y3hp1imYPpgs22yk@protected.localdomain> (raw)
In-Reply-To: <CAM6wYYKbTJ=c=HZ1tbtHDSr7aA++ByRO6hHuBCwn5BcVa3Bq2A@mail.gmail.com>
* Andrew Hyatt <ahyatt@gmail.com> [2022-11-19 05:07]:
> But if you are interested in furthering the conversation, which has a lot
> to do with what I'm talking about in my upcoming (and already recorded)
> Emacs conference talk, I don't think the distinction you are making between
> files and databases is important. Let's say I wanted to store, use and
> otherwise manipulate contact information with emacs. Right now that sort
> of thing happens with a file with emacs-readable lists inside, but it's
> really more natural to do it with a database. The fact that it's done via
> a file now seems historical, especially now that we have sqlite. I expect
> that sqlite will be used for this sort of thing more often. However, if
> there's no database option, then maybe not, since it won't be seen as
> reliable as the filesystem. I don't think it is reasonable to expect users
> to figure out how to do this, even if the info is easy to find. I'd like
> us to be able to encourage the use of sqlite for data, and give the user a
> good experience when sqlite is the backend.
I totally agree on that.
I have already made SQLite version of CRM for Emacs by using SQLite,
but it is not polished for public, it will be soon.
Backing up database which does not run on the file system is
trivial. That often needs human interaction.
Though there are use cases when programs run continuously without
human interaction and where there are too many changes to the database
that one cannot just control by human.
Thus program itself should be able to reliably backup the database
while it is running without human supervision.
There are programs like sending of mailing list, sending thousands of
SMS messages, and such programs may run autonomously over days. That
is how my programs are designed. They may accept the sales lead and
re-check if any new person has subscribed, then dispatch e-mail and
SMS to that person.
Having reliable backup functions thus is necessary and useful in those
cases of running programs.
--
Jean
Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns
In support of Richard M. Stallman
https://stallmansupport.org/
next prev parent reply other threads:[~2022-11-19 5:29 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2022-11-18 2:40 bug#59346: Adding sqlite-backup Andrew Hyatt
2022-11-18 7:46 ` Eli Zaretskii
2022-11-18 12:05 ` Andrew Hyatt
2022-11-18 12:17 ` Eli Zaretskii
2022-11-19 2:05 ` Andrew Hyatt
2022-11-19 5:29 ` Jean Louis [this message]
2022-11-19 5:17 ` Jean Louis
2022-11-19 7:52 ` Eli Zaretskii
2022-11-19 13:36 ` Andrew Hyatt
2022-11-19 13:51 ` Eli Zaretskii
2022-11-19 8:07 ` Stefan Kangas
2022-11-19 5:03 ` Jean Louis
2022-11-19 4:52 ` Jean Louis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=Y3hp1imYPpgs22yk@protected.localdomain \
--to=bugs@gnu.support \
--cc=59346@debbugs.gnu.org \
--cc=ahyatt@gmail.com \
--cc=eliz@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.