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?
"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.