opendkim-2.5.0.Beta1 & sqlite3

From: Andreas Schulze <sca_at_andreasschulze.de>
Date: Sun, 13 Nov 2011 23:47:27 +0100

Hi all,

I currently try to use sqlite3 as statistics db.

For now, there are 2 problems to solve in stats/opendkim-import-stats:

1. mysql knows LAST_INSERT_ID
   sqlite3 uses LAST_INSERT_ROWID
   this I solved with a simple patch

2. the code is written to do timeconvertions in the select statement using from_unixtime
   This function is spcific for mysql.
   http://devpit.org/wiki/Portable_SQL#WHERE suggests not to use from_unixtime inside select but
   outside the SQL statement.

I dont know, What the next problems will be, but I like to try it...
I wrote a stats/mkdb.sqlite3...

-- 
########################################################################
#
# Andreas Schulze
# https://andreasschulze.de
# 
# GnuPG Key-ID: A7DBA67F, https://andreasschulze.de/sca.asc
# GnuPG Fingerprint: 14C1 39A8 CE6D 6BE0 28C6 5652 03B5 6793 A7DB A67F
#
# $Id: .signature,v 1.3 2007-12-27 21:13:36 sca Exp $
########################################################################

Received on Sun Nov 13 2011 - 22:47:50 PST