Full Text Search

Gordan Bobic <[email protected]>
Newsgroups gmane.mail.imap.dbmail
Message-ID <[email protected]>
Hi,

I am due to be upgrading my mail server soon. I am currently using 
dbmail (old 2.2.x).

The question I am currently trying to answer is whether in the past few 
years dbmail has gained the advantage of being able to use full text 
search capabilities of the modern RDBMSes. Back when I deployed, it was 
the most sensible choice in terms of easy backups and near real-time 
replication since those features were enabled through the use of MySQL.

Today, we have stable ZFS implementations on most UNIX-like OS-es, which 
facilitates easy local snapshotting without a performance impact and 
easy backups using zfs-send. There are also alternatives such as lsyncd 
for efficient asynchronous near real-time remote backups. All of this 
makes Maildir a much more workable option than it was 8 years ago.

So the feature it all really comes down to is leveraging the DB's FTS 
for really fast mail searching. I found this wiki entry from 3 years ago:

http://www.dbmail.org/dokuwiki/doku.php/bodysearch

but have been unable to find anything saying that this has been 
implemented since.

If anybody could please clarify whether this feature now exist I would 
really appreciate it.

TIA.

Gordan
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.