Bug 415175

Summary: Documentation of sqlite and sqlite3 backends incomplete and irridating
Product: [Frameworks and Libraries] Akonadi Reporter: h.goebel
Component: generalAssignee: Bertjan Broeksema <broeksema>
Status: RESOLVED NOT A BUG    
Severity: normal CC: carl
Priority: NOR    
Version First Reported In: GIT (master)   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description h.goebel 2019-12-14 20:58:41 UTC 
According to several pieces in the code, there are both a SQLITE and a SQLITE3 backend.  Neither of READNE.sqlite, NEWS or INSTALL tell which one to prefer. Many of the information about the SQLITE driver ssem to predate akonadi's qsqlite implementation.

* INSTALL has ony SQLITE, README.sqlite has only "SQLITE3". 

* There is no description about the differences between SQLITE and SQLITE3.

Please update the docuemtnation to:

- tell whether SQLITE or SQLITE3 is to be preferred

- what are the (high-level) differences between SQLITE and SQLITE3

- If one of these is outdated, state this.

* State whether the statement "SQlite … NOT RECOMMENDED" (in INSTALL) is still valid.

* Tell "… these changes should be pushed upstream eventually" (README.sqlite) has been done and whether the code was includes. Also please state what this means for akonadi's SQLITE or SQLITE3 backend.

Many thanks!
Comment 1 Carl Schwan 2023-04-25 11:04:36 UTC 
SQLITE3 is a fork of upstream sqlite driver. We are planning to remove it and just use the upstream sqlite driver in the near future (next release).