Solved

Full Text Search through files

Posted on 2004-08-07
3
136 Views
Last Modified: 2010-04-05
I am developing a chat server that archives all messages.  I am looking for a low cost solution for full-text searching through the chat archive that will integrate into the server application.

I am currently storing the data in files, one per chat message.  I would consider putting the files in a database, if there were a low cost database that supports full-text searching.  

Any thoughts on how to accomplish this?

To Clarify:

"Full-text search" - the ability to obtain a list of files containing a given word or phrase, subject to pattern matching and boolean operations.

"Low Cost" - Less than $50 per server, or a fixed price solution of $500 max.
0
Comment
Question by:wolsen
3 Comments
 
LVL 7

Accepted Solution

by:
sftweng earned 70 total points
ID: 11745257
0
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 11749175
Ever considered Firebird, the free InterBase clone? I believe it supports full text search...

http://firebird.sourceforge.net/

It might not be the fastest solution but it's free and well-supported by Borland.
0
 

Expert Comment

by:Wyverex
ID: 11751746
How about MySQL? It's free and AFAIK it supports full-text search.

Dont' know whether there is a delphi interface though. But you should
be able to make DLL calls like using a C DLL.

regards,
Wyverex
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question