A faster way to copy SQLite databases between computers

Re:A faster way to copy SQLite databases between computers by creatonez on Thursday May 01, 2025 @02:57PM (#43861919)

From Linux kernel documentation:

https://man7.org/linux/man-pages/man2/ioctl_ficlone.2.html

> Clones are atomic with regards to concurrent writes, so no locks need to be taken to obtain a consistent cloned copy.

I'm not aware of any of the filesystems that use it (Btrfs, XFS, Bcachefs, ZFS) that deviate from expected atomic behavior, at least with single files being the atom in question for `FICLONE` operation.

[ Parent | on HN ]

Re:A faster way to copy SQLite databases between computers by vlovich123 on Thursday May 01, 2025 @04:11PM (#43862809)

Thanks! I similarly thought that a file clone would work but I couldn't confirm it.

[ Parent | on HN ]