how to save image in postgreSQL database

[Ram]

hello everyone i am studying python for my college project in which i
am sending some text and image in URL i want to store it to postgreSQL
database i know how to read data from URL but not about images how can
i perform it please help.

[Simon Connah]

Don't.

Save the filesystem path or some other URI to the image in the database and then use that in your code to get the image itself. Saving images directly in the database is a bad idea.

Simon.

[AJ]

As Simon mentioned that it is a bad idea and I agree but just for the answer's sake you could save them as BLOBs

http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html

Am I correct folks?

-AJ

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django...@googlegroups.com.
To unsubscribe from this group, send email to django-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--
AJ

[ramnivas indani]

ok thanks, is there any online tutorial for that from where i can learn about URI?

[Eric Chamberlain]

Storing BLOBs in postgres can be a pain and storing the images locally doesn't scale well. We ended up using django-storages.

[Simon Connah]

On 19 May 2011, at 20:38, ramnivas indani wrote:

> ok thanks, is there any online tutorial for that from where i can learn about URI?

This is a good introduction to the subject:

http://en.wikipedia.org/wiki/Uniform_Resource_Identifier

Simon.

[ramnivas indani]

ok but how can i achieve it in Django means how can i store images in Django python using URI 

[Mateusz Marzantowicz]

On Fri, May 20, 2011 at 3:00 AM, ramnivas indani <ram....@gmail.com> wrote:

ok but how can i achieve it in Django means how can i store images in Django python using URI 

Read Django documentation (it is part of studying in college):

* http://docs.djangoproject.com/en/1.3/topics/http/file-uploads/

* http://docs.djangoproject.com/en/1.3/ref/models/fields/#filefield

* http://docs.djangoproject.com/en/1.3/ref/models/fields/#imagefield