Re: sqlite3

[Jean Louis]

* Óscar Fuentes <ofv@wanadoo.es> [2021-12-09 09:56]:
> Daniel Fleischer <danflscr@gmail.com> writes:
> 
> > Pip Cet [2021-12-08 Wed 18:36] wrote:
> >
> >> The proposal is to have Emacs store some user data in some binary
> >> format that cannot be readily inspected, diffed, backed up,
> >> version-controlled, shared, altered, or understood. (Or archived,
> >> published, indexed, checksummed, ...)
> >
> > It's a binary file, sure, but what exactly prevents your from backing it
> > up? or putting it under git, sharing it, calculating its checksum or
> > exploring it via a free tool such as sqlite-browser?
> 
> Of course you can do all of the above, but keep in mind that adding,
> deleting or editing a row can have arbitrarily large effects on the
> binary representation of the database.
> 
> And having to install an specific tool just to "explore" the database's
> contents (read: have access within the tool's constraints) doesn't look
> like very enticing perspective to me.
> 
> So you can do with a database a lot of things we usually do with text
> files, but "readily" does not apply.

To open text file with editor such as Emacs you need complex
dependencies. On Parabola GNU/Linux-libre, they are listed as: librsvg
gpm giflib libxpm libotf m17n-lib gtk3 hicolor-icon-theme
desktop-file-utils alsa-lib gnutls jansson cairo harfbuzz

Emacs is huge software. Complex.

sqlite3 is 1.6M with these dependencies;

        linux-vdso.so.1 (0x00007ffee8782000)
        libreadline.so.8 => /usr/lib/libreadline.so.8 (0x00007f47f83f7000)
        libm.so.6 => /usr/lib/libm.so.6 (0x00007f47f82b3000)
        libdl.so.2 => /usr/lib/libdl.so.2 (0x00007f47f82ac000)
        libz.so.1 => /usr/lib/libz.so.1 (0x00007f47f8292000)
        libpthread.so.0 => /usr/lib/libpthread.so.0 (0x00007f47f8271000)
        libc.so.6 => /usr/lib/libc.so.6 (0x00007f47f80a5000)
        libncursesw.so.6 => /usr/lib/libncursesw.so.6 (0x00007f47f8030000)
        /lib64/ld-linux-x86-64.so.2 => /usr/lib64/ld-linux-x86-64.so.2 
(0x00007f47f85db000)



-- 
Jean

Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns

In support of Richard M. Stallman
https://stallmansupport.org/