From what I was able to understand: 1) pysqlite is py2-only and no longer maintained, 2) built-in sqlite3 module is basically a bundled copy of pysqlite, 3) py2.7 sqlite3 is to be considered API-equiv with pysqlite. py2.6 and older are based on older versions. Therefore, I'd say we could try to remove it. But for that, we need to scan all the deps first to make sure that they're compatible with built-in sqlite3 module. If there's at least one package which needs external pysqlite2, there's probably no point in dropping support for it. Otherwise, we could just drop it and always require python[sqlite].
$ grep -L 'python.*\[.*sqlite' $(grep -L PYTHON.*sqlite $( find -name '*.ebuild' -exec grep -l pysqlite {} + )) ./local/sunrise/dev-db/dabo/dabo-0.9.2.ebuild ./local/sunrise/media-sound/poddy/poddy-0.5.1.ebuild ./www-client/seamonkey/seamonkey-2.14-r1.ebuild ./www-client/seamonkey/seamonkey-2.14.1.ebuild ./www-client/seamonkey/seamonkey-2.15.ebuild ./app-misc/gnomecatalog/gnomecatalog-0.3.4.2.ebuild ./app-text/bibus/bibus-1.5.1.ebuild ./app-text/bibus/bibus-1.5.2.ebuild ./dev-db/mysql-workbench/mysql-workbench-5.2.44.ebuild ./dev-db/mysql-workbench/mysql-workbench-5.2.44-r1.ebuild ./dev-db/mysql-workbench/mysql-workbench-5.2.45.ebuild ./mail-client/thunderbird/thunderbird-17.0.2.ebuild ./sys-apps/portage/portage-2.1.11.31.ebuild ./sys-apps/portage/portage-2.1.11.38.ebuild ./sys-apps/portage/portage-2.1.6.7_p1.ebuild ./sys-apps/portage/portage-2.2.0_alpha142.ebuild ./sys-apps/portage/portage-2.2.0_alpha149.ebuild ./sys-apps/portage/portage-9999.ebuild ./sys-apps/portage/portage-2.1.11.40.ebuild ./sys-apps/portage/portage-2.2.0_alpha151.ebuild ./net-mail/offlineimap/offlineimap-6.5.4-r1.ebuild ./net-print/pykota/pykota-1.25_p2437-r1.ebuild ./net-print/pykota/pykota-1.26.ebuild ./games-board/pychess/pychess-0.10.1.ebuild ./games-board/pychess/pychess-0.10.1-r1.ebuild ./dev-python/atpy/atpy-0.9.5.3.ebuild ./dev-python/atpy/atpy-0.9.6.ebuild ./dev-python/turbogears/turbogears-1.0.8.ebuild ./dev-python/adodb-py/adodb-py-2.20.ebuild ./dev-python/mozprofile/mozprofile-0.4.ebuild ./dev-python/kaa-base/kaa-base-0.6.0.ebuild ./media-video/griffith/griffith-0.13.ebuild ./media-video/griffith/griffith-9999.ebuild ./media-tv/xbmc/xbmc-11.0.ebuild ./media-tv/xbmc/xbmc-11.0-r1.ebuild ./media-tv/xbmc/xbmc-12.0_rc2.ebuild ./media-tv/xbmc/xbmc-9999.ebuild ./media-tv/freevo/freevo-1.9.0.ebuild ./media-tv/freevo/freevo-1.7.6.1.ebuild ./net-analyzer/linkchecker/linkchecker-8.2.ebuild ./net-analyzer/linkchecker/linkchecker-8.1.ebuild ./net-analyzer/linkchecker/linkchecker-8.0.ebuild ./net-analyzer/linkchecker/linkchecker-7.9.ebuild
Summary after the first review: app-misc/gnomecatalog pysqlite2 app-text/bibus sqlite3* pysqlite2** dev-db/mysql-workbench sqlite3 pysqlite2* dev-python/adodb-py sqlite3* pysqlite2 dev-python/atpy sqlite3 dev-python/kaa-base pysqlite2 dev-python/mozprofile sqlite3* pysqlite2 games-board/pychess sqlite3 mail-client/thunderbird sqlite3* pysqlite2 media-tv/xbmc sqlite3 media-video/griffith sqlite3* pysqlite2 net-analyzer/linkchecker sqlite3 net-mail/offlineimap sqlite3 net-print/pykota pysqlite2 www-client/seamonkey sqlite3* pysqlite2 * preferred implementation ** supported added by Gentoo patch So, we have 3 packages which use pysqlite2 for some reason only. We need to check if they support sqlite3 as well. Most of the packages use sqlite3 only, or prefer it over pysqlite2. mysql-workbench seems to be the only one preferring pysqlite2.
Ok, the only package I wasn't able to really test was kaa-base. Otherwise, all our packages support sqlite3, and most of them even prefer it. I think we can fix the remaining packages to use built-in sqlite3 and drop pysqlite2 completely. @djc, @floppym: what do you think?
I'm really no more familiar with this than you are. Your conclusion seems sane to me.
(In reply to comment #4) > I'm really no more familiar with this than you are. Your conclusion seems > sane to me. +1.
And masked for removal.
Package removed.