Simon Willison’s Weblog

wddbfs – Mount a sqlite database as a filesystem. Ingenious hack from Adam Obeng. Install this Python tool and run it against a SQLite database:

wddbfs --anonymous --db-path path/to/content.db

Then tell the macOS Finder to connect to Go -> Connect to Server -> http://127.0.0.1:8080/ (connect as guest) - connecting via WebDAV.

/Volumes/127.0.0.1/content.db will now be a folder full of CSV, TSV, JSON and JSONL files - one of each format for every table.

This means you can open data from SQLite directly in any application that supports that format, and you can even run CLI commands such as grep, ripgrep or jq directly against the data!

Adam used WebDAV because "Despite how clunky it is, this seems to be the best way to implement a filesystem given that getting FUSE support is not straightforward". What a neat trick.

# 18th February 2024, 3:31 am / sqlite, webdav, python, jq

Subversion WebDAV Autoversioning. Set up a WebDAV share that automatically versions any file saved to it. I had no idea Subversion could do this out of the box.

# 23rd November 2007, 11:50 pm / subversion, webdav, autoversioning, svn, version-control, vcs

Goliath. WebDAV client for OS X with SSL support.

# 24th February 2004, 9:57 pm / macosx, webdav