| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:27:12 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b2ba90ff1a9b7-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=e941b240-b794-4d7e-a191-2dd571d543ef; expires=Thu, 23 Jul 2026 12:27:12 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: dd479d2c-d4d1-4cdb-b3aa-24222c202e7f
x-worker-origin-response-time: 494000000
x-dns-prefetch-control: off
set-cookie: prov=e941b240-b794-4d7e-a191-2dd571d543ef; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=U91WrYsFwCjZ.mmsnfClGzB4YeuMIosuUtSE5ndQUao-1753273632-1.0.1.1-ETWbOJYpDFatXFyHPhsdRlThtc1faXScuTp3hQPwQEfRs2E3Wgx..EamHtWjhIP5rSWfgJxdj_QMZt2Q.6Tg9Gj9TqPJ7dLMc56zYIKpMQk; path=/; expires=Wed, 23-Jul-25 12:57:12 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=BCkrz8ndlR3WVhsoxY3ljt60zZdtd5g0xr2Zzi_j7iU-1753273632671-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'blob' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [blob]
Binary Large OBject, datatype
166 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
2
answers
301
views
How to import an image from a file, using OPENROWSET, to a table record?
I am trying to import a small image from a file located on my MS SQL Server to a column in a database setup as VARBINARY(MAX). I have declared a variable as VARBINARY(MAX) and would like to assign ...
0
votes
1
answer
28
views
What is charset for a Blob?
I'm looking at Oracle Database Sample Schemas, and found there is a column of a charset for a column of Blob.
https://github.com/oracle-samples/db-sample-schemas/blob/main/customer_orders/co_create....
1
vote
1
answer
87
views
If I replace images in a table, will existing BLOB data be cleaned up and the database shrink?
I recently updated a table in my database by saving small thumbnail images as a byte[] to a varbinary(max) column.
This significantly improved the speed of loading thumbnails (previously I was loading ...
0
votes
1
answer
63
views
Is it better for performance, to create a separate filegroup for tables that contain blobs? [closed]
I am currently working on an application that has approximately 500,000 users. Each user has a profile picture averaging around 32KB in size. I am using SqlServer and I want to save these profile ...
0
votes
0
answers
143
views
How does table partitioning size affect query performance?
In my system, I have a set of Oracle 19c database tables which stored temparary data, which are getting expired. I have a solution where I partitioned these tables with the create timestamp of these ...
0
votes
1
answer
204
views
MariaDB: Writing even 25MB of data into a LONGBLOB is very slow
We recently added MariaDB as a storage option for our tool. Before that we only allowed sqlite. Among other tables I have a very simple temporary file storage table:
create table tmp_file_storage
(
...
0
votes
1
answer
40
views
lo_import realization in libpq of Postgresql
In the current implementation of lo_import, lo_write will be called each time for each 8KB of the file. 8KB is the buffer size set in LO_BUFSIZE. Why is it so small? It slows down the file upload by ...
0
votes
1
answer
57
views
How to reference uploaded blob objects in database tables
When there are urls in a database table that represent media files uploaded to my own blob storage:
Is it common to link a column relationally to an objects table
Ex:
videoHdObjectId: "XXX"
...
0
votes
1
answer
103
views
Postgres server migration and version upgrade
We are migrating a 2TB server with a very large amount of BLOBs from an on-premises server to a cloud server. During the migration, we'd also like to update the Postgres version from 14 to 16.
Now due ...
-1
votes
2
answers
333
views
Duplicate BLOB in Postgres duplicate the storage requirements?
I uploaded a huge 2GB file in postgres in a Blob tuple field. In example for id #1
If I upload the same file a second time (in example for id #2). Do I need the double space requirements?
As far as I ...
1
vote
1
answer
409
views
Upgrade Postgres version with a lot of BLOBs
We are in the process of trying to upgrade our DB from Postgres 9.5 to 14 and decided to use the postgres utility pg_upgrade --link. This was left to run for over a day and we had to abort the process ...
1
vote
1
answer
508
views
Can JDBC Oracle file stream blob inserts be speeded up?
I have these four different ways by which I am inserting some file data into an Oracle database using JDBC and PreparedStatements.
Approach A
ps.setBytes(1, fileDataInByteArray);
Approach B
Blob ...
0
votes
1
answer
112
views
IBM DB2 v11.5 on RHEL8 - recovering BLOB table
first of all, thanks to all the gurus..
The problem is:
A table that accepts pdf/jpeg/png file upload from frontend. The table with BLOB defined as below:
"IMAGEDATA" BLOB(3048576) LOGGED ...
0
votes
1
answer
606
views
How to keep Image data in file system with Postgres database?
I am wondering is there any way to store image type data (binary data) in postgresql not directly into the columns but resides in the file system but not gonna store the path link as text in database ...
1
vote
1
answer
2k
views
SQL Server - Access denied when reading a file from Azure Blob Storage container using SAS key
I have a requirement to read CSV files from an Azure blob storage. So far, this is throwing access denied errors every time I run my query:
CREATE DATABASE SCOPED CREDENTIAL <myScopedCredential> ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
oracle × 40
sql-server × 38
mysql × 35
postgresql × 32
performance × 17
database-design × 12
filestream × 8
sql-server-2012 × 7
bytea × 6
oracle-11g-r2 × 6
sql-server-2014 × 6
datatypes × 5
varbinary × 5
compression × 4
backup × 4
amazon-rds × 4
export × 4
db2-luw × 4
index × 4
mariadb × 4
migration × 4
oracle-11g × 4
postgresql-9.1 × 4
storage × 4
more related tags
Hot Network Questions
- Can you identify this shell case from Flanders?
- What *IS* switch bounce REALLY? According to evidence. (Not *how* to debounce.)
- Why Schrodinger wave equation is totally different from classical wave equation?
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- Which domain (time or frequency) does filtering actually occur in real-life?
- What's the point of all-wheel drive (AWD) in RoadCraft, if vehicles consume no fuel?
- Repository with SQLite in Python
- Story about a room on Mars that contains God
- Why does my door knob bolt catch in the retracted position?
- Book/book series including siblings (possibly twins; boy and girl) fighting various creatures from the 2010's
- Mother in Law has overstayed her schengen visitor visa by 9 days. She is applying for the same visa this year, what should we take care of?
- Error when sending an email with attached PDF using Google Script
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- Is classical logic the consensus among contemporary logicians?
- Why does internal energy end up higher in an irreversible adiabatic process, even though the work done is less?
- grep behaviour is different when run using bash -c '...'
- Etymology of the word skulduggery?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- "Tumas t'hom" from merely walking on a non-jewish grave?
- Why is my gooseberry jam so stiff?
- Why does contact with the ground make my touch-activated LED brighter?
- OId Movie about an alien city that plays a repeating melody
- Distribution of a dot product of multinomial variables