Questions tagged [blob]

A BLOB is a collection of binary data stored as a single entity in a database management system.

A BLOB (binary large object, basic large object, BLOB, or BLOb) is a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.

Beyond that, the term BLOB has various slightly related usages, see wikipedia for further examples.

7634 questions
21
votes
4 answers

Base64 representing PDF to blob - JavaScript

I have a Base64 string representing a PDF file. I want to convert it to a file with the Blob object using javascript. After it's done i want to save the blob as a PDF file using FileSaver.js. Here is my code: var base64PDF = JVBERi0xLjQNCiW0t..; //…
user3461486
  • 261
  • 1
  • 2
  • 7
21
votes
2 answers

Html5's File API - BLOB usages?

I have a file input : (jsbin) Which, when file selected, shows small images of the selected image: I can do it in two ways : using FileReader: function…
Royi Namir
  • 144,742
  • 138
  • 468
  • 792
21
votes
3 answers

Postgresql, JDBC, and streaming BLOBs

I am trying to retrieve a blob from a postgres database using the jdbc drivers. It is too big to have in memory so I want to stream it as a download. I tried using the getBinaryStream method on ResultSet, but it turns out that this method actually…
CJ F
  • 835
  • 2
  • 8
  • 22
21
votes
1 answer

Android: Cursor Window is full

W/CursorWindow(15677): Window is full: requested allocation 2195889 bytes, free space 2096720 bytes, window size 2097152 bytes I know there is app memory avaliable: D/dalvikvm(15677): GC_FOR_ALLOC freed 9K, 30% free 17050K/24291K, paused…
IAmGroot
  • 13,760
  • 18
  • 84
  • 154
20
votes
2 answers

Record 5 seconds segments of audio using MediaRecorder and then upload to the server

I want to record user's microphone 5 seconds long segments and upload each to the server. I tried using MediaRecorder and I called start() and stop() methods at 5 seconds time interval, but when I concatenate these recordings there is a "drop" sound…
MM PP
  • 4,050
  • 9
  • 35
  • 61
20
votes
2 answers

Download Blob file from Website inside Android WebViewClient

I have an HTML Web page with a button that triggers a POST request when the user clicks on. When the request is done, the following code is fired: window.open(fileUrl); Everything works great in the browser, but when implement that inside of a…
Jonathan Brizio
  • 1,087
  • 1
  • 14
  • 28
20
votes
2 answers

Angular 4 new HttpClient content-disposition header

I am trying to get a file (array buffer) from my backend using the new HttpClient. My code is pretty much like the following: this.http.post(url, body, {responseType: 'blob', observe: 'response'}) .subscribe(resp => { …
Tobias Etter
  • 744
  • 1
  • 6
  • 19
20
votes
2 answers

Create json file using blob

I have written json code in string and i want to send it using xmlhttp as .json file. Is it possible to do it with blob? var cleanScript = { 'type': 'script', 'api_key': api_key, 'data': data, 'inputs': inputs, 'timeoutSeconds':…
josaric
  • 367
  • 1
  • 3
  • 10
20
votes
4 answers

How can I fix a missing blob in Git?

Because I've been rsyncing my Git repository between various places, I'm now stuck with a broken Git repository. When I do git log I get a correct history, but when I do git status I get fatal: unable to read…
kramer65
  • 50,427
  • 120
  • 308
  • 488
20
votes
1 answer

Huge JavaScript HTML5 blob (from large ArrayBuffers) to build a giant file in client side

I'm writing a web browser app (client-side) that downloads a huge amount of chunks from many locations and joins them to build a blob. Then that blob is saved to local filesystem as a common file. The way I'm doing this is by mean of ArrayBuffer…
sgmonda
  • 2,615
  • 1
  • 19
  • 29
20
votes
5 answers

com.mysql.jdbc.PacketTooBigException

I am storing images in MYSQL. I have table as CREATE TABLE myTable (id INT, myImage BLOB); When I am trying to insert 4.7MB file, I am getting exception as com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4996552 > 1048576).…
Fahim Parkar
  • 30,974
  • 45
  • 160
  • 276
20
votes
6 answers

Get size of large object in PostgreSQL query?

I would like to obtain the byte size of a blob. I am using Postgresql and would like to obtain the size using an SQL query. Something like this: SELECT sizeof(field) FROM table; Is this possible in Postgresql? Update: I have read the postgresql…
Bob
  • 457
  • 1
  • 5
  • 15
19
votes
2 answers

MYSQL TINYBLOB vs LONGBLOB

This is a follow up for my previous question: Blob and Storage Requirement I did some testing using SHOW TABLE STATUS, and found out that the total disk space used actually only depends on the size of actual files uploaded to the database and not on…
jombie
  • 315
  • 1
  • 3
  • 7
19
votes
1 answer

binary data in database, blob vs compressed base64

There is a column type named blob in database, and it is used to store binary data. But more often than not, I see solutions which compress binary data, then convert binary data to base64, and store base64 string as varchar or text in…
Tyler Liu
  • 19,552
  • 11
  • 100
  • 84
19
votes
1 answer

ArrayBuffer vs Blob and XHR2

XHR2 differences states The ability to transfer ArrayBuffer, Blob, File and FormData objects. What are the differences between ArrayBuffer and Blob ? Why should I care about being able to send them over XHR2 ? (I can understand value of File and…
Raynos
  • 166,823
  • 56
  • 351
  • 396