Hi!
I have seen in this page http://www.blobstreaming.org/ but i think that it´s
quite difficult. I want to put only the url of the image, and as you said
the pictures o images might be in the server folder, but what is the folder?
Thanks.
--
View this message in context:
Hello!
I have tried the instructions that you explain to me. I have read also some
issues but doens´t work.
So i have done:
ui:tableColumn binding=#{STOCKSOC.tableColumn6} headerText=image
id=tableColumn6 sort=producto.image
ui:imageHyperlink
Hi,
I have read some messages about this topic but i haven´t resolved my
problem
yet. I am using mySQL Query Browser to make de schema. And i have a table
(product) where there are some attributes (producto, precio,
nUds,tipo)(spanish). All are relationated with one product (ex: heineken
beer).
Hello!
I have read that. But i have not idea what i have to do. Because i´m amateur
in this topic.
Thank you
--
View this message in context:
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13865352
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: puntapari [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 3:38 PM
To: mysql@lists.mysql.com
Subject: Re: IMAGES/PICTURES-MYSQL
Hodren
How are you storing the image in MySQL..I assume longblob?
What format will you use to display the image {jpg|gif|png}?
Here is a script which will load the images to your AS movie
http://www.actionscript.org/forums/showthread.php3?t=76421
HTH/
Martin
This email message and any files
On Thursday 20 July 2006 07:19 am, Nicholas Vettese wrote:
img_idINTNOT NULL auto_increment PRIMARY KEY,
user_id INTNOT NULL,
location VARCHAR(255) NOT NULL,
imgtype VARCHAR(20) NOT NULL,
img_tag VARCHAR(50) NOT NULL,
img_rate VARCHAR(20) NOT NULL,
good
img_comments
Hi,
Have you try google ?
http://www.google.fr/search?hl=frq=storing+image+in+mysqlbtnG=Recherche+Googlemeta=
I see pretty much a lot of stuff there ;)
btw, storing image in a table in considering a bad practice, let the
filesystem handle it it does it more efficiently. I would suggesdt to
write
Dear member,you can visit:
http://dev.mysql.com/doc/connector/j/en/index.html
http://dev.mysql.com/doc/mysql/en/php.html
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing
From: GH [EMAIL PROTECTED]
I was wondering how to get images into and out of a Mysql database
was told it was possible.
I have mysql 4.0.18
The general opinion is that files should be stored in a file system and not
a database. There are circumstances that you might want to store binary
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy to
replicate, stream, etc..
On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote:
From: GH [EMAIL PROTECTED]
I was wondering how to get
Is there anything special in your setup that you did to have such good
performance?
On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx [EMAIL PROTECTED] wrote:
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy to
Separate/dedicated servers for web/database. All the data was
chunked to allow faster streaming/lower overhead (large
images/files).. If you have more specific questions I can answer
them..
On Tue, 28 Sep 2004 11:49:27 -0400, GH [EMAIL PROTECTED] wrote:
Is there anything special in your
AM
To: GH
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: Images
Separate/dedicated servers for web/database. All the data was
chunked to allow faster streaming/lower overhead (large
images/files).. If you have more specific questions I can answer
them..
On Tue, 28 Sep 2004
, September 28, 2004 8:54 AM
To: GH
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: Images
Separate/dedicated servers for web/database. All the data was
chunked to allow faster streaming/lower overhead (large
images/files).. If you have more specific questions I can answer
them
you have.
Thanks,
Ed
-Original Message-
From: DreamWerx [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 8:54 AM
To: GH
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: Images
Separate/dedicated servers for web/database. All the data
-Original Message-
I have heard also that it helps to keep the table with the blobs having a
low number of fields. Like just a primary key and the blob field. Have
all your other metadata in a seperate table. Especially if you are going
to be occasionally doing queries of just the
: DreamWerx; [EMAIL PROTECTED]
Subject: Re: Images
Grabbing the file was 38 times faster because MySQL was not designed
to be a filesystem. There are filesystems out there specifically
designed to handle hundreds of thousands of small files. One of the
best is ReiserFS http://www.namesys.com
appreciate any ideas or recommendations you have.
Thanks,
Ed
-Original Message-
From: DreamWerx [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 8:54 AM
To: GH
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: Images
Separate/dedicated servers for web
It would be quite easy to drop a squid or similar proxy infront to
cache the db images in memory and deliver them for a set cache-time or
something.. That would be 1 way to boost performance..
On Tue, 28 Sep 2004 09:55:54 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
-Original Message-
I
Ok... I have some more test results. After optimizing as much as I can
think of, without using caching, I've gotten things down to a 13x
difference. Using Apache's ab performance test, the image comes from a file
at an average of 2ms and from the database (using PHP4) at an average of
28ms.
I
Thanks for the article. I'll check it out.
Throughput of 4600K/s is great. How's latency?
-Ed
-Original Message-
So if the image was say 200K in size, the metadata for the image would
be 1 row in a table, and the image data would be 4 rows in the data
table. 3 full 64K rows + 1
I thank you all for this discussion... and for the great information
that everyone has provideded. Next question (which is part of my
original) how do I actually get the images into the Blobs...
Additionally, the what are the names and capacities of the datatypes
that I could use? I have been
Great .. I don't have any numbers.. but basically there is quite
little latency using the FTP interface, data is streamed in and out of
mysql on the fly, inserting and selecting blocks of rows.. The FTP
server is written in java using JDBC to talk the database, so it's
quite fast.
On Tue, 28
Getting images/files into blob is quite easy.. examples could be
provided based on what lanaguge/interface way you want to use...
Mysql site has a great list of data types and capacities, etc... do a
search for it..
On Tue, 28 Sep 2004 13:58:16 -0400, GH [EMAIL PROTECTED] wrote:
I thank you
Ed brings up a great point... i would rather not have anyone
'searching' for images in directories and such...
On Tue, 28 Sep 2004 10:53:01 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
Ok... I have some more test results. After optimizing as much as I can
think of, without using caching, I've
I read through the article and ran some more tests. The new scripts and
tables provide similar initial latency, but I think the test results show
them to be faster overall.
When it comes to latency, direct file access is still the champion without
caching. I think you made a good point about
It is possible but not very logical. MySQL isn't a filesystem. Unless
you have an extreme situation you should store the path in MySQL and
the image itself in a file.
--
Eric Bergen
[EMAIL PROTECTED]
On Mon, 27 Sep 2004 18:20:02 -0400, GH [EMAIL PROTECTED] wrote:
I was wondering how to get
I would recommend storing the images on the filesystem and put the
information about those images (along with the path to the image) in MySQL.
If you plan to have lots of images, implement a nice logical directory
structure to keep them in as in my experience linux ext2/3 is fast
reading/writing
Read this article for it's design on database storage.. I have several
big implementations on this design which are fast, reliable and scalable
(one of them in the medical field aswell)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Sun, 1 Feb 2004, Yuri Oleynikov wrote:
Hi everyone,
Richard Bewley wrote:
Yes, you can insert the binary into a table.
Richard
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 1:42 PM
To: MySQL List
Subject: Images in a table
If your application is WWW based I've done some notes for students
I would be pleased.
Thanks
Glenn Stauffer [EMAIL PROTECTED] wrote:
Zenzo wrote:
How can I insert images in a table if I can do it with MySQL?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
I can send you some simple code to do
Here is a sample code in PHP:
$image = file_get_contents('/tmp/my_image.png');
$res = mysql_query('insert into img_table ( data ) values
(\''.addslashes($image).'\')');
Works with a table like:
create table img_table (bigint not null auto_increment primary key, data
LONGBLOB not null
Be warned about hitting the default max_packet_size limitation of mysql
which will cause large files to not insert.
This link shows another way to overcome that limitation:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Mon, 1 Dec 2003, Mickael Bailly wrote:
Here is a sample code in
Yes, you can insert the binary into a table.
Richard
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 1:42 PM
To: MySQL List
Subject: Images in a table
How can I insert images in a table if I can do it with MySQL?
The most common problem in such cases is that the webserver doesn't know
what MIME Type the file is and so it doesn't know how to send it.
If you are using PHP to upload and later show that image on the web, i
could give you the code for the scripts and the structure of the table
containg the
Hi
The most common problem in such cases is that the webserver doesn't know
what MIME Type the file is and so it doesn't know how to send it.
If you are using PHP to upload and later show that image on the web, i
could give you the code for the scripts and the structure of the table
containg
Checkout: http://php.dreamwerx.net/forums/viewtopic.php?t=6
It's got streaming code..
What I do is if the type is unknown I always send application/octet-stream
and the browser usually identifies it..
Or check the file extension for the file in the database, and apply
content type based on
sure you can. And i don't mind you disagreeing with me either =)
Although, if the solution/site is meant to be used by other than people
who know something about the webserver i don't think it's a good solution.
I can imagine writing something that reads the htaccess-file and edits
it... but i
-recipients:; no To-header on input
Cc: [EMAIL PROTECTED]
Subject: Re: images with mysql
sure you can. And i don't mind you disagreeing with me either =)
Although, if the solution/site is meant to be used by other than people
who know something about the webserver i don't think it's a good solution
Not an issue since you don't need to edit the htaccess file for every file.
You set it for the whole directory.
The only reason for preventing ppl to access files would be theft of
bandwith. If you worry about ppl being able to get the images then you
shouldn't publish them at all. You can't
Hi!
I have a problem with my MySQL
I need to have some a images related with an item
for example
--
! author ! date of birth an death ! image!
--
How can I define the field for the images? I have read that
a bit.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 20 March 2003 09:34
To: [EMAIL PROTECTED]
Subject: Re: images with mysql
Hi!
I have a problem with my MySQL
I need to have some a images related with an item
for example
I am now having a database storing images of chinese characters for research purpose.
I wrote a program to store and retrieve them. My images are of type ppm. This is how I
designed my table:
mysql describe poor;
+++--+-+-+---+
| Field | Type
IMHO it's better to store a link.
I have seen databases (not MySQL) getting corrupted because the file
inserted was to big.
For the visitor it doesn't really matter whether you put it into the
database or not. A link is less difficult and you don't have to retrieve
pictures from the database
Well, this may be off topic.
In my case, I store tens of thousands of images, gradually growing. All of them are
quite small, most around 30*30 gray scale. Would it still be faster to store them on
disk?
On Thu, 20 Mar 2003 13:57:06 +0100
B. van Ouwerkerk [EMAIL PROTECTED] wrote:
IMHO it's
Lai Liu-yuan wrote:
Well, this may be off topic.
In my case, I store tens of thousands of images, gradually growing. All of them are
quite small, most around 30*30 gray scale. Would it still be faster to store them on
disk?
In most cases yes. We have over 3.5 million images stored and
I assume it is, have not tested it..
If you need to fetch the files from the database your app needs to wait
until it has recieved the data. If you only store name/path info it will
take less time to fetch the data, ship it off to the browser which can
start fetching the images without
hey all.. new to the list.
Just my 5 cents...
I think it's better to store images in the database, sure you loose a bit
in performance, but it's easier to code.
The way i've done it before is always a separate render.php (or what ever)
that compares the users rights to view that image, get's the
You can use other ways to protect your images from linking by others. Like
with Apache and htaccess..
I don't agree with you on your opinion that it's easier to code. If you
insert a link into your database all you have to do is retrieve it and push
the link to the browser.
B.
At 20:18
Eric,
Generally you would store references to the images in the database as a full
or partial
pathname.
You can store binary data in the db itself using the BLOB type but this is
not necessarily
the most efficient approach to take
John Lodge
-Original Message-
From: Eric Torr Klopper
From: Neil Davies [mailto:[EMAIL PROTECTED]]
I was wondering if it's possible to place image files within mysql
tables?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_15_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
yes but not advisable. Check the archives for more info.
Cal
http://www.calevans.com
-Original Message-
From: Neil Davies [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 03, 2001 10:28 AM
To: [EMAIL PROTECTED]
Subject: images
I was wondering if it's possible to place image files
This topic has been discussed many times on the PHP General (archived at
http://marc.theaimsgroup.com/?l=php-general) and PHP DB (archived at
http://marc.theaimsgroup.com/?l=php-db) mailing lists.
Search the archives for the terms 'MySQL images blob' and you will find a
wealth of posts.
Good
54 matches
Mail list logo
