image storing

On Fri, 6 Oct 2000, Adam Lang wrote:

Has anyone setup a postgres server that stores the location of images (or
any file) and is accessed by a windows based client? In particular postgres
running on a non-windows OS.

Yes, but the access was via a web browser interface. I just stored the
pathnames in the database. I had postgres running on a Linux box, and the
images themseleves were on a RAID served through Novell, then converted
into PDF images and stored on another RAID served through Linux. If you
set up Samba, you could still get to the images even if they were on a
Linux box, but the web browse interface (using Perl as the development
langauge) was by far the easier to use for building an application.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
design, v.:
What you regret not doing later on.

Yeah, that is what I was thinking... except I would like to keep the
existing Access front end... And the front end displays the pathnames as a
"hyperlink" data type. I figure I'll have to change that to a string...
just not sure how to keep it so they can just "click" on it and display the
file.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: <bmccoy@chapelperilous.net>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Friday, October 06, 2000 2:09 PM
Subject: Re: [GENERAL] image storing

On Fri, 6 Oct 2000, Adam Lang wrote:

Has anyone setup a postgres server that stores the location of images

(or

any file) and is accessed by a windows based client? In particular

postgres

running on a non-windows OS.

Yes, but the access was via a web browser interface. I just stored the
pathnames in the database. I had postgres running on a Linux box, and the
images themseleves were on a RAID served through Novell, then converted
into PDF images and stored on another RAID served through Linux. If you
set up Samba, you could still get to the images even if they were on a
Linux box, but the web browse interface (using Perl as the development
langauge) was by far the easier to use for building an application.

Brett W. McCoy

http://www.chapelperilous.net

--------------------------------------------------------------------------

-

On Fri, 6 Oct 2000, Adam Lang wrote:

Yeah, that is what I was thinking... except I would like to keep the
existing Access front end... And the front end displays the pathnames as a
"hyperlink" data type. I figure I'll have to change that to a string...
just not sure how to keep it so they can just "click" on it and display the
file.

Hmmm... That's going to be the trick, I think. Yeah, I just stored the
pathnames as strings. In fact, we had people doing DP to this database
with Access, now that I think about it, but they didn't use Access to view
the images, just manipulate the data. Hyperlink data type.... sheesh!
I'm not sure the tool you use to do data processing should also double up
as a web browser! That'd be like using a word processor to do graphic
design...

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Hlade's Law:
If you have a difficult task, give it to a lazy person --
they will find an easier way to do it.

Well, it doesn't load the link in itself, it launches the appropriate
application to view it.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: <bmccoy@chapelperilous.net>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Friday, October 06, 2000 2:50 PM
Subject: Re: [GENERAL] image storing

On Fri, 6 Oct 2000, Adam Lang wrote:

Yeah, that is what I was thinking... except I would like to keep the
existing Access front end... And the front end displays the pathnames as

a

"hyperlink" data type. I figure I'll have to change that to a string...
just not sure how to keep it so they can just "click" on it and display

the

file.

Hmmm... That's going to be the trick, I think. Yeah, I just stored the
pathnames as strings. In fact, we had people doing DP to this database
with Access, now that I think about it, but they didn't use Access to view
the images, just manipulate the data. Hyperlink data type.... sheesh!
I'm not sure the tool you use to do data processing should also double up
as a web browser! That'd be like using a word processor to do graphic
design...

Brett W. McCoy

http://www.chapelperilous.net

--------------------------------------------------------------------------

-

But I think that hyperlinks would be a good addition to data types
repertoire to pgsql. Maybe not for the database to be used as web browser
(that was a funny comment, sorry if it were not intended to be so), but for
serving a sites database, for example.

On Fri, 6 Oct 2000, Adam Lang wrote:

Yeah, that is what I was thinking... except I would like to keep the
existing Access front end... And the front end displays the pathnames as

a

"hyperlink" data type. I figure I'll have to change that to a string...
just not sure how to keep it so they can just "click" on it and display

the

On Fri, 6 Oct 2000, Efrain Caro wrote:

But I think that hyperlinks would be a good addition to data types
repertoire to pgsql. Maybe not for the database to be used as web browser
(that was a funny comment, sorry if it were not intended to be so), but for
serving a sites database, for example.

I'm not sure I follow you. How would something like this be used in
PostgreSQL, as an example, as opposed to using a string and printing it to
the web browser screen via a CGI script/PHP/Mason/JSP/ASP/etc? A
hyperlink is just a URL/URI inside a "<a href=""></a>" tag, right?

Yes, the comment was intended to be funny. :-)

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
The hope that springs eternal
Springs right up your behind.
-- Ian Drury, "This Is What We Find"

But I think that hyperlinks would be a good addition to data types
repertoire to pgsql.

And how would the behavior of such a datatype differ from, for
example, a text datatype? My interpretation would be that if the
consumer of the data wants to display it as a hyperlink, fine, but
that that is the job of the application not the database. Am I
missing something?

Cheers,
Brook

Brook Milligan wrote:

But I think that hyperlinks would be a good addition to data types
repertoire to pgsql.

And how would the behavior of such a datatype differ from, for
example, a text datatype? My interpretation would be that if the
consumer of the data wants to display it as a hyperlink, fine, but
that that is the job of the application not the database. Am I
missing something?

there are a bunch of data types like this that might be interesting to
some people. some of the reasons that you might want a data type like
this are verification that a URL is valid and the ability to search the
URL's by hostname, protocol, etc. i can't say that i'd be that
interested in it, but that shouldn't stop somebody from thinking about
doing something like this.

--

Jeff Hoffmann
PropertyKey.com

On Fri, 6 Oct 2000, Adam Lang wrote:

Has anyone setup a postgres server that stores the location of images (or
any file) and is accessed by a windows based client? In particular postgres
running on a non-windows OS.

Check the ImageViewer example in the source
(src/interfaces/jdbc/example/ImageViewer.java

It works fine under Windows, and stores the images on a postgresql
database under Unix ;-)

Peter

--
Peter T Mount peter@retep.org.uk http://www.retep.org.uk
PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
Java PDF Generator http://www.retep.org.uk/pdf/

Will take a look at it, thanks.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Peter Mount" <peter@retep.org.uk>
To: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: "PGSQL General" <pgsql-general@postgresql.org>
Sent: Monday, October 09, 2000 7:41 AM
Subject: Re: [GENERAL] image storing

On Fri, 6 Oct 2000, Adam Lang wrote:

Has anyone setup a postgres server that stores the location of images

(or

any file) and is accessed by a windows based client? In particular

postgres