Stack Overflow
Stack Overflow

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
97
votes
1 answer

dbms_lob.getlength() vs. length() to find blob size in oracle

I'm getting the same results from select length(column_name) from table as from select dbms_lob.getlength(column_name) from table However, the answers to this question seem to favor using dbms_lob.getlength(). Is there any benefit to using…
user285498
95
votes
7 answers

Is it possible to perform a batch upload to amazon s3?

Does amazon s3 support batch uploads? I have a job that needs to upload each night ~100K of files that can be up to 1G but is strongly skewed towards small files (90% are less than 100 bytes and 99% are less than 1000 bytes long). Does the s3 API…
flybywire
  • 261,858
  • 191
  • 397
  • 503
91
votes
6 answers

Adding UTF-8 BOM to string/Blob

I need to add a UTF-8 byte-order-mark to generated text data on client side. How do I do that? Using new Blob(['\xEF\xBB\xBF' + content]) yields '"my data"', of course. Neither did '\uBBEF\x22BF' work (with '\x22' == '"' being the next character…
Kijewski
  • 25,517
  • 12
  • 101
  • 143
90
votes
7 answers

Jest URL.createObjectURL is not a function

I'm developping a reactJs application. I'm using jest to test my application. I want to test a function that download a blob. But unfortunately I receve this error: URL.createObjectURL is not a function my test function: describe('download', () =>…
Melchia
  • 22,578
  • 22
  • 103
  • 117
90
votes
7 answers

Decoding facebook's blob video url

I found blob:https://www.facebook.com/c7e5a634-2343-4464-a03e-4a1987301ca1 video source on Facebook's private group and I really can't download the video by entering the url nor am I able to decode. Is there any way to decode this?
ujwal dhakal
  • 2,289
  • 2
  • 30
  • 50
90
votes
22 answers

How to DEFLATE with a command line tool to extract a git object?

I'm looking for a command line wrapper for the DEFLATE algorithm. I have a file (git blob) that is compressed using DEFLATE, and I want to uncompress it. The gzip command does not seem to have an option to directly use the DEFLATE algorithm, rather…
Felix Geisendörfer
  • 2,902
  • 5
  • 27
  • 36
89
votes
7 answers

What is it exactly a BLOB in a DBMS context

What is it a BLOB? How can I use it? What are the differences between DBMS's BLOBs. I would like to save data using BLOBs into any DBMS and then read that BLOB with a library.
edgarmtze
  • 24,683
  • 80
  • 235
  • 386
85
votes
7 answers

gitignore by file size?

I'm trying to implement Git to manage creative assets (Photoshop, Illustrator, Maya, etc.), and I'd like to exclude files from Git based on file size rather than extension, location, etc. For example, I don't want to exclude all .avi files, but…
Warren Benedetto
  • 2,478
  • 2
  • 22
  • 25
81
votes
9 answers

Angular: How to download a file from HttpClient?

I need download an excel from my backend, its returned a file. When I do the request I get the error: TypeError: You provided 'undefined' where a stream was expected. You can provide an Observable, Promise, Array, or Iterable. My code…
Jean Carlos
  • 1,613
  • 3
  • 18
  • 26
81
votes
29 answers

AzureStorage Blob Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature

I'm trying to upload a image in Windows Azure Blob and I'm geting the following error which I can't handle. Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. The…
Fábio Henrique
  • 821
  • 1
  • 6
  • 5
79
votes
6 answers

how to store Image as blob in Sqlite & how to retrieve it?

I want to store an image(from url) into a sqlite database. For that I use: db = new DataBase(getApplicationContext()); URL url = new URL("http://sree.cc/wp-content/uploads/schogini_team.png"); URLConnection ucon = url.openConnection(); InputStream…
Siten
  • 4,515
  • 9
  • 39
  • 64
75
votes
6 answers

How do I store and retrieve a blob from sqlite?

I have used sqlite in c++, python and now (perhaps) in C#. In all of these I have no idea how to insert a blob into a table. How do I store and retrieve a blob in sqlite?
user34537
74
votes
5 answers

Open links made by createObjectURL in IE11

Why can't you open the link in the following demo: http://html5-demos.appspot.com/static/a.download.html You cannot even right click and open it in a new tab/window. Is there any setting in the browser I need to customize?
user648340
72
votes
2 answers

Should I use blob or text for JSON in MySQL?

I am planning to store a json_encoded string on my database. I can't precisely tell the length its going to be, but I'm pretty sure it will be long. My concern is which field type I am going to use for this, is it blob or text? I prefer the one…
Leandro Garcia
  • 3,138
  • 11
  • 32
  • 44
69
votes
2 answers

Are there performance issues storing files in PostgreSQL?

Is it ok storing files like HTML pages, images, PDF, etc in a table in PostgreSQL or it is slow? I read some articles saying that this is not recommended, but I don't know if it's true. The column types I have in mind are BLOB (as far as I know it…
Renato Dinhani
  • 35,057
  • 55
  • 139
  • 199
1
2
3
…
99 100