| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 07:03:17 GMT
content-type: text/html; charset=utf-8
cf-ray: 96418e880febc462-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=b26de1d9-0abc-4def-a4f9-b14f4441df3b; expires=Fri, 24 Jul 2026 07:03:16 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-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: dd04bf7f-b386-4c93-8a46-0c829ef3757f
x-worker-origin-response-time: 523000000
x-dns-prefetch-control: off
set-cookie: prov=b26de1d9-0abc-4def-a4f9-b14f4441df3b; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=Cz7lAIqvbojm5a4AVCJ7owhNDsET75bqtGSdgoPsqyw-1753340597-1.0.1.1-IVoDSOZ23jLmuVs4vvgHl0d0VHXN0nabxD5V2og.ICaNtcsI9Mrdesh0nB.OPjyaCd93fwbKMCaU8MQynZlftorIi6O9Ofeunf5hHu3S8k8; path=/; expires=Thu, 24-Jul-25 07:33:17 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=2Je04cAozlPA5RdyY23u6aPaHUWG8jddY9Ji_9iUF38-1753340597051-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
334
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
- Legolas Master Archer removed with 2nd triggered ability on stack
- Why are Jewish people named Anat?
- Expected Value of a Dice Product Game
- How much time should I take for "self transfer" without checked-in baggage?
- rotated `\check` symbol
- Guitar Intonation - Flat On Certain Frets
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Descriptive nouns omitting の?
- Expected Sum of Remaining Dice After Removing Complete Sets
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- Heavy shelves, but not a center stud
- How do I rotate each set of instances towards the centre
- Dystopian 80s sci-fi movie about the USA choosing mediocrity
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Ubuntu Server installation -- options for boot disks are grayed out
- When you view a historical event with an incorrect modern lens
- A complex polynomial inequality
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- Does אֵלִ֣י in psalm 22:1 say god or "my god"
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Which domain (time or frequency) does filtering actually occur in real-life?
- How can I automatically replace curly braces { and } in LaTeX macro arguments—e.g., in math formulas—for label generation?
- Is it okay to email researchers if I’m just a high school student?
- Camera Controls Stopped Working