On 20-05-2012 19:00, Jerry wrote:
On Sun, 20 May 2012 10:13:45 -0500 /dev/rob0 articulated:
On Sun, May 20, 2012 at 08:11:33AM -0400, Jerry wrote:
On Sun, 20 May 2012 06:35:46 -0500 Stan Hoeppner articulated:
On 5/20/2012 6:19 AM, Jerry wrote:
seems like it could potentially be a very useful feature. I have used it myself when a full blown MySQL configuration seemed like over-kill on other small projects.
SQLite is the appropriate solution for this scenario.
Requires loading another application when it is not necessary.
What application in particular? SQLite is a file format, not a daemon. Both Dovecot and Postfix support it well (in the latter case, use at least 2.8.9 or 2.9 due to a bug.)
sqlite3(1) is the console client for SQLite. You can use that or any other SQLite client to maintain your database file.
My own sordid SQLite mail server howto is linked at the .sig site.
What I meant was that "SQLite" would have to be installed on the system. As far as I know, it is not; although MySQL is. I just talked to my friend and he told me the problem was that the owner of the company was/is afraid of damaging the databases presently in use. We are going to assure him that no such thing will happen and hopefully put his mind at ease. At present all of their mail is handled by a third party and they want to now handle it all in house.
I still think that supporting Berkeley DB is a worthwhile goal; however that is my own 2¢.
SQlite is only 61Kb, no config is needed
If you start using MySQL, and the MySQL-database is changed because of some upgrades to the system that currenly uses it, it might have an impact on your mail-system....
For that 2 cents, i would install SQlite!
#> zypper info sqlite3 Information for package sqlite3:
Repository: openSUSE-12.1-Oss Name: sqlite3 Version: 3.7.8-1.1.2 Arch: x86_64 Vendor: openSUSE Installed: Yes Status: up-to-date Installed Size: 61.0 KiB Summary: Embeddable SQL Database Engine Description: SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. SQLite is not a client library used to connect to a big database server. SQLite is a server and the SQLite library reads and writes directly to and from the database files on disk. SQLite can be used via the sqlite command line tool or via any application that supports the Qt database plug-ins.