A faster way to copy SQLite databases between computers

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

I was trying to find evidence that reflink copies are atomic and could not and LLMs seem to think they are not. So at best may be a btrfs only feature?

[ Parent | on HN ]

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 ]