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
50
votes
11 answers

Blob download is not working in IE

I have this in my Angular.js controller that downloads a CSV file: var blob = new Blob([csvContent.join('')], { type: 'text/csv;charset=utf-8'}); var link = document.createElementNS('http://www.w3.org/1999/xhtml', 'a'); link.href =…
raberana
  • 11,739
  • 18
  • 69
  • 95
48
votes
4 answers

How to dump a file stored in a sqlite database as a blob?

I have a sqlite3 database. One column has the TEXT type, and contains blobs which I would like to save as file. Those are gzipped files. The output of the command sqlite3 db.sqlite3 ".dump" is: INSERT INTO "data"…
alecail
  • 3,993
  • 4
  • 33
  • 52
46
votes
8 answers

Open blob objectURL in Chrome

I want to open a PDF in a new tab in chrome browser (Chrome 56.0.2924.87, Ubuntu 14.04) using window.open(fileObjectURL) in javascript. I am creating the blob from base64 encoded data and do create an objectURL like this: const fileObjectURL =…
Michbeckable
  • 1,851
  • 1
  • 28
  • 41
46
votes
2 answers

Display a video from a Blob Javascript

I would like to display a video from a Javascript Blob/File object in the HTML5 video tag. This code only works for small videos : var reader = new FileReader(); reader.onload = function(e) { document.getElementById("video").src=reader.result; …
Antonin M.
  • 1,744
  • 1
  • 18
  • 29
45
votes
1 answer

convert image into blob using javascript

I use promise to download an image and get the image data like: promise.downloadFile().then(function(image){ //do something }); I have got the image, which is like:
caxieyou110
  • 517
  • 1
  • 4
  • 8
45
votes
1 answer

Appending Blob data

Is there a function for appending blob data in JavaScript I currently use the following approach: var bb = new Blob(["Hello world, 2"], { type: "text/plain" }); bb = new Blob([bb, ",another data"], { type: "text/plain" }); And BlobBuilder function…
Deni Spasovski
  • 4,004
  • 3
  • 35
  • 52
45
votes
4 answers

Windows Azure Storage Certificate Expired

The certificate for our Azure blob storage expired today. This is not a certificate provided by us but provided by Microsoft as show in the picture below. How does one go about fixing this? I have tried searching for a solution but found nothing.…
Nick Olsen
  • 6,299
  • 11
  • 53
  • 75
44
votes
4 answers

Can I set the filename of a PDF object displayed in Chrome?

In my Vue app I receive a PDF as a blob, and want to display it using the browser's PDF viewer. I convert it to a file, and generate an object url: const blobFile = new File([blob], `my-file-name.pdf`, { type: 'application/pdf' }) this.invoiceUrl =…
false_azure
  • 1,333
  • 4
  • 25
  • 46
44
votes
4 answers

Download BLOB content using specified charset

Is possible to change the Blob charset really? I'm trying it for hours but it doesn't workds. See this. jQuery("#download").click(function() { var csv_content = jQuery("#csv").val(), download = document.createElement("a"), blob =…
David Rodrigues
  • 12,041
  • 16
  • 62
  • 90
43
votes
5 answers

Save to Local File from Blob

I have a difficult question to you, which i'm struggling on for some time now. I'm looking for a solution, where i can save a file to the users computer, without the local storage, because local storage has 5MB limit. I want the "Save to…
fsx_steven
  • 431
  • 1
  • 4
  • 3
39
votes
3 answers

How can I insert into a BLOB column from an insert statement in sqldeveloper?

Is it possible to insert into a BLOB column in oracle using sqldeveloper? i.e. something like: insert into mytable(id, myblob) values (1,'some magic here');
chris
  • 36,094
  • 53
  • 157
  • 237
39
votes
3 answers

In GitHub URL's: what is the difference between a tree and a blob?

I keep noticing this whenever I'm trying to add links to github files. You can add a link using blob: https://github.com/facebook/pop/blob/master/Podfile And the same doc comes up if you change blob to…
gran_profaci
  • 8,087
  • 15
  • 66
  • 99
39
votes
4 answers

Calculating total data size of BLOB column in a table

I have a table with large amounts of BLOB data in a column. I am writing a utility to dump the data to file system. But before dumping, I need to check if necessary space is available on the disk to export all the blob fields throughout the…
jatinpreet
  • 589
  • 1
  • 4
  • 11
38
votes
2 answers

insert a BLOB via a sql script?

I have an H2 database (http://www.h2database.com) and I'd like to insert a file into a BLOB field via a plain simple sql script (to populate a test database for instance). I know how to do that via the code but I cannot find how to do the sql script…
dm76
  • 4,130
  • 8
  • 35
  • 46
38
votes
4 answers

fastest way to export blobs from table into individual files

What is the fastest way to export files (blobs) stored in a SQL Server table into a file on the hard drive? I have over 2.5 TB of files (90 kb avg) stored as varbinary and I need to extract each one to a local hard drive as quickly as possible. …
influent
  • 1,337
  • 3
  • 14
  • 31