Linked Questions

39
votes
7answers
39k views

Is it better to store images in a BLOB or just the URL? [duplicate]

Possible Duplicate: Files - in the database or not? I was wondering if there's any good reason to still use blob fields in a database. A couple of years ago I worked with a DB with a bunch of ...
5
votes
3answers
14k views

What are the advantages and disadvantages of storing binary data in a SQL table vs a network drive? [duplicate]

Possible Duplicate: Files - in the database or not? I've been reading "Programming Entity Framework Code First" (http://www.amazon.com/Programming-Entity-Framework-Code-First/dp/1449312942). ...
3
votes
3answers
21k views

How to store mp3 files in MySQL database using phpMyAdmin? [duplicate]

I am new to databases, but I want a database for my site to store mp3 files in it, so later I play them on my site by using jplayer. They say there are two ways to store data (in this case mp3 files)...
1
vote
1answer
3k views

the best place for save binary file [duplicate]

Possible Duplicate: Files - in the database or not? anyone can tell me, what is the best place for save binary file? database or just in a file system? and what is plus and minus for both? :D ...
0
votes
2answers
4k views

store a file into table from TSQL [duplicate]

Possible Duplicate: Files - in the database or not? I Want to store a file into sql server 2008 from TSQL (Management Studio). I Know the file saving into varbinary column can be done by using ...
2
votes
1answer
2k views

How to Store Text Reports in a Database [duplicate]

I have dozens of text reports that come in every day and I need to store them. I cannot just zip them and put them on the hard drive because the users aren't sophisticated enough to figure that out. I ...
1
vote
2answers
133 views

Is it a good idea from a performance perspective to store audio files in a mysql database? [duplicate]

I have an application where I have audio files. I need to store them in a mysql table since we already have a mysql database available. I saw that some people don't advise to do so. What are the ...
1
vote
0answers
167 views

Pulling an Image from a Database vs pulling from a link to a directory [duplicate]

Possible Duplicate: Is it better to store images in a BLOB or just the URL? Files - in the database or not? I was wondering what the benefit is of pulling a varchar out of a database that ...
1
vote
0answers
30 views

Removing large image files from production database [duplicate]

The database design for a retail organization has several tables with image columns. These account for around 40% of the table size due to their large size. (Many a DBA issues come from inheriting ...
4
votes
2answers
1k views

SQL Server 2005, Large Binary Storage

I'm looking at trying to store a large amount of files in my SQL Server 2005 instead of saving them to a file system. I recently read a white paper suggesting that anything over 1M should be stored ...
5
votes
2answers
1k views

What are the possible considerations and drawbacks of storing binary image data directly in a table?

Although related to this question, I have a slightly different angle to approach this issue from. Here is my situation: I am writing a web application (either in PHP or Python) that manages addons ...
3
votes
2answers
2k views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
0
votes
1answer
2k views

Downloading image data type contain to desktop SQL Server 2008

I am very new to SQL Server 2008 and question may look very basic to gurus. Following in the problem universe. I have a huge (600 GB size) SQL Server 2008 table that stores pdf files in a column ...
1
vote
1answer
831 views

How do I load them as varbinary(MAX) format into SQL Database?

There are 1000 picture that are jpeg format.How do I load them as varbinary(MAX) format into SQL Database?But at the same time I want the bulk insert functionality.
1
vote
1answer
44 views

Can I use a timeseries DBMS to store video?

From a research study involving participants with a camera, I have chunks of video recording. I have to split them as part of the preprocessing into short sequences of around 5 min long. Each file ...