Dear Dude, Rodney,
Thanks for your info. About our jpeg images, we will make them ourselves,
because well be making photos of plants that we need to put in the database, so
we dont need any links for them. Anyway, we might have to put links into the
database for something else. You mention that actual http links can actually be
_stored_ ? Like, how does this work, what does it mean by storing a link.
Thanks again, cool dudes.
Matthew
PHP/MySQL study
PHP/MySQL study
Messages In This Digest (2 Messages)
1a.
Re: usage of blobs From: Dude
1b.
Re: usage of blobs From: Rodney Derrick View All Topics | Create New Topic
Messages
1a.
Re: usage of blobs
Posted by: "Dude" [EMAIL PROTECTED] OOPman
Fri Aug 22, 2008 11:23 am (PDT)
For better database performance, I would suggest storing the actual
JPEG files in a directory on the server somewhere and just storing the
filenames in MySQL.
--- In [EMAIL PROTECTED] ps.com, "Matthew Cserhati" <[EMAIL PROTECTED] .> wrote:
>
> Hello all,
>
> I would like to ask how one uses binary large objects in their mysql
> databases?
>
> Does this mean that I have to upload the blob (in my case some jpeg
> pictures) itself into the directory i am working in (i work under
> linux). If I dump a database or table that the blob is embedded in,
> then does this mean I get a database within which i can view the jpeg
> image?
>
> Thanks,
>
> Matthew
>
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.
Re: usage of blobs
Posted by: "Rodney Derrick" [EMAIL PROTECTED] okcbigsteppa
Fri Aug 22, 2008 1:01 pm (PDT)
I think storing the links in the database is the best and quickess method.
-----Original Message-----
From: Dude <[EMAIL PROTECTED] com>
Sent: Friday, August 22, 2008 1:23 PM
To: [EMAIL PROTECTED] ps.com
Subject: [php_mysql] Re: usage of blobs
For better database performance, I would suggest storing the actual
JPEG files in a directory on the server somewhere and just storing the
filenames in MySQL.
--- In [EMAIL PROTECTED] ps.com, "Matthew Cserhati" <[EMAIL PROTECTED] .> wrote:
>
> Hello all,
>
> I would like to ask how one uses binary large objects in their mysql
> databases?
>
> Does this mean that I have to upload the blob (in my case some jpeg
> pictures) itself into the directory i am working in (i work under
> linux). If I dump a database or table that the blob is embedded in,
> then does this mean I get a database within which i can view the jpeg
> image?
>
> Thanks,
>
> Matthew
>
[The entire original message is not included]
Back to top Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
* 9
New MembersVisit Your Group
Y! Messenger
All together now
Host a free online
conference on IM.
Find helpful tips
for Moderators
on the Yahoo!
Groups team blog.
All-Bran
Day 10 Club
on Yahoo! Groups
Feel better with fiber.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily
Digest.
Create New Topic | Visit Your Group on the Web
Messages | Files | Photos | Links | Database | Polls | Members | Calendar
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to
Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
[Non-text portions of this message have been removed]
