[WEB4LIB] Seeking advice on full-text DBs for the web

[TMGB]

Zope ( http://www.zope.org ) would probably work well in this
situation.  I am using Zope with PostgreSQL ( http://www.postgresql.org/
) database on the backend.  Zope can connect to PostgreSQL, MySQL,
Oracle, Sybase, and other databases.  Zope can run as a standalone
server or a CGI server for Apache.  Zope runs on Linux, NT, and others. 
Zope is Object Oriented based on the Object Oriented scripting language
Python.

Sample: This sample was put together quickly (took about 30-45 minutes
after receiving the original database in MS Access form) only for
testing purposes and does not utilize a python script I added that
escapes the single quote in text field searches.  If you do a search on
this page with a single quote in the search term precede it with \ . 
Search an early release of Net Library titles accessible through North
Carolina's NC Live program at : 

http://linux.library.appstate.edu:8080/Zope_Server/reference/nclive/netlibrary/


The database consists of 10,687 records.  There are 8 fields in each
record.

You may try a random search or search using info from the last record in
the database.  Granted with the holidays here and not as much load on
the server as normal, I brought this record up, searching the Dewey
field, in less than 3 seconds.  The Zope server receives the submitted
form information transacts with the PostgreSQL server and returns the
result in html to the browser client.  

Last Record -

Title: Zuni children and elders talk together
Authors: "Kavasch E. Barrie"
Publisher: Rosen Publishing Group
Year: 1999
LCC: E99Z9 .K38 1999
Dewey: 306/.089/979 21
LCSH: Zuni children and elders talk together

Thomas



Dean Vellenga wrote:
> 
> Good Morning!
> 
> PLEASE NOTE:  I apologize for any cross-postings of this request you may see
> floating around out there on other listservs.
> 
> I am a new hire at a non-profit organization that plans to create an
> information system that can be searched by its members through the Internet
> (through a members-only setup).
> 
> The organization wishes for this system to function as a research tool for
> staff and members of the organization, as well as to serve as a
> “clearinghouse” type of database for its members.
> 
> I am currently looking at INMAGIC’s DB/TextWorks & DB/Text Web Publisher,
> because it was recommended to the organization before I was hired.  The
> package is attractive to us because it seems relatively simple to use and
> maintain, but we have some concerns about it being compatible with our
> Linux-based server (Web Publisher appears to be only available for NT), and
> our other databases.
> 
> I would like to hear from anyone who is using another software package (or
> combination of software packages) for this purpose.  Also, I am seeking
> recommendations from anyone who uses DB/Textworks & Web Publisher (positive
> or negative).
> 
> Thanks in advance for any advice.
> 
> Sincerely,
> 
> Dean K. Vellenga
> Information Specialist
> National Business Incubation Association
> Telephone:  740-597-1544
> Fax: 740-593-1996
> Email:  dvellenga at nbia.org
> WWW:  www.nbia.org

-- 
--------------------------------------------------------------------
                      Rock and Rule
             Zope Rocks -- http://www.zope.org
           Python Rules  -- http://www.python.org    
--------------------------------------------------------------------
Thomas McMillan Grant Bennett      Appalachian State University
Computer Consultant III            University Library
bennetttm at appstate.edu             
http://www.library.appstate.edu/webmaster/
Voice:  828 262 6587	           FAX:    828 262 3001

Windows 95 is a 32-bit extension to a 16-bit patch for an 8-bit
operating system that was originally coded for a 4-bit microprocessor.
 - Chris Dunphy     Boot Magazine