Mailing List Archive

Full Text Search
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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: Full Text Search [ In reply to ]
As far as I know there is no FTS at the moment in DBmail.

It would be possible to write some code to support a fulltext search
engine to dbmail but there is no work done yet.


Am .01.2015, 21:53 Uhr, schrieb Gordan Bobic <gordan@bobich.net>:

> 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
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


--
Harald Leithner

ITronic
Wiedner Hauptstraße 120/5.1, 1050 Wien, Austria
Tel: +43-1-545 0 604
Fax: +43-1-786 23 88 26
Mobil: +43-699-123 78 4 78
Mail: leithner@itronic.at | itronic.at
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail