On Thu, 5 Apr 2001, Pete Koning wrote:
> 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?
>
You can have them in the DB as BLOBs, or you can have them as files on the fs, and
have the pathname in the DB
> 2. what about other document types (mgp, jpg, streaming-video, audio).
binary files, are binary files. I'd go for the fs solution for all binary data. Makes
them accessible by other applications if they are on the fs.
> 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?
Lookup the FULLTEXT at: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
> 4. what 'connective' software could be used to create web-based forms
> that can both query the database to retrieve documents?
I don't get exactly what 'connective software' means, but you can create your CGI
sitting behind your forms with just about anything you like. Take you pick: Perl, PHP,
C, C++, Python are ones I'm aware of.
> 5. what would be the best software to use to create "input" forms to
> allow documents to be added/updated/deleted?
>
Again I'm not clear. See above.
> 6. Most importantly, how well does MySQL handle this kind of
> application, as opposed to proprietary DBs like Sybase, Oracle and
> Progress?
It is a worthy competitor :-) Make what you want of it.
regards,
thalis
---------------------------------------------------------------------
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