Login or Register to Ask a Question and Join Our Community


Web Development

store images into databases or path to file system files ?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development store images into databases or path to file system files ?
# 1  
Old 01-09-2010
store images into databases or path to file system files ?
hi,

I need a quick information about storing images into mysql databases.

Is more convenient to store a path to the filesystem folder in which the images are stored, or is possible to directly store the images into my tables ?

thanks
# 2  
Old 01-09-2010
Depends on what you need to do. If you just want to store the images, put them into a BLOB column. However, as soon as you need to do something with the images besides storing and displaying, you'll need to use files, as most image manipulation programs don't work with a database or input streams.
# 3  
Old 01-15-2010
This is a common question on various job interviews. I'd say use the FS to store them, because having them in DB has more drawbacks than positive sides.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

What do I do in shell scripting to access ma databases from my system?

How do I go about programming my system? I have access to multiple data bases but no way to operate them (1 Reply)
Discussion started by: C-lo
1 Replies

2. Shell Programming and Scripting

Execute sequential files and store data in single file

1)In a particualr path i have a set of inputfiles like path:/defaultmis/MonthlyLoads/INFA_EXPORT_022013/map* example: 1)map_de 2)map_cod 3)map_feg ........and so on in above path there wil be nearly 15 to 20 files starting with map and in other path i have another file input file... (4 Replies)
Discussion started by: katakamvivek
4 Replies

3. Solaris

Moving a zone path to a new file system

Hello Gurus, I need your help with this please. I am trying to move a zone to a new directory but it keeps failing. Below is what I did and the message I get. Your help will be appreciated. Thanks zoneadm -z testzone move /rpool/testzone cannot create ZFS dataset rpool/testzone: dataset... (1 Reply)
Discussion started by: cjashu
1 Replies

4. Shell Programming and Scripting

to read two files, search for patterns and store the output in third file

hello i have two files temp.txt and temp_unique.text the second file consists the unique fields from the temp.txt file the strings stored are in the following form 4,4 17,12 15,65 4,4 14,41 15,65 65,89 1254,1298i'm able to run the following script to get the total count of a... (3 Replies)
Discussion started by: vaibhavkorde
3 Replies

5. Shell Programming and Scripting

Store the files details in different file using bash

Hi all, this is output of ls command !! there is differen different files permission are there , and my requirement is each file permission is stored in different different file. rwxr-xr-x 1 root root 0 Mar 29 2011 2 -rwxr-xr-x 1 root root 0 Mar 29 2011 20 drwxr-xr-x 2... (3 Replies)
Discussion started by: anishkumarv
3 Replies

6. Shell Programming and Scripting

Find diff bet 2 files and store result in another file

Hi I want to compare 2 files. The files have the same amount of rows and columns. So each line must be compare against the other and if one differs from the other, the result of both must be stored in a seperate file. I am doing this in awk. Here is my file1: Blocks... (2 Replies)
Discussion started by: ladyAnne
2 Replies

7. UNIX for Advanced & Expert Users

File System Type From File Path?

I'm writing a gui for the core utility shred. I want to be able to warn the user if they are about to shred a file that is on a journaled file system. In order to do this, I must learn the file system type of the path they are about to shred. Is there a way in Unix to: 1. query a specific... (3 Replies)
Discussion started by: codecellar
3 Replies

8. UNIX for Dummies Questions & Answers

How to create ghost images of a Solaris system?

Please excuse me if I asked some stupid questions. I know this has been asked and answered, but I didn't get the answer I need yet. How do I create a ghost image of a Solaris system? And if I can do so, how do I restore it? The purpose is (just like in Windows) to restore a clean system when... (3 Replies)
Discussion started by: correro
3 Replies
Login or Register to Ask a Question