Image Store @ My SQL

--0-107385047-1264841644=:93378
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1=
..32). We have an client server application, server is located at anoth=
er end of an intranet and the nodes are connected from different ends of in=
tranet. In this modal, I need to store image of the student from one n=
ode that has to be accessed / Changed / by other nodes. If I have only one =
system I can store the path of the image. But it is a remote server, i can =
not store the PATH simply. Because of this i would like to go for an =
another modal of storing image itself into the DB I would like to know=
how VB 6.0 will handle this modal. Please give your valuable input on=
this issue. Thank you VIKKI A Your Mail works b=
est with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.co=
m/in/internetexplorer/
--0-107385047-1264841644=:93378--

Re: Image Store @ My SQL

Bad idea. Sotring images is what a file system is for. Create an NFS
or other networked storage and store your images there. I don't see
the problem?

good luck,

Walter Heck
Engineer @ Open Query (http://openquery.com)

On Sat, Jan 30, 2010 at 18:54, Vikram A wrote:
> Hi,
>
> I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32).
>
> We have an client server application, server is located at another end of=
an intranet and the nodes are connected from different ends of intranet.
>
> In this modal, I need to store image of the student from one node that ha=
s to be accessed / Changed / by other nodes. If I have only one system I ca=
n store the path of the image. But it is a remote server, i can not store t=
he PATH simply.
>
> Because of this i would like to go for an another modal of storing image =
itself into the DB
>
> I would like to know how VB 6.0 will handle this modal.
>
> Please give your valuable input on this issue.
>
> Thank you
>
> VIKKI A
>
>
>
>      Your Mail works best with the New Yahoo Optimized IE8=
.. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Image Store @ My SQL

--0-1671447891-1264842222=:68490
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Dear Walter Heck, I am happy to receive immediate response from you.=
I am not clear with your answer, can you please explain it? Than=
k you =0A________________________________=0AFrom: Walter Heck alter@openquery.com>=0ATo: Vikram A =0ACc: mysql@list=
s.mysql.com=0ASent: Sat, 30 January, 2010 2:29:43 PM=0ASubject: Re: Image S=
tore @ My SQL Bad idea. Sotring images is what a file system is for. C=
reate an NFS=0Aor other networked storage and store your images there. I do=
n't see=0Athe problem? good luck, Walter Heck=0AEngineer @ Open Q=
uery (http://openquery.com) On Sat, Jan 30, 2010 at 18:54, Vikram A ikkiatbipl@yahoo.in> wrote:=0A> Hi,=0A>=0A> I am using MYSQL with VB 6.0. W=
e have fedora11 my sql (version 5.1.32).=0A>=0A> We have an client server a=
pplication, server is located at another end of an intranet and the nodes a=
re connected from different ends of intranet.=0A>=0A> In this modal, I need=
to store image of the student from one node that has to be accessed / Chan=
ged / by other nodes. If I have only one system I can store the path of the=
image. But it is a remote server, i can not store the PATH simply.=0A>=0A>=
Because of this i would like to go for an another modal of storing image i=
tself into the DB=0A>=0A> I would like to know how VB 6.0 will handle this =
modal.=0A>=0A> Please give your valuable input on this issue.=0A>=0A> Thank=
you=0A>=0A> VIKKI A=0A>=0A>=0A>=0A> Your Mail works best with the New=
Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexp=
lorer/ Your Mail works best with the New Yahoo Optimized I=
E8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
--0-1671447891-1264842222=:68490--

Re: Image Store @ My SQL

On Sat, Jan 30, 2010 at 19:03, Vikram A wrote:
> I am not clear with your answer, can you please explain it?

Well, MySQL (as most databases) is not really suited for storing
images. If you create a networked storage that you can share between
both locations, that would solve your problem, right?

cheers,

Walter Heck
Engineer @ Open Query (http://openquery.com)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Image Store @ My SQL

--0-947461693-1264845714=:41384
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Dear Sir, Let me explain what i understood, 1. I have to create a=
shareable folder among the network.=0A2. The image files has to be kept at=
share machine=0A3. Then the path (share machine) of the file has to be sto=
red in the DB=0A4. When we want it has to be taken from the share Is =
it So? then i may have the following, when ever i want the image of a i ne=
ed look for the share machine! If it is not available it may cause some dif=
ficulties. Please share your knowledge Thank you =0A=
________________________________=0AFrom: Walter Heck y.com>=0ATo: Vikram A =0ACc: MY SQL Mailing list ql@lists.mysql.com>=0ASent: Sat, 30 January, 2010 3:16:11 PM=0ASubject: Re:=
Image Store @ My SQL On Sat, Jan 30, 2010 at 19:03, Vikram A bipl@yahoo.in> wrote:=0A> I am not clear with your answer, can you please e=
xplain it? Well, MySQL (as most databases) is not really suited for st=
oring=0Aimages. If you create a networked storage that you can share betwee=
n=0Aboth locations, that would solve your problem, right? cheers,=0A=
=0AWalter Heck=0AEngineer @ Open Query (http://openquery.com) -- =0AMy=
SQL General Mailing List=0AFor list archives: http://lists.mysql.com/mysql=
=0ATo unsubscribe: http://lists.mysql.com/mysql?unsub=3Dvikkiatbipl@yaho=
o.in =0A The INTERNET now has a personality. YOURS! See your Yaho=
o! Homepage. http://in.yahoo.com/
--0-947461693-1264845714=:41384--

Re: Image Store @ My SQL

I agree with Walter, a filesystem is far better suited for this.

That said, mysql does have the ability to do what you are saying, you would just store it as a
binary blob which is well documented and quite easy to use.

See: http://dev.mysql.com/doc/refman/5.0/en/blob.html

Colin

On January 30, 2010 05:01:54 am Vikram A wrote:
> Dear Sir,
>
> Let me explain what i understood,
>
> 1. I have to create a shareable folder among the network.
> 2. The image files has to be kept at share machine
> 3. Then the path (share machine) of the file has to be stored in the DB
> 4. When we want it has to be taken from the share
>
> Is it So? then i may have the following, when ever i want the image of a i
> need look for the share machine! If it is not available it may cause some
> difficulties.
>
> Please share your knowledge
>
> Thank you
>
>
>
>
>
>
> ________________________________
> From: Walter Heck
> To: Vikram A
> Cc: MY SQL Mailing list
> Sent: Sat, 30 January, 2010 3:16:11 PM
> Subject: Re: Image Store @ My SQL
>
> On Sat, Jan 30, 2010 at 19:03, Vikram A wrote:
> > I am not clear with your answer, can you please explain it?
>
> Well, MySQL (as most databases) is not really suited for storing
> images. If you create a networked storage that you can share between
> both locations, that would solve your problem, right?
>
> cheers,
>
> Walter Heck
> Engineer @ Open Query (http://openquery.com)
>

--
Q: What's the difference between an Irish wedding and an Irish wake?
A: One less drunk.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Re: Image Store @ My SQL

Vikram A wrote:
> Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties.
>
1) NFS sharing a file (any file) is better suited for this task.
2) The DB should only hold the file path (pointing to the NFS share)

Your comment above, what if the NFS share is unavailable, it will
cause a problem. While this is true, the same can be said about your
SQL server. What if it becomes unavailable?

Point is, use the tools you have available for what they're best
intended for. You can have 1 master server that is both your NFS as
well as your MySQL server and that sits at one end of your intranet.
Then you have the second machine, at the other end of the intranet, act
as the MySQL slave and replicate everything from the master DB. As long
as the paths stored in MySQL are pointing to the NFS path, everything
should work fine.

And if you don't want to run NFS, you can run rsync on the slave
server and pull all the images from the master machine into the slave
one. This will avoid images not being found if your master server goes
down.

There are many ways to skin this cat ...

--
H | It's not a bug - it's an undocumented feature.
+----------------------------------------------------------- ---------
Ashley M. Kirchner . 303.442.6410 x130
IT Director / SysAdmin . 800.441.3873 x130
Photo Craft Imaging . 2901 55th Street
http://www.pcraft.com ..... . . . Boulder, CO 80301, U.S.A.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org