Questions tagged [blob]
11 questions
12
votes
2 answers
Creating a separate table for images or adding "image fields" to many tables?
I need to create a database in which several tables have images.
For example, users have profile pictures and uploaded ones and products have many pictures, as well.
Is it better to have one SQL table "images" or add "images" to every table that…
Computer's Guy
- 233
- 1
- 3
- 10
4
votes
1 answer
Fast Upload/Retrieval For Blob Data Solutions
Problem
I am currently investigating a solution to allow fast upload (and retrieval) of data that can be implemented via NoSQL/SQL or a file system on a Centos server with 64 core cpu with 529GB of ram.
The case is as follows:
The users have a need…
angrymuffins
- 53
- 4
4
votes
2 answers
Where to store many files?
I have 500.000 files with the combined size of 350GB. So an average file has 0.7MB size. Each file has metadata: 1 to 100 keywords and optionally a short description. I need to filter the files and find the keywords of the search expression in the…
inf3rno
- 1,209
- 10
- 26
3
votes
2 answers
Dealing with potential failures when appending data to a file on disk
I'm designing an application that will be appending blobs to a file on disk (local filesystem) and I'm currently thinking of how to deal with consistency issues that could occur if:
The application suddenly crashes
The whole system stops, e.g. due…
D. Jurcau
- 537
- 4
- 8
3
votes
6 answers
Should I use BLOB or Tables for storing large data?
Problem
Currently investigating a solution to improve the performance of a web application. The application works well for small projects, but faces performance issues in the UI when working with large projects.
The use case is the following:
A user…
codedabbler
- 167
- 1
- 6
2
votes
2 answers
How to store queryable 10-100MB BLOBs?
I have read several discussions about storing BLOBs in the database vs in an object storage. What I need in addition though is a functionality for querying these BLOBs. The BLOBs will be immutable compressed multi-dimensional arrays that will be 10s…
Ivaylo Toskov
- 129
- 4
2
votes
2 answers
Azure BLOB grained access
I have a standalone WPF desktop application which gathers data from Digital-to-Analog converter boards, computes, analyzes this data and then it creates binary files (proprietary format) with the result. There is a pace of one record (basically a…
tomab
- 171
- 1
- 7
2
votes
1 answer
Most efficient way of saving images and sending them to client browser
I'm building an app where users list items for sale and they can include up to five photos for each item. I'm using Azure Blob storage for storing the images.
In my app, I'll be displaying these images in several different ways and sizes. I'll show…
Randy Minder
- 556
- 3
- 11
1
vote
0 answers
Speeding up read write intensive operation on large files in cloud (Azure)
I am using Azure Storage Blobs to persist certain models per tenant. While processing items for each tenant these models have to be pulled to memory, used for certain operation, updated and pushed back to blob storage. With time the size of models…
mebjas
- 119
- 2
0
votes
2 answers
Do I have too much access to my users' personal media?
This would be a broad question - but I'm asking specific to the situation around an app that I've developed.
In short, I've written an app that allows users to persist their photos and videos to the 'cloud'.
In an effort to keep this brief I won't…
DanDev
- 23
- 3
0
votes
5 answers
What is a good format to store a table of data
This is for one of my personal projects. I want to store a table of data in a BLOB/TEXT column in the database. I don't want to store the data in its own database table because the schema of this data will often change, and I don't really need to…
art-solopov
- 247
- 3
- 7