welfare : the central Lino Welfare plugin

The lino_welfare.modlib.welfare plugin contains PCSW-specific models and tables that have not yet been moved into a separate module because they are really very PCSW specific.

A tested document

This is a tested document. The following instructions are used for initialization:

>>> from lino import startup
>>> startup('lino_welfare.projects.gerd.settings.doctests')
>>> from lino.api.doctest import *

Startup handlers


Injects application-specific fields to SiteConfig.


Injects application-specific fields to lino_xl.lib.contacts.


Here is how we install case-insensitive sorting in sqlite3. Note that this caused noticeable performance degradation…

Thanks to - http://efreedom.com/Question/1-3763838/Sort-Order-SQLite3-Umlauts - https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_collation - http://www.sqlite.org/lang_createindex.html


Customizes the detail layout of countries.Places and countries.Countries.

TODO: move this to a custom layout module.