Questions tagged [blob]
Binary Large OBject, datatype
166 questions
3
votes
2
answers
349
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 ...
- 33
1
vote
1
answer
57
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....
- 175
1
vote
1
answer
102
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 ...
- 13
0
votes
1
answer
68
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
169
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 ...
- 1
0
votes
1
answer
245
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
(
...
- 101
0
votes
1
answer
48
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
69
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"
...
- 109
0
votes
1
answer
112
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
-1
votes
2
answers
354
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 ...
- 95
1
vote
1
answer
438
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 ...
- 11
1
vote
1
answer
537
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 ...
- 11
0
votes
1
answer
139
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
619
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> ...
- 119