Projects/PIM/MS Windows/SQLite Folder Indices - Revision history

Jstaniek: /* Important Commits */

2008-05-16T09:35:45Z

‎Important Commits

2008-05-08T08:58:45Z

2008-05-07T15:27:36Z

‎Installation

2008-05-07T15:24:55Z

‎Installation

2008-05-07T15:17:42Z

‎Installation

2008-05-07T15:13:09Z

2008-05-06T21:57:59Z

‎Status of porting to SQLite

2008-05-06T10:13:07Z

2008-05-06T10:06:53Z

‎Installation

2008-05-06T10:04:35Z

‎Introduction

@@ Line 160: / Line 160: @@
 *[http://websvn.kde.org/?view=rev&revision=804186 804186] - KMFolderIndex::updateIndex() - fix result checking of writeMessages() -fetching emails from (d)imap seems to work smoothly now (Mon May 5 09:51:46 2008 UTC)
 *[http://websvn.kde.org/?view=rev&revision=805075 805075] - changes related to the SQLite mode for KMail indices from /branches/work/kmail-nommap (r799390..804487) /branches/work/kdepim-nommap/kmail (r804484..804960) merged into trunk
-**'''See the page devoted to [[/merge|validation of the merege]]'''
+**'''See the page devoted to [[/merge|validation of the merege]]''' and the [[/merge#Results|results]].
 ==Open Questions==

@@ Line 159: / Line 159: @@
 *[http://websvn.kde.org/?view=rev&revision=803451 803451] - 'messages' table creation is now: "CREATE TABLE messages( id INTEGER PRIMARY KEY AUTOINCREMENT, data BLOB )" - added autoincremented 'id' PK column; updated all the code for this design; the value of ID column is now used for updating the dirty records (Fri May 2 22:12:35 2008 UTC)
 *[http://websvn.kde.org/?view=rev&revision=804186 804186] - KMFolderIndex::updateIndex() - fix result checking of writeMessages() -fetching emails from (d)imap seems to work smoothly now (Mon May 5 09:51:46 2008 UTC)
 ==Open Questions==

@@ Line 5: / Line 5: @@
 ==Installation==
-Update: commit 805075 merged changes related to the SQLite mode for KMail indices from /branches/work/kmail-nommap (r799390..804487) and /branches/work/kdepim-nommap/kmail (r804484..804960) back to trunk.
+Update (7 May 2008): commit 805075 merged changes related to the SQLite mode for KMail indices from /branches/work/kmail-nommap (r799390..804487) and /branches/work/kdepim-nommap/kmail (r804484..804960) back to trunk.
 '''Thus, it is enough to use kdepim trunk now.''' Users of kdepim-nommap should execute ''emerge --unmerge kdepim-nommap'' and then ''emerge kdepim''.

@@ Line 5: / Line 5: @@
 ==Installation==
-Update (7 May 2008): commit 805075 merged changes related to the SQLite mode for KMail indices
+Update: commit 805075 merged changes related to the SQLite mode for KMail indices from /branches/work/kmail-nommap (r799390..804487) and /branches/work/kdepim-nommap/kmail (r804484..804960) back to trunk.
 from /branches/work/kmail-nommap (r799390..804487) /branches/work/kdepim-nommap/kmail (r804484..804960).
 '''Thus, it is enough to use kdepim trunk now.''' Users of kdepim-nommap should execute ''emerge --unmerge kdepim-nommap'' and then ''emerge kdepim''.

@@ Line 5: / Line 5: @@
 ==Installation==
-''branches/work/kdepim-nommap'' branch has been created for SQLite mode, being synced with kdepim trunk. The only difference is kmail/ subdirectory. To build it on Windows:
+Update (7 May 2008): commit 805075 merged changes related to the SQLite mode for KMail indices
 #if you have already installed kdepim trunk, type 'emerge --unmerge kdepim'
 #update your emerge directory: 'cd {KDEROOT}', 'svn up emerge'
@@ Line 11: / Line 17: @@
 The last command will download the source code from the branch, with altered kmail/ source code, compile it and install. All the resulting files have the same names as in regular kdepim trunk. ''sqlite'' package will be also installed as a hard dependency of the ''kdepim-nommap'' package.
 ==Introduction==

@@ Line 1: / Line 1: @@
 There are issues with locking index files for KMail folders and mmap()/munmap() operations on Windows. Therefore, SQLite-based indices are in development. This page presents detailed development notes for this task.
-Started: [[User:Jstaniek|jstaniek]] 11:35, 23 April 2008 (CEST)
+Design and implementation started by [[User:Jstaniek|jstaniek]] 11:35, 23 April 2008 (CEST)
 __TOC__

@@ Line 109: / Line 109: @@
 |-
 |void KMFolderIndex::truncateIndex()
+|yes
+|yes
-|use "DELETE FROM..."
+|recreate the db
 |-
 |void KMFolderIndex::fillMessageDict()

@@ Line 10: / Line 10: @@
 #type 'emerge --update kdepim-nommap'
-The last command will download the source code from the branch, with altered kmail/ source code, compile it and install. All the resulting files have the same names as in regular kdepim trunk. ''sqlite'' package will be also installed as a hard dependency.
+The last command will download the source code from the branch, with altered kmail/ source code, compile it and install. All the resulting files have the same names as in regular kdepim trunk. ''sqlite'' package will be also installed as a hard dependency of the ''kdepim-nommap'' package.
 ==Introduction==

@@ Line 15: / Line 15: @@
 *we call the new implementation '''SQLite mode''' for short and the old implementation '''mmap mode'''
 *SQLite 3.5.4 is used, as provided by emerge sqlite module; we should not allow using much older versions of sqlite, e.g. 3.1 because of file format differences
-*we are using '''one''' .index.db file per account, not folder (NOTE: currently that's per folder...)
+*we are using '''one''' .index.db "index file" per folder (on request, could be possible implement it per-account)
 *kmailprivate links to sqlite library for SQLite mode, and KMAIL_SQLITE_INDEX is defined to enable #ifdef'd code
 *kmfolderindex_sqlite.cpp is created and edited as a copy of kmfolderindex.cpp; kmfolderindex.cpp #includes kmfolderindex_sqlite.cpp for SQLite mode and then skips its own code completely