> Since SQLite files are single, continuous files on your file system, they have to be stored on one, physical hard drive.
But you can use things like RAID or LVM to have a filesystem bigger than any of the physical hard drives that it's spread across.
> File systems have been built with reasonable file sizes in mind. That means: The limit for the files are even smaller than the limits for hard drive sizes.
Btrfs and exFAT both support files of up to 16 EiB (16,777,216 TiB). No hard drives even come close to this size. For comparison, the total capacity of an AWS Snowmobile (a shipping container full of hard drives) is only about 0.1 EiB.
But you can use things like RAID or LVM to have a filesystem bigger than any of the physical hard drives that it's spread across.
> File systems have been built with reasonable file sizes in mind. That means: The limit for the files are even smaller than the limits for hard drive sizes.
Btrfs and exFAT both support files of up to 16 EiB (16,777,216 TiB). No hard drives even come close to this size. For comparison, the total capacity of an AWS Snowmobile (a shipping container full of hard drives) is only about 0.1 EiB.