Bug 128977 - Thunderbird Address Book will be changed to sqlite - Development needed
Summary: Thunderbird Address Book will be changed to sqlite - Development needed
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: difficultyInteresting, easyHack, skillCpp
Depends on:
Blocks:
 
Reported: 2019-11-23 10:37 UTC by Robert Großkopf
Modified: 2019-11-27 03:43 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2019-11-23 10:37:52 UTC
Here one hint from Thunderbird releasenotes for version 71:
https://www.thunderbird.net/en-US/thunderbird/71.0beta/releasenotes/?uri=/thunderbird/releasenotes/&locale=de&version=71.0&channel=beta&os=WINNT&buildid=20191113091023

"Address books are now stored as SQLite databases. Existing address books in MAB format (using a Mork database) will be converted."

There is direct no SQLite-Driver available for LO at this time. Only connection through ODBC will work well.

LO should be able to connect to Thunderbird Address Book.
Comment 1 Alex Thurgood 2019-11-26 09:18:09 UTC
Indeed, Thunderbird 71 beta has made the switch to SQLite address book databases.
Comment 2 Michael Stahl (CIB) 2019-11-26 10:05:13 UTC
this should be an easy-hack!

the existing Thunderbird Mork driver is here:

http://cgit.freedesktop.org/libreoffice/core/tree/connectivity/source/drivers/mork/

we probably need a separate driver so users can work with both old and new Thunderbird profiles.

so perhaps best to start with copying one of the existing drivers, the result should find the address book files in a similar location like the mork driver but the data access is probably closer to one of the SQL based drivers.

"writer:file->wizards->address data source" and "base: connect to existing database" are two routes that can use the mozilla address book for testing purposes. 

one advantage of SQLite should be that concurrent access from Thunderbird and LO should work better.

unfortunately i'm unable to find any documentation on how this SQLite address book is supposed to work in Thunderbird...
Comment 3 Buovjaga 2019-11-26 16:17:31 UTC
Thunderbird's Paul Morris kindly directed me to these reports:
https://bugzilla.mozilla.org/show_bug.cgi?id=382876 
[meta] remove mork usage from address book
https://bugzilla.mozilla.org/show_bug.cgi?id=1581765 
Migrate existing Mork address books to JS provider
Comment 4 Buovjaga 2019-11-26 16:19:56 UTC
One more thing, the Mork removal proposal on TB developer list: http://lists.thunderbird.net/pipermail/maildev_lists.thunderbird.net/2019-August/001900.html
Comment 5 Buovjaga 2019-11-26 16:37:29 UTC
Even more things: the next release of TB will be 78 as the releases follow Firefox Extended Support Release cycle.

According to the FF calendar 78 will hit on 2020-06-30: https://wiki.mozilla.org/Release_Management/Calendar
TB will follow some weeks after: https://wiki.mozilla.org/Thunderbird:Home#Releases

So version 71 is not an end user -facing release. Only beta testers using LibreOffice's Mork connection will suffer breakage.