4 ms·

SQLite, iirc, has a limit of 1GB per row, and that might too severely limit the utility of your file system if you don't end up splitting files into multiple fr

by chungy 5y ago

SQLite, iirc, has a limit of 1GB per row, and that might too severely limit the utility of your file system if you don't end up splitting files into multiple fragments (rows in the database).

bombela 5y ago
You read too fast: > SQLite as the backing store for file records, though not the file contents
- jacobwg 5y ago
  I believe they are referring to: > I imagine I could use it for file content as well
- amarshall 5y ago
  So did you: > I imagine I could use [SQLite] for file content as well
- deleted 5y ago
  [deleted]
imhoguy 5y ago
You are right, by default 1 billion bytes per row or blob. Can be raised up to 2GB with compilation parameter[0]. Storing video streams may be not a good idea, but e.g. photos, thumbnails or some JSON documents may be absolutely fine. [0] https://sqlite.org/limits.html https://sqlite.org/limits.html