For #projects today: sqlite-diffable

I really like keeping data in a git repository. This turns out to work great for anything less than a GB or so, and it's by far the quickest way I've found to get a version history of how data changes over time

Since I also like storing data in SQLite, I built an experimental little tool to dump a SQLite database out in an easy-to-diff format (even easier than a SQL dump itself), ready to commit to git:

github.com/simonw/sqlite-diffa…

GitHub - simonw/sqlite-diffable: Tools for dumping/loading a SQLite database to diffable directory structure

Tools for dumping/loading a SQLite database to diffable directory structure - GitHub - simonw/sqlite-diffable: Tools for dumping/loading a SQLite database to diffable directory structure

^GitHub

This is an old project, but by some miracle it's still working and I woke up this morning wanting to celebrate the things I love more.

This Inkplate e-ink screen shows Conway's Game of Life, seeded from tarpits I have on the Internet. The tarpits are programs on my computer that superficially look like insecure Telnet and Remote Desktop services, but actually exist to respond super slowly and make bots scanning the Internet 'get stuck'.

When a bot connects to the tarpit, the data it sends gets squished into a 5x5 grid and 'stamped' onto a Game of Life board. Data from a bot at the IP address 1.1.x.x will get stamped on the top left corner, data from a bot at 254.254.x.x will get stamped on the bottom right corner.

Conway's Game of Life, a set of simple rules that govern whether cells should turn on or off, updates the display once per second. The result is that bot attacks end up appearing as distinct 'creatures', that get bigger and more angry looking over time (as their centre is updated with new data). After the attack finishes, the 'creature' eventually burns itself out.

Despite that description, it's a really chill piece of art that doesn't draw too much attention but I can happily watch for a long time.

Credit for the idea goes to @_mattata, I had been wanting to make a real-life version of XKCD #350 for years before seeing his Botnet Fishbowl project.

#projects #inkplate #esp32 #eink #infosec #tarpit

Current active projects:

- MoeNavigator: A web browser written from scratch (including its engine): codeberg.org/moenavigator/moen…

- Open system compact cassette: Creating new hardware and software for compact cassette drives: codeberg.org/ncc1988/open-syst…

- „Galaxie - Die Abenteuer vom Planeten Zeria“: A written science fiction series (in German): der.moe/galaxie/

#projects #webbrowser #compactcassette #sciencefiction

moenavigator

MoeNavigator is an attempt to write a web browser that is highly configurable, secure, anonymous and fast.

^Codeberg.org