From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 14 Feb 2022 17:47:20 +0300 Message-ID: References: <87tufmjyai.fsf@gnus.org> <875ys2lyt0.fsf@yahoo.com> <87wnkhlxb9.fsf@yahoo.com> <2FD7D920-D92C-480B-B2AC-91A17F0397C4@mit.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="6745"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: "emacs-devel@gnu.org" , Po Lu , Stefan Monnier , Arthur Miller , "larsi@gnus.org" , John Yates To: Qiantan Hong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 16:39:10 2022 Return-path: Envelope-to: ged-emacs-devel@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 1nJdRV-0001Zn-NM for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 16:39:09 +0100 Original-Received: from localhost ([::1]:33728 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJdRU-0004ad-Jb for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 10:39:08 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:55236) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJcfc-0005on-WB for emacs-devel@gnu.org; Mon, 14 Feb 2022 09:49:41 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:49453) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJcfZ-0003wz-S5 for emacs-devel@gnu.org; Mon, 14 Feb 2022 09:49:40 -0500 Original-Received: from localhost ([::ffff:41.75.189.127]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 0000000000067F6D.00000000620A6BFF.00007AD8; Mon, 14 Feb 2022 07:49:34 -0700 Mail-Followup-To: Qiantan Hong , John Yates , Po Lu , "larsi@gnus.org" , Stefan Monnier , Arthur Miller , "emacs-devel@gnu.org" Content-Disposition: inline In-Reply-To: Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:286279 Archived-At: * Qiantan Hong [2021-12-06 17:19]: > Thanks for the paper! > I think we can safely assume we only need internal objects in > Emacs — people probably won't use Emacs to handle millions > of business record (not fit into main memory) in foreseeable future. Assumption is from your personal view point. I would not rush saying so. Though I am using dynamic module for PostgreSQL database, I am welcoming inclusion of SQLite into main Emacs for general usage and access through Emacs Lisp. I am handling 226,542 people entries through Emacs, 16134 accounts, 1544 various tags, 48 various businesses, 38892 various hyperdocuments, and I have sent 692,392 mailings to 77,983 people, and review of it and management goes in breeze. With investment of some thousands of dollars, I could easy arrive to "millions of records". And we don't speak of foreseeable future, I use database since 20 years and I have used it over web interface, which I still can do, and since years I use it through Emacs. We speak of past, not just future. As related to Dynamic Knowledge Repository, Hyperscope for Emacs, this below is my statistics of documents. Many people are involved, many people benefited already from my work through Emacs and database usage. ┌──────────────────────────────┬───────────────────────┬───────┐ │ Object │ Sub-type │ Count │ ├──────────────────────────────┼───────────────────────┼───────┤ │ Asciidoctor │ Default │ 53 │ │ Asciidoctor │ Attachment │ 2 │ │ Asciidoctor │ Agreement │ 1 │ │ Asciidoctor with PDF │ Default │ 15 │ │ Asciidoctor with PDF │ Agreement │ 7 │ │ Asciidoctor with PDF │ PDF │ 6 │ │ Asciidoctor with PDF │ Task │ 5 │ │ Asciidoctor with PDF │ Report │ 3 │ │ Asciidoctor with PDF │ Partnership Offer │ 2 │ │ Asciidoctor with PDF │ Attachment │ 2 │ │ Asciidoctor with PDF │ Quotation │ 1 │ │ Audio │ Default │ 61 │ │ Audio │ Song │ 17 │ │ Audio │ Voice │ 1 │ │ AVAILABLE │ Default │ 1 │ │ Backlink │ Default │ 249 │ │ CBR │ Default │ 1 │ │ Common Lisp │ Default │ 1 │ │ DB-ID │ Default │ 7 │ │ Directory │ Default │ 70 │ │ DISEASE │ Default │ 5 │ │ DJVU │ Default │ 25 │ │ Emacs Lisp │ Default │ 4 │ │ Emacs Lisp Hyperlink │ Default │ 74 │ │ Enriched │ Default │ 4 │ │ EPUB │ Default │ 119 │ │ EPUB │ Recipe │ 1 │ │ File │ Default │ 138 │ │ FOLLOW-UP │ Default │ 66 │ │ Gnumeric │ Spreadsheet │ 3 │ │ HTML Hyperdocument │ Default │ 24 │ │ HyperScope ID │ Default │ 13 │ │ Image │ Default │ 312 │ │ Image │ Food │ 2 │ │ Image │ Recipe │ 1 │ │ Image │ Signature │ 1 │ │ Info Node │ Default │ 1 │ │ Instruction │ Default │ 3 │ │ Instruction │ E-mail Snippet │ 1 │ │ Kotl (Hyperbole Outline) │ Default │ 1 │ │ Launch Program │ Default │ 6 │ │ Local File │ Default │ 25 │ │ Maff │ Default │ 2 │ │ Markdown │ Default │ 4015 │ │ Markdown │ Poem │ 5 │ │ Markdown (Pandoc, espresso) │ Default │ 54 │ │ Mbox │ Default │ 1 │ │ Media │ Default │ 13 │ │ Media │ Song │ 6 │ │ Meeting │ Default │ 1 │ │ Message-ID │ Default │ 8 │ │ Mobi │ Default │ 1 │ │ Mount Point │ Default │ 1 │ │ MPV play video at exact time │ Default │ 24 │ │ Note │ Default │ 6227 │ │ Note │ Report │ 68 │ │ Note │ Poem │ 25 │ │ Note │ Request for quotation │ 10 │ │ Note │ Request For Proposal │ 7 │ │ Note │ Quotation │ 6 │ │ Note │ Question │ 5 │ │ Note │ Cognition │ 4 │ │ Note │ Offer │ 4 │ │ Note │ Phone │ 3 │ │ Note │ Proposal │ 3 │ │ Note │ E-mail Snippet │ 3 │ │ Note │ Progress │ 3 │ │ Note │ Template │ 3 │ │ Note │ Warning │ 3 │ │ Note │ Partnership Offer │ 3 │ │ Note │ Dream │ 2 │ │ Note │ Online Account │ 2 │ │ Note │ Pricing │ 2 │ │ Note │ Call │ 2 │ │ Note │ Recipe │ 2 │ │ Note │ Event │ 1 │ │ Note │ PDF │ 1 │ │ Note │ Meeting │ 1 │ │ Note │ Contact Information │ 1 │ │ ODS │ Default │ 1 │ │ ODT │ Default │ 2 │ │ Opportunity │ Default │ 37 │ │ Org │ Default │ 31 │ │ Org Heading │ Default │ 2 │ │ Page in physical book │ Training │ 1 │ │ PDF │ Default │ 2589 │ │ PDF │ Book │ 7 │ │ PDF │ Quotation │ 3 │ │ PDF │ Report │ 2 │ │ PDF │ Recipe │ 1 │ │ PDF │ Agreement │ 1 │ │ PDF │ Business Profile │ 1 │ │ PDF │ PDF │ 1 │ │ PDF │ Contract │ 1 │ │ PDF by Page Nr. │ Default │ 14475 │ │ PostgreSQL │ Default │ 10 │ │ PostgreSQL │ Report │ 6 │ │ QUOTATION │ Default │ 3 │ │ Quote │ Default │ 6 │ │ Scheme │ Default │ 1 │ │ Self │ Default │ 3 │ │ Set ➾ │ Default │ 1706 │ │ Set ➾ │ Follow-up │ 2 │ │ Set ➾ │ Recipe │ 1 │ │ Shell Command │ Default │ 3 │ │ Shell Script │ Default │ 1 │ │ SUCCESS │ Default │ 1 │ │ Task │ Default │ 222 │ │ Task │ Call │ 4 │ │ Task │ Travel │ 1 │ │ Task │ Training │ 1 │ │ Task │ Practical Skill │ 1 │ │ Task │ Report │ 1 │ │ Task │ Pay │ 1 │ │ Text │ E-mail Signature │ 8 │ │ Text │ E-mail Snippet │ 6 │ │ txt2tags │ Default │ 1 │ │ URL for Image │ Default │ 25 │ │ Video │ Default │ 128 │ │ Video │ Song │ 1 │ │ WRS Unprocessed Page │ Default │ 1 │ │ WWW │ Default │ 7035 │ │ WWW │ PDF │ 78 │ │ WWW │ Recipe │ 20 │ │ WWW │ Patent │ 17 │ │ WWW │ Video │ 3 │ │ WWW │ Song │ 3 │ │ WWW │ Partnership Offer │ 1 │ │ WWW │ Task │ 1 │ │ WWW │ Article │ 1 │ │ WWW │ Drug Information │ 1 │ │ WWW │ Spreadsheet │ 1 │ │ Xournalpp │ Default │ 3 │ │ YouTube Video │ Default │ 231 │ │ YouTube Video │ Recipe │ 1 │ │ YouTube Video at exact time │ Default │ 61 │ └──────────────────────────────┴───────────────────────┴───────┘ -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/