SQLite Forum

Hot backup database in WAL mode by coping
I guess their idea was to pipe the copy into a compression tool right away.

I am wondering though, if using a specific  filesystem is a possibility, could that be achieved with something like ZFS (a COW filesystem)? Where the copying process is fast and the resulting file is using minimal desk space in reality?