The design of BLOB (=TEXT) storage in MySQL seems to be totally flawed and counter-intuitive. I ran a couple of times into the same problem and was unable to find any authoritative explanation. The most detailed analysis I’ve finally found is this post from 2010: http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/ General belief and expectation is that BLOBs/TEXTs are stored … Read more
The existing answer appears largely out of date. Chrome (57+ it appears): According to Chrome’s Blob Storage System Design: Blob Storage Limits We calculate the storage limits here. In-Memory Storage Limit If the architecture is x64 and NOT ChromeOS or Android: 2GB Otherwise: total_physical_memory / 5 Disk Storage Limit If ChromeOS: disk_size / 2 If … Read more
I think the cleanest solution would be to change the base64 encoder to operate directly on a Uint8Array instead of a string. Important: You’ll need to set the binaryType of the web socket to “arraybuffer” for this. The onmessage method should look like this: socket.onmessage = function(msg) { var arrayBuffer = msg.data; var bytes = … Read more
This is quite possible and easy to do. Simply use dbms_lob.instr in conjunction with utl_raw.cast_to_raw So in your case, if t1 is a BLOB the select would look like: select * from table1 where dbms_lob.instr (t1, — the blob utl_raw.cast_to_raw (‘foo’), — the search string cast to raw 1, — where to start. i.e. offset … Read more
Chrome’s extension seems to rely on the resource name set in the URI, i.e the file.ext in protocol://domain/path/file.ext. So if your original URI contains that filename, the easiest might be to simply make your <object>’s data to the URI you fetched the pdf from directly, instead of going the Blob’s way. Now, there are cases … Read more
Pros of putting images in a Database. Transactions. When you save the blob, you can commit it just like any other piece of DB data. That means you can commit the blob along with any of the associate meta-data and be assured that the two are in sync. If you run out of disk space? … Read more
I have a couple ideas. What happens if you wait for the blob slice to be created before making the upload call? const firstBlob = await new Promise(resolve => { newBlob.slice(0, 262144).onCreated(resolve) }); // send request with blob firstBlob.safeClose(); const secondBlob = await new Promise(resolve => { newBlob.slice(262144, 262144 * 2).onCreated(resolve) }); // etc It … Read more
It may be worth mentioning that in order to get the file name from the HTTP headers, extracting the Content-Disposition header is not enough. You still need to obtain the filename property from this header value. Example of header value returned: attachment; filename=”myFileName.pdf”. The function below will extract filename=”myFileName.pdf”, then extract “myFileName.pdf” and finally remove … Read more
I would not use Redis for such a task. Other products will be a better fit IMO. Redis is an in-memory data store. If you want to store 10-20 TB of data, you will need 10-20 TB of RAM, which is expensive. Furthermore, the memory allocator is optimized for small objects, not big ones. You … Read more