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
37
votes
5 answers

How to persist LARGE BLOBs (>100MB) in Oracle using Hibernate

I'm struggling to find a way to insert LARGE images (>100MB, mostly TIFF format) in my Oracle database, using BLOB columns. I've searched thoroughly across the web and even in StackOverflow, without being able to find an answer to this problem.…
paoloyx
  • 575
  • 1
  • 7
  • 12
37
votes
2 answers

How to write java.sql.Blob to JPA entity?

I have a JPA entity with java.sql.Blob: @Entity public class LargeData { @Lob private java.sql.Blob data; //getters/setters } How to create instance of this entity? I want to set Blob with setData() method, but how to get Blob from JPA?…
amorfis
  • 15,390
  • 15
  • 77
  • 125
37
votes
9 answers

Viewing Content Of Blob In phpMyAdmin

Sorry for the Noob Question, but what does the circled button mean, and how can I view the content of a blob? (source: rigel222.com)
Joshua
  • 6,643
  • 15
  • 55
  • 76
37
votes
4 answers

Example using BLOB in SQLAlchemy

Does anybody have example on how to use BLOB in SQLAlchemy?
user207253
  • 381
  • 1
  • 3
  • 4
36
votes
2 answers

How is a blob column annotated in Hibernate?

How is a blob column annotated in Hibernate? So far I have a class that has: @Column( name = "FILEIMAGE" ) private byte[ ] fileimage ; // public byte[ ] getFileimage ( ) { return this.fileimage ; } public void setFilename ( String filename ) {…
quinn
36
votes
1 answer

Should I use redis to store a large number of binary files?

I need to store huge amount of binary files (10 - 20 TB, each file ranging from 512 kb to 100 MB). I need to know if Redis will be efficient for my system. I need following properties in my system: High Availability Failover Sharding I intend to…
biztiger
  • 1,447
  • 4
  • 23
  • 40
36
votes
6 answers

bad value for type long: - Postgresql, Hibernate, Spring

I wanna store an entity(a String + an image) in PostgresQL using Spring MVC and Hibernate Here is my table. The image is supposed to be the type of oid. CREATE TABLE document ( name character varying(200), id serial NOT NULL, content oid, //…
Sanyifejű
  • 2,610
  • 10
  • 46
  • 73
35
votes
3 answers

Uploading File in parts using XMLHttpRequest and auth digest

I am trying to upload a local mp4/movie file with XMLHttpRequest() on a server. This is written with react-native and in a final version user would be able to upload any big files from his/her IOS/Android device to the server. My test file is about…
Dirindon
  • 634
  • 1
  • 5
  • 15
34
votes
14 answers

To Do or Not to Do: Store Images in a Database

In the context of a web application, my old boss always said put a reference to an image in the database, not the image itself. I tend to agree that storing an url vs. the image itself in the DB is a good idea, but where I work now, we store a lot…
nickytonline
  • 6,855
  • 6
  • 42
  • 76
34
votes
3 answers

Storing images in Core Data or as file?

I have set of data which contains images also. I want to cache this data. Should i store them on file system or on core data and why?
Abhinav
  • 37,684
  • 43
  • 191
  • 309
34
votes
12 answers

How to get the name of a file downloaded with Angular $http?

I've written code that uses Angular $http to download a file. The name of the file is not specified in the URL. The URL contains a unique identifier for the file, which is fetched from outside the application. When $http.get(myUrl) is called,…
Vivian River
  • 31,198
  • 62
  • 198
  • 313
33
votes
4 answers

Speed of mysql query on tables containing blob depends on filesystem cache

I have a table with approximately 120k rows, which contains a field with a BLOB (not more than 1MB each entry in size, usually much less). My problem is that whenever I run a query asking any columns on this table (not including the BLOB one), if…
periklis
  • 10,102
  • 6
  • 60
  • 68
33
votes
2 answers

Blob constructor browser compatibility

I am developping an application where I recieve image data stored in a uint8Array. I then transform this data to a Blob and then build the image url. Simplified code to get data from server: var array; var req = new XMLHttpRequest(); var url =…
Jacob
  • 3,580
  • 22
  • 82
  • 146
33
votes
6 answers

Display image from blob using javascript and websockets

I'm currently working on a WebSocket application that is displaying images send by a C++ server. I've seen a couple of topics around there but I can't seem to get rid of this error in Firefox: Image corrupt or truncated: data:image/png;base64,[some…
guitio2002
  • 563
  • 2
  • 5
  • 13
32
votes
9 answers

Overcomplicated oracle jdbc BLOB handling

When I search the web for inserting BLOBs into Oracle database with jdbc thin driver, most of the webpages suggest a 3-step approach: insert empty_blob() value. select the row with for update. insert the real value. This works fine for me, here is…
asalamon74
  • 6,120
  • 9
  • 46
  • 60
1 2 3
…
99 100