DBMail is an open-source project that enables storage of mail messages in a relational database.
Currently MySQL, PostgreSQL, Oracle, and SQLite can be used as storage backends.
Commercial development and support is also available.
What are the advantages?
- Scalability
- Dbmail is as scalable as the database system used for storage.
- Manageability
- Dbmail can be managed by updating the relational database or directory service - without shell access.
- Speed
- Dbmail uses very efficient, database specific queries for retrieving mail information.
- Security
- Dbmail doesn't require filesystem access. It's as secure as the database and directory server used.
- Flexibility.
- Changes in a Dbmail system (adding of users, changing passwords etc.) are effective immediately. Users can be stored in the database, or managed separately in an LDAP server such as OpenLDAP or Active Directory.
How does it work?
DBMail is made up of several components. A normal MTA (Postfix, SendMail, QMail, Exim) is used for accepting messages. The MTA hands the messages over to dbmail-deliver, using a pipe interface, or to dbmail-lmtpd, using LMTP (Local Mail Transport Protocol).
These programs take care of injecting the message into the database. Messages can be retreived from the database using dbmail-pop3d, using the POP3 protocol, or dbmail-imapd, using the IMAP4Rev1 protocol.
Emails are stored in the database. This includes attachments. User information is also stored in the database, so users do not need a system account on machines DBMail is running on.
Components
Available
DBMail is primarily developed and tested on the GNU Linux and FreeBSD platforms. Users have also reported successfull deployments on OpenSolaris, NetBSD and OSX.
DBMail is released under the GNU Public Licence (version 2).
Blog
- What's up with max_db_connections?
- 2013-12-05
- Migrating from MySQL to PostgreSQL
- 2012-09-13
- Pruning the dbmail_headervalue table
- 2010-02-13
Recent changes
master branch
- add helper script to dump backtrace on busy threads
- 2014-03-07
add helper script to dump backtrace on busy threads
- fixed copyright and old version info on schema files
- 2014-03-04
fixed copyright and old version info on schema files
- Fixed critical spinlock when appending empty string
- 2014-03-04
Fixed critical spinlock when appending empty string
3.1 stable branch
- version 3.1.12
- 2014-03-05
version 3.1.12
- fixed copyright and old version info on schema files
- 2014-03-04
fixed copyright and old version info on schema files
- Fixed critical spinlock when appending empty string
- 2014-03-04
Fixed critical spinlock when appending empty string