From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: pietru@caramail.com Newsgroups: gmane.emacs.help Subject: Re: Toggle appointment notification Date: Fri, 4 Dec 2020 07:28:17 +0100 Message-ID: References: <875z5jiroy.fsf@web.de> <875z5ibigp.fsf@web.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="24845"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Michael Heerdegen , help-gnu-emacs@gnu.org To: Jean Louis Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Dec 04 07:30:33 2020 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kl4bx-0006M1-MH for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 07:30:33 +0100 Original-Received: from localhost ([::1]:54010 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kl4bw-0003zA-Fl for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 01:30:32 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:35592) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kl4aM-0003z2-CX for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 01:28:54 -0500 Original-Received: from mout.gmx.net ([212.227.17.21]:47331) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kl4aJ-0006Hv-Iv for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 01:28:54 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1607063298; bh=TMTl0tHWTutuQuYzSV4QC7tmUQSX5VLY45zUkpMZe24=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=aFn342PoGpAlMTqWiW0/pOwooVMhuw0gXl+zPbiBWkIugyugp3kRafxFg88jZ/RdA IjSV6WIedsi9Xa1dgAe296s6eFreDRaA6A4NvFkwPV2SfTy0iVH2NCPoWyeH4azmVg ySk/PldMhMe47xXELQSjULJcLm/Izs0P++tkHxMM= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Original-Received: from [213.165.168.94] ([213.165.168.94]) by web-mail.gmx.net (3c-app-mailcom-bs11.server.lan [172.19.170.179]) (via HTTP); Fri, 4 Dec 2020 07:28:17 +0100 Importance: normal Sensitivity: Normal In-Reply-To: X-UI-Message-Type: mail X-Priority: 3 X-Provags-ID: V03:K1:Ihx2m+g4BH4AZjtju/87Tw5ZBBr6ZpWdlCJRO6ujRUOjxmaVeMUiGbbc16JCf8iBagP6g epTGwUlQ4UIB3vhiXHuzitvnO/+7/SQ++Md6kxWNAqtzpTO6YhfNpcFCOGbD+LdhP+50Jg/h5J00 p0tZxLQaUPiTjfM6MgZ6+NcamSZWaKJ1wFGPfBS7FRKWD+79y3V8qOcpzcX+zLN5HsFFMyyTICz8 JYO3XVOhMQXVV14FoFkozhZ8fXdf6IZQoQtsdFyXLapYqKHN7yTTxQGNFJ9T0qLejIlaiWb5q+zL y0= X-UI-Out-Filterresults: notjunk:1;V03:K0:4mYxuAP3lQs=:Wkvp+3kwoh/Jutddzb3567 XBl1K/KinjdRuYfhz1oVYICeLh1/XWOLDZlxgoLohmfN2rhHa41y3HkiisW5jThPy6jC/CZxW aNJgNu5N1B/+qtyzNZVudfZ7mbOT0zbd5f3lD+oRllq1WQmTrOwXDTsVVSs3hgKN9IxRiBfKR TR0eGKcJAx+7aJ1g2R+32ODRyf+WtoRHSafkws0nf7/RKfegmn4pCM5LYoEfJ/p2WLD0YCqY/ 9ZzOQpxOtH7JxKeXVLCJYQjc5gtIoiI9gU6lygnv3CtdjtyWb2xUEkQ/6LlixermjU/Npo0/a HVyBJdg/SARUTztzIwPmtbZ7FL9c0JmQEgkvDgVRTqtY4tapdfpgERKjeqVPdQ7wCgI+dHIU1 rVNOSElTVkKYEeSOxguRVvzIu8f8EvYnucl1Tv14Fj1IEyW/NvUK0QdWlxz4D+AFtBkgMX8K2 c44TaPsEq02d44Slw22AnqsNswFIFdxtOPvmD7EmtPQ7GWHCXIiXanz35SlZ0j2kaOMTyicKD ufb5qxkdpAWEh5frWHKbtVrVEz+bsFxPnLz2FLrreEzzeG4nDzlFch2CNi/hNUS/O1/LkFllJ Yx55TBWLi6/Ks= Received-SPF: pass client-ip=212.227.17.21; envelope-from=pietru@caramail.com; helo=mout.gmx.net X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-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 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.io gmane.emacs.help:125957 Archived-At: > Sent: Friday, December 04, 2020 at 6:59 AM > From: "Jean Louis" > To: pietru@caramail=2Ecom > Cc: "Michael Heerdegen" , help-gnu-emacs@gnu= =2Eorg > Subject: Re: Toggle appointment notification > > Dear Pietru, >=20 > * pietru@caramail=2Ecom [2020-12-04 03:28]: > :PROPERTIES: > :CREATED: [2020-12-04 Fri 08:58] > :ID: 30c62de6-cc11-42b7-8f1b-5f23313b3a94 > :END: > >=20 > > > Sent: Friday, December 04, 2020 at 12:49 AM > > > From: "Jean Louis" > > > To: "Michael Heerdegen" > > > Cc: help-gnu-emacs@gnu=2Eorg > > > Subject: Re: Toggle appointment notification > > > > > > * Michael Heerdegen [2020-12-04 02:05]: > > > > pietru@caramail=2Ecom writes: > > > >=20 > > > > > Fair enough, but the response could easily be interpreter to be > > > > > addressed to us rather than to every emacs user=2E I understand= we > > > > > asked for points of view, but that was after Michael informed us= that > > > > > he was planning some work on diary appointments and he asked me = for > > > > > suggestions on our planned use and strategy=2E Emanuel confirme= d that > > > > > changes will became part of the official release=2E > > > >=20 > > > > I'm sorry, but there was some misunderstanding=2E I'm a user of c= alendar, > > > > diary, org and diary, and plan to donate some related stuff to Gnu > > > > Elpa=2E I dunno to what Emanuel answered=2E > > > >=20 > > > > I'm interested in making diary expressions more common and useful= =2E I > > > > want to have something better than appointments, and a better > > > > integration of these things with Org=2E But I'm not an Org develo= per=2E > > > >=20 > > > > I'm just curious about how people are currently using this stuff, = as an > > > > inspiration for the direction of development of my stuff, so that = it may > > > > end up in something useful for others=2E > > >=20 > > > {M-x appt-add} While called `appointments' it may be used for any ty= pe > > > of daily alarm or notification=2E I find warnings or alarms useful= =2E User > > > may write something and be focused and is then reminded of > > > appointment=2E Or bread being baken=2E Or child that has to be drive= n from > > > kindergarten=2E > > >=20 > > > (appt-add TIME MSG &optional WARNTIME) > > >=20 > > > Probably introduced at or before Emacs version 23=2E3=2E > > >=20 > > > Add an appointment for today at TIME with message MSG=2E > > > The time should be in either 24 hour format or am/pm format=2E > > > Optional argument WARNTIME is an integer (or string) giving the numb= er > > > of minutes before the appointment at which to start warning=2E > > > The default is =E2=80=98appt-message-warning-time=E2=80=99=2E > > >=20 > > >=20 > > > I am currently thinking same as you, how to streamline and shorten a= nd > > > make faster actions of life and education of others=2E > > >=20 > > > If you have structured data to deal with it is good to use databases= =2E > >=20 > > Ok, it could be=2E But bloody hell, you need to make an sql query=2E = And > > of course SQLight works on binary files=2E It is problematic=2E >=20 > SQL queries are pretty much human understandable queries=2E Using > database spares are lot lot of problems=2E >=20 > This function replaces org-todo-list in org-agenda=2E You may try to see > what org-todo-list is doing=2E >=20 > (defun hyperscope-all-actions () > (interactive) > (hyperscope-remember-parent) > (hyperscope-highlight) > (let* ((sql "SELECT hlinks_id FROM hlinks, hlinktypes, actionstatuses = WHERE hlinktypes_id =3D hlinks_hlinktypes AND actionstatuses_id =3D 2 AND a= ctionstatuses_id =3D hlinks_actionstatuses ORDER BY hlinks_globalpriority, = hlinks_rank DESC;") > (id-list (rcd-sql-list sql *hs*))) > (hyperscope nil nil nil nil nil id-list) > (message "Hyperdocuments list of all pending actions"))) >=20 > The main hyperscope function is about double then what you see=2E It > spares coding in human understandable way as it is already programmed, > there is no need to reinvent the wheel and integration that becomes > useful for user is just few functions away=2E >=20 > org-ql is Org query language that does useful queries for Org > users=2E It attempts to be glue to Org mode to replace SQL and does it > job of coping with text very good: >=20 > org-ql or Org query language > https://github=2Ecom/alphapapa/org-ql >=20 > > It could be made an option, but using text should be kept=2E We often > > do not have structured data=2E At times we come up with things on the > > go, and don't have people who would help if things get too technical > > when things go wrong=2E But with text you can hack things up on the > > spot and keep working=2E I could be working in a swamp, so not into > > the cosmetic stuff=2E Other people can use the fancy complex tree > > stuff=2E There are many instances where it would be an overkill=2E >=20 > When doing some text writing on the go, mobile, one has to make notes > any how, be it on the paper, on mobile device, by sending oneself SMS, > email, or by telling fellows to write it down=2E Such information is > then processed later=2E >=20 > There is nothing that I think of the database unless during the > development stage=2E Once developed functions work for years, I just > looked back and I see decades passed=2E I could as well stay working > with the old PostgreSQL version=2E Inside of a database is text=2E All > editing is text=2E Wouldn't you need some database model to build? =20 > When such simple function as above is integrated for user one only > needs key bindings=2E For my side it is '-a to see all hyperdocuments > with actions=2E If my staff member accesses the database there is > reference sheet or help screen and staff member just do ' and a to get > all hyperdocuments with actions=2E It could be as well letter "a" or > function key=2E >=20 > Minimizing the number of keys to get to the function execution is what > makes it useful for user=2E >=20 > Then we are people, people need to collaborate together=2E When using > database to store tasks those tasks become available in various other > forms=2E >=20 > - users can access tasks by using web interface or Emacs interface, > but they may use console with `fzf' tool for fuzzy searching, they > could use `dmenu' dynamic menu to find current agenda or display > what is necessary with `zenity', or Emacs without integration could > use a console script with C-u ! to insert agenda into Emacs, mobile > devices use Javascript and access information, user can use any > editor that allows remote execution and access one's one > information, insert into editor or print it out, KDE could use its > graphical user interface, Gnome could use its own and programs > become integrated together=2E >=20 > fzf - fuzzy search > https://github=2Ecom/junegunn/fzf >=20 > fzf is for console with ivy and helm are for Emacs=2E Dmenu is for X > what ivy and helm are for Emacs=2E >=20 > There is nothing too technical with SQL databases=2E Emacs Lisp is way > more technical than majority of SELECT, INSERT, UPDATE, DELETE queries > that one usually does not even think of as those are bound to some > keys or mouse click=2E >=20 > The Cherrytree software uses database, it is transparent to user which > never thinks about it=2E >=20 > Cherrytree - hierarchical note taking application with rich text and syn= tax highlighting > https://www=2Egiuspen=2Ecom/cherrytree/ >=20 > Example is this above hyperlink that I am inserting with keys / f for > filter "cherry" for query and W to insert into other window=2E WWW > hyperlinks are not structured data in Org mode and except of > activating them there are not many actions integrated for the user, > not that I know that one can share Org hyperlinks to other users in > easy manner, collaborate on such, add notes for hyperlink itself > without disturbing the heading's body, or assign various tasks to > hyperlink and relate it to user, group of people or rank the actual > number of hyperlink number of activations=2E >=20 > Org mode already handles structured data and with time it becomes more > and more with tedious coding that replaces database functions=2E 129 Org > mode files are there for review of the hard work developers did=2E >=20 > Database based Org mode may replace many of its actions with one file > or few, not 129=2E >=20 > Collaboration becomes possible as soon as networked ready databases > are involved=2E >=20 > > Could you have a look at Gnu Recutils, so we can read and write using > > rec-format=2E Quite unsure how you are trying to do things, but sound= s > > like office work to me=2E >=20 > GNU recutils is good tool and it is type of way better structured > database then what now Org structure offers=2E Actually I am surprised > that neither GDBM nor GNU recutils, nor GNU SQL similar type of query > language is not used with GNU Emacs in general as integrating with > other tools and liberating data helps with tremendous integration with > other software, other platforms, types of accesses=2E Things become > simpler and more useful, not complexer and less useful=2E The good thing about Gnu Recutils is that one can make his own database model=2E =20 =20 > https://www=2Egnu=2Eorg/software/parallel/sql=2Ehtml >=20 > Would it be used from beginning then underlying generic functions to > access data from Org mode could be today expanded to be using MySQL > and other databases with similar queries without user needing to know > about it=2E=20 >=20 > Jean >