It sounds like SQLite still requires a couple dynamically sizeable files for storing the database, so it probably isn't possible. You'd have to have a key-value store that can allocate blocks for the different files it needs.
It seems really bizarre to me, because you'd think a large tech company would have found a performance reason for throwing out the file system and disk partitions and using the device directly for storage, but it doesn't seem like that's happened yet. Probably wouldn't even be that hard for a team at a big company to implement a basic file system stripped of all the hierarchical/metadata stuff and use that.
I guess it really comes down to the fact that every application needs something like the program heap to store variable sized objects, and the file system is the closest thing to that currently.
Has anybody tried making a partition that’s really just a sqlite3 binary blob?
It sounds like SQLite still requires a couple dynamically sizeable files for storing the database, so it probably isn't possible. You'd have to have a key-value store that can allocate blocks for the different files it needs.
It seems really bizarre to me, because you'd think a large tech company would have found a performance reason for throwing out the file system and disk partitions and using the device directly for storage, but it doesn't seem like that's happened yet. Probably wouldn't even be that hard for a team at a big company to implement a basic file system stripped of all the hierarchical/metadata stuff and use that.
I guess it really comes down to the fact that every application needs something like the program heap to store variable sized objects, and the file system is the closest thing to that currently.