Solved

Full Text Search through files

Posted on 2004-08-07
3
133 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now