Greetings!
Quick background: i have extensive RDBMS experience (sybase, progress)
but have been "out of the loop" in this field for a few years working
as a sys-admin for a linux/unix-based ISP in Canada.
We want to host a web-based resource center powered on the backend by an
RDBMS. Documents to be displayed on this web site may take many forms:
adobe, text and word processing documents, digitized images, hyperlinks,
video and audio clips, etc. Text-based documents must be indexed and
searchable by keywords entered by users.
I would be interested in your experiences with MySQL in this respect.
Specifically I'm trying to determine the following:
1. would text (word, excell, adobe, etc) be stored directly in the
database? If not, how would they referenced?
2. what about other document types (mgp, jpg, streaming-video, audio).
3. can text-based documents be indexed directly for quick searches?
If not, do i need to manually index them via descriptor fields of some
sort?
4. what 'connective' software could be used to create web-based forms
that can both query the database to retrieve documents?
5. what would be the best software to use to create "input" forms to
allow documents to be added/updated/deleted?
6. Most importantly, how well does MySQL handle this kind of
application, as opposed to proprietary DBs like Sybase, Oracle and
Progress?
/pete
--------------------------------------------------------------------
Pete Koning [EMAIL PROTECTED]
System Administrator Ph: 905.528.4936
Hamilton-Wentworth CommunityNet Fx: 905.528.7578
--------------------------------------------------------------------
Cat philosophy #2: Bite the hand that doesn't feed you fast enough.
--------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
