TigerFS: A Filesystem Backed by PostgreSQL

TigerFS is a filesystem backed by PostgreSQL, built by the Timescale team. It mounts a database as a local directory via FUSE on Linux and NFS on macOS. Every file is a real row. Every directory is a table. Writes are transactions. Multiple processes and machines can read and write concurrently with full ACID guarantees. There are two distinct ways to use it. # Install (Linux requires fuse3; macOS needs no extra dependencies) curl -fsSL https://install.tigerfs.io | sh # Mount any PostgreSQL database tigerfs mount postgres://localhost/mydb /mnt/db Mode 1: Data-First Mount any existing PostgreSQL database and explore it with standard UNIX tools. Every path resolves to optimized SQL that gets pushed down to the database. Exploring ls /mnt/db/ # list tables ls /mnt/db/users/ # list rows by primary key cat /mnt/db/users/123.json # read a row as JSON cat /mnt/db/users/123/email.txt # read a single column cat /mnt/db/users/.by/email/alice@example.com.json # lookup by indexed column Modifying