DEV Community

Hercules Lemke Merscher
Hercules Lemke Merscher

Posted on • Originally published at bitmaybewise.substack.com

ABEND dump #13

Welcome to one more issue of the ABEND dump, where I share interesting stuff I’ve been exposed to lately.

Without further ado:


sq.io

This is an excellent command-line tool to augment shell scripts with database data.

Your database is your limit. 😆


Fast route parsing in Rails

And @tenderlove delivers an amazing talk again!

I wish I had his skills in delivering deep technical topics in a so entertaining and funny way. Even if you’re not into Ruby and Ruby On Rails, the content applies to any programming language:

35% Faster Than The Filesystem

Did you know that SQLite could be faster than the file system in certain scenarios?

SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or write().

Furthermore, a single SQLite database holding 10-kilobyte blobs uses about 20% less disk space than storing the blobs in individual files.

The performance difference arises (we believe) because when working from an SQLite database, the open() and close() system calls are invoked only once, whereas open() and close() are invoked once for each blob when using blobs stored in individual files. It appears that the overhead of calling open() and close() is greater than the overhead of using the database. The size reduction arises from the fact that individual files are padded out to the next multiple of the filesystem block size, whereas the blobs are packed more tightly into an SQLite database.

Funny tweet

I’m still laughing at this one XD

If you hold a Linux shell close to your ear, you can hear the C.

When you realize that ASCII table influenced vi/vim keymaps 😮

ASCII and vi


Thanks for reading the ABEND dump! If you are a vi user, consider sharing :D

If you liked this post, consider subscribing to my newsletter, Bit Maybe Wise.

You can also follow me on Twitter, Mastodon, and BlueSky.

Top comments (0)