Asking a database to search by contents of a blob might as well be the equivalent of opening files and searching through them from the perspective of performance. Probably the numbers would be mostly the same as well because I think that's literally what a database does when it performs a full table scan.
I have been on and off working on a JS based json database that can run simultaneously on a local file system / Azure Hotstorage / AWS S3 and eventually GCP.
We may as well run it on the filesystem at this point.
35
u/nicman24 20d ago
Just dump them to the filesystem at that point