Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

text/image files - in the DB or store as files with locations in DB?

3 posts in General Discussion (old) Last posting was on 2000-02-29 03:43:16.0Z
Joseph M. Beckman Posted on 2000-02-28 04:01:42.0Z
Newsgroups: sybase.public.easerver
Date: Sun, 27 Feb 2000 22:01:42 -0600
From: "Joseph M. Beckman" <josephmb@techie.com>
Reply-To: josephmb@techie.com
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: text/image files - in the DB or store as files with locations in DB?
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
NNTP-Posting-Host: 207-172-150-248.s57.as11.anp.md.dialup.rcn.com 207.172.150.248
Message-ID: <347_38B9F326.A309FC3@hotmail.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27845
Article PK: 159551

 
Greetings,

I'm running SYBASE ASE 11.9, Power Dynamo 3.5 - I want to manage some text files & images. Users are allowed to submit/delete, and the web site serves the text & images up in various places.

Is there an advantage to keeping them as files & just keeping the location (path/filename) in the DB?

What is the best way of accepting the files and inserting them into the DB or writing to the fileserver - the users are accessing everything through the web site (intranet), and I would prefer not to have a separate application interface for them to submit files.

Thanks in Advance,

Nikki


Dean Jones [Team Sybase] Posted on 2000-02-29 03:43:16.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: text/image files - in the DB or store as files with locations in DB?
Date: Mon, 28 Feb 2000 21:43:16 -0600
Lines: 117
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_00ED_01BF8234.D217AB20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dsl131.outtech.com 216.207.145.131
Message-ID: <347_staqkfmg$GA.251@forums.sybase.com>
References: <347_38B9F326.A309FC3@hotmail.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27580
Article PK: 158955

One advantage to storing in a database is it allows multiple web server and application servers to access the file.
 
If you simply link it in html only one web server could access the file.
 
Also putting in a database allows you to control security better, i.e., all requests for images must come from a dynamic page allowing you to verify who is requesting the file and whether they have rights to see the file they are requesting.
 
HTH

--

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.
http://www.powerobjects.com
 
 
Joseph M. Beckman <josephmb@techie.com> wrote in message news:38B9F326.A309FC3@hotmail.com...
 
Greetings,

I'm running SYBASE ASE 11.9, Power Dynamo 3.5 - I want to manage some text files & images. Users are allowed to submit/delete, and the web site serves the text & images up in various places.

Is there an advantage to keeping them as files & just keeping the location (path/filename) in the DB?

What is the best way of accepting the files and inserting them into the DB or writing to the fileserver - the users are accessing everything through the web site (intranet), and I would prefer not to have a separate application interface for them to submit files.

Thanks in Advance,

Nikki


Dave Appleton Posted on 2000-02-25 13:43:06.0Z
Newsgroups: sybase.public.easerver
From: "Dave Appleton" <dave@calistra.com>
Subject: Re: text/image files - in the DB or store as files with locations in DB?
Date: Fri, 25 Feb 2000 21:43:06 +0800
Lines: 89
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01BF7FD9.4CB98280"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: ad202.166.110.184.magix.com.sg 202.166.110.184
Message-ID: <347_WTvYmb5f$GA.265@forums.sybase.com>
References: <347_38B9F326.A309FC3@hotmail.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27818
Article PK: 159165

If you store the image in a file the image will be stored in the user's cache when they load the page. If this is an issue you will need to store it in the Database - but remember to store it as a file Image (JPG / GIF) if you are doing multiplatform since the Image Object is platform dependant. You can convert to Image using Toolkit.createImage();
 
Joseph M. Beckman <josephmb@techie.com> wrote in message news:38B9F326.A309FC3@hotmail.com...
 
Greetings,

I'm running SYBASE ASE 11.9, Power Dynamo 3.5 - I want to manage some text files & images. Users are allowed to submit/delete, and the web site serves the text & images up in various places.

Is there an advantage to keeping them as files & just keeping the location (path/filename) in the DB?

What is the best way of accepting the files and inserting them into the DB or writing to the fileserver - the users are accessing everything through the web site (intranet), and I would prefer not to have a separate application interface for them to submit files.

Thanks in Advance,

Nikki