[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: sqlite3
|
From: |
Jean Louis |
|
Subject: |
Re: sqlite3 |
|
Date: |
Mon, 14 Feb 2022 17:47:20 +0300 |
|
User-agent: |
Mutt/2.2.0 (2022-02-12) |
* Qiantan Hong <qhong@mit.edu> [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/
- Re: sqlite3, (continued)
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3, Jean Louis, 2022/02/14
- Re: sqlite3,
Jean Louis <=
- Re: sqlite3, Jean Louis, 2022/02/14