epilys @epilys@chaos.social

meli, a new mail client for the terminal - pre-alpha release
https://meli.delivery/posts/2019-06-15-pre-alpha.html

Discussion on lobste.rs https://lobste.rs/s/fqcpxq/meli_new_mail_client_for_terminal_pre

Dog's pavlovian response is stunning: there was a thunderstorm this week, he's not afraid of it but I gave him treats every time it thundered just in case. Today my gf started playing recorded thunder sounds and he came to me for treats immediately.

#dog #dogs

IRC channel for #meli mail client moved to #OFTC from Freenode

portable sqlite file document database update: wrote a virtual filesystem with FUSE in Rust using [0] and I can now view each file BLOB as a regular file. Next step is metadata queries using a subdirectory pattern, for example if mount point is ~/docs, ~/docs/tags/"Bills"/date/"2020" will run an sql query for entries having ("tag", "Bills") and ("date", "2020") metadata

[0] https://crates.io/crates/fuser

#rust #sql #sqlite

Here's the code if anyone's interested https://gist.github.com/epilys/4df67027dc5db661969b086bac56385f #python3 #python #plot #matplotlib

Made a treemap with matplotlib to show storage sizes and used the hatch patterns instead of colors. They turned out nice

#python #matplotlib #sql #sqlite

https://matplotlib.org/stable/gallery/shapes_and_collections/hatch_style_reference.html#sphx-glr-gallery-shapes-and-collections-hatch-style-reference-py

Mood

Procrastinating by downloading e-books from https://standardebooks.org/ and plotting their tags with #D3

Procrastinating by writing an #SQL tokenizer/html formatter with only #python3 stdlib

#python

One of them is not like the others... #dog

Writing "plugins" is as easy as loading the database and querying. You could do a bibtex export for a paper. You could query a public API for tag suggestions.

Loading a huge bunch of sizeable pdfs into BLOB columns doesn't seem to bother sqlite3 much, if all you need is the occasional metadata search and less frequently, full BLOB read.

Having all your pdfs in a single, portable file seems extremely useful, without even considering the full text and tagging capabilities #sqlite3

Minimal html (no js) interface to the minimal document database with sqlite3

#sqlite #django #python