SQLite support in Postfix

2010-06-18 Thread Wietse Venema
Last weekend I talked with one of the creators of SQLite and was impressed by the thoroughness of their code quality process. I brushed up a patch that was circulated two years ago and spent a day or so adding error checks and updating documentation. Right now this is a read-only implementation

Re: SQLite support in Postfix

2010-06-18 Thread Patrick Ben Koetter
* Wietse Venema : > Last weekend I talked with one of the creators of SQLite and was > impressed by the thoroughness of their code quality process. > > I brushed up a patch that was circulated two years ago and spent > a day or so adding error checks and updating documentation. > > Right now thi

Re: SQLite support in Postfix

2010-06-18 Thread Victor Duchovni
On Fri, Jun 18, 2010 at 05:58:02PM +0200, Patrick Ben Koetter wrote: > > Right now this is a read-only implementation (like mysql/pgsql) > > but it may be worthwhile to add update support. SQLite implements > > locking internally. That would allow us to avoid the problems with > > Postfix's extern

Re: SQLite support in Postfix

2010-06-18 Thread Brian Evans - Postfix List
On 6/18/2010 12:07 PM, Victor Duchovni wrote: On Fri, Jun 18, 2010 at 05:58:02PM +0200, Patrick Ben Koetter wrote: Right now this is a read-only implementation (like mysql/pgsql) but it may be worthwhile to add update support. SQLite implements locking internally. That would allow us to avoid

Re: SQLite support in Postfix

2010-06-18 Thread Wietse Venema
Victor Duchovni: > On Fri, Jun 18, 2010 at 05:58:02PM +0200, Patrick Ben Koetter wrote: > > > > Right now this is a read-only implementation (like mysql/pgsql) > > > but it may be worthwhile to add update support. SQLite implements > > > locking internally. That would allow us to avoid the problem

Re: SQLite support in Postfix

2010-06-18 Thread Rob Foehl
On Fri, 18 Jun 2010, Victor Duchovni wrote: Indeed. One still needs tools to insert data into the database. Does Postfix need to provide a minimal interface for this, or do we assume that SQLite users will have adequate tools outside Postfix. It wouldn't hurt to omit this support for the time

Re: SQLite support in Postfix

2010-06-18 Thread Patrick Ben Koetter
* Wietse Venema : > Victor Duchovni: > > On Fri, Jun 18, 2010 at 05:58:02PM +0200, Patrick Ben Koetter wrote: > > > > > > Right now this is a read-only implementation (like mysql/pgsql) > > > > but it may be worthwhile to add update support. SQLite implements > > > > locking internally. That would

Re: SQLite support in Postfix

2010-06-18 Thread Ralf Hildebrandt
* Patrick Ben Koetter : > > A "postmap" option to create an SQLite file would make sense. > > Do you mean creating an SQLite database from a flat file that, for example, > contains access rules mapping addresses to actions (r...@foo REJECT)? > > What if there were many files that wanted to be

Re: SQLite support in Postfix

2010-06-18 Thread Wietse Venema
Rob Foehl: > On Fri, 18 Jun 2010, Victor Duchovni wrote: > > > Indeed. One still needs tools to insert data into the database. > > Does Postfix need to provide a minimal interface for this, or do we > > assume that SQLite users will have adequate tools outside Postfix. > > It wouldn't hurt to omi

Re: SQLite support in Postfix

2010-06-18 Thread Wietse Venema
Patrick Ben Koetter: > * Wietse Venema : > > Victor Duchovni: > > > On Fri, Jun 18, 2010 at 05:58:02PM +0200, Patrick Ben Koetter wrote: > > > > > > > > Right now this is a read-only implementation (like mysql/pgsql) > > > > > but it may be worthwhile to add update support. SQLite implements > > >