What size restrictions are you worried about ?
*Note I work with software that regularly stores terabytes of data in sqlite.
*Note I work with software that regularly stores terabytes of data in sqlite.
How do you process that? The restrictions I had in my mind come from that it's infeasible to concurrently process a large dataset in mapreduce/bigquery style.
The systems I work with use it for backup data. We have many readers and writes. Some of those export a iscsi daemon that represents a block device from the backup that is then booted form.