demote sqlite, or remove it from the archive

[Matthias Klose]

Binary package hint: sqlite

we had this discussion before the 10.04 release, and did decide to wait until after the release. Just seen that we are still suck with this historic version.

please feel free to retarget the report to a later milestone.

[Colin Watson (cjwatson)]

Current reverse-dependencies:

-- natty/main amd64 deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main i386 deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main armel deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main powerpc deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main build deps on libsqlite0-dev:
bacula
cyrus-sasl2
libdbi-drivers
php5
qt4-x11
-- natty/universe amd64 deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe i386 deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe armel deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe powerpc deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe build deps on libsqlite0-dev:
asterisk
csync2
cyrus-sasl2-heimdal
gambas2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
libeventdb
libgpepimc
libgpeschedule
libgpevtype
libtododb
mnogosearch
pdns
python-sqlite
qof
qsf
sqlrelay
teleport
-- natty/universe amd64 deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe i386 deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe armel deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe powerpc deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe build deps on sqlite:
kannel
-- natty/universe amd64 deps on sqlite:
ansel1
bacula-director-sqlite
beancounter
imms-common
movabletype-opensour...

[Stéphane Graber (stgraber)]

Doh, should have refreshed that bug before looking at it :)
Anyway, here's the same thing as Colin but with some notes attached to it.

General feeling is that it'll be quite hard to remove it from the archive. Demoting should be a lot easier, though php is probably not that much fun.

Binary packages: sqlite, sqlite-doc, libsqlite0, libsqlite0-dev, libsqlite0-tcl

stgraber@castiana:~$ apt-cache rdepends sqlite
sqlite
Reverse Depends:
  sympa # OK: Recommends both sqlite and sqlite3
  serendipity # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (0 rdepends)
  roundcube-sqlite # NOT OK: Depends on sqlite. Should be changed to sqlite3 once php5-sqlite only support sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  qsf # OK: sqlite is only a suggestion
  phpbb3 # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  pdns-backend-sqlite # NOT OK: Depends on sqlite. Should probably be dropped too as pdns-backend-sqlite3 already exists. (0 rdepends)
 |movabletype-opensource # NOT OK: Depends on sqlite | mysql-client | postgresql-client, should be changed to sqlite3 (uses libdbd-sqlite3-perl) (0 rdepends)
  lire # OK: Suggests both sqlite and sqlite3
  imms-common # OK: Recommends both sqlite and sqlite3
  csync2 # OK: Suggests sqlite
  beancounter # OK: Depends on either sqlite3 and sqlite
  bacula-director-sqlite # NOT OK: Depends on either sqlite3 and sqlite (0 rdepends)
 |ansel1 # OK: Recommends and sqlite3 is an alternative
  sqlite-doc # OK: Build from sqlite

stgraber@castiana:~$ apt-cache rdepends libsqlite0
libsqlite0
Reverse Depends:
  gentle # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (1 rdepends)
  teleport # NOT OK: Depends on libsqlite0 (0 rdepends)
  sqlrelay-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  qsf # NOT OK: Depends on libsqlite0 (0 rdepends)
  python-sqlite-dbg # NOT OK: Depends on libsqlite0 (1 rdepends)
  python-sqlite # NOT OK: Depends on libsqlite0 (14 rdepends)
  prismstumbler # NOT OK: Depends on libsqlite0 (0 rdepends)
  pdns-backend-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  mnogosearch-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  libtododb0 # NOT OK: Depends on libsqlite0 (6 rdepends)
  libsqliteodbc # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (2 rdepends)
  libsqlite-tcl # OK: Build from sqlite (see below for rdepends)
  libqof2-backend-sqlite # NOT OK: Depends on libsqlite0 (1 rdepends)
  libgpevtype1 # NOT OK: Depends on libsqlite0...

[Stéphane Graber (stgraber)]

Apparently LP didn't like that copy/paste so much, attaching the output instead.

[Martin Pitt (pitti)]

Oneiric's mono migrated away from it, so in main the reverse dependencies are down to

libqt4-sql-sqlite2 : Just a binding without reverse dependencies, also builds libqt4-sql-sqlite (against sqlite3); can be dropped from package
libsasl2-modules-sql
php5-sqlite

reverse build deps:
bacula
libdbi-drivers
php5
qt4-x11

libqt4-sql-sqlite2 is just a binding without reverse dependencies, also builds libqt4-sql-sqlite (against sqlite3); it can be dropped from the source package.

[Martin Pitt (pitti)]

Didier, can you please drop the -sqlite2 binary package from Qt?

[Didier Roche-Tolomelli (didrocks)]

seems easy enough, after some investigation, seems that only kubuntu-full dep on the sqlite2 version, so we can drop the dep there and rebuild qt-x11 without sqlite2 support. Will do that just after alpha2

[Martin Pitt (pitti)]

I dropped libqt4-sql-sqlite2 from the Kubuntu seeds.

[Launchpad Janitor (janitor)]

This bug was fixed in the package qt4-x11 - 4:4.7.3-4ubuntu2

---------------
qt4-x11 (4:4.7.3-4ubuntu2) oneiric; urgency=low

  [ Scott Kitterman ]
  * Remove no longer used debian/patches/kubuntu_22_thumb2_support.diff

  [ Didier Roche ]
  * debian/patches/a11y_qt_and_qml_backport.diff:
    - refreshed from 11/06/28
  * debian/control:
    - refresh Vcs-* with new location
  * debian/libqt4-sql-sqlite2.install, debian/rules, debian/control:
    - don't build anymore the sqlite2 flavor. Only have libqt4-sql-sqlite with
      sqlite 3 support. (LP: #747325)
  * kubuntu_26_dbusconnection_pointer.diff:
    - readd wrongly removed upstream patch (will only be there for 4.8 and is
      needed for the dconf binding)
 -- Didier Roche <email address hidden> Thu, 07 Jul 2011 09:01:08 +0200

[Matthias Klose (doko)]

still in main and ftbfs. see
https://launchpad.net/ubuntu/+source/sqlite/2.8.17-6build2

[Martin Pitt (pitti)]

Steve/Matthias fixed php5 (FTBFS on amd64, though) and I fixed balula yesterday, so the only remaining rdepends is now libdbi-drivers. We could drop the build dep and the binary libdbd-sqlite package; the only reverse dependency of it is

Package: interchange-cat-standard
Depends: debconf (>= 0.5) | debconf-2.0, libwww-perl, interchange (>= 5.3.0), interchange-ui (>= 5.3.0), libdbd-sqlite | libdbd-mysql-perl | libdbd-pg-perl, dbconfig-common

so we would not even break this by removing libdbd-sqlite.

[Martin Pitt (pitti)]

I uploaded a libdbi-drivers version which drops sqlite, sitting in unapproved now.

[Launchpad Janitor (janitor)]

This bug was fixed in the package libdbi-drivers - 0.8.3-1-0ubuntu5

---------------
libdbi-drivers (0.8.3-1-0ubuntu5) oneiric; urgency=low

  * debian/control: Drop libdbi-sqlite package, it has no reverse dependencies
    any more. Drop libsqlite0-dev build dependency, so that the old sqlite can
    finally drop out of main. (LP: #747325)
  * debian/rules: Drop --with-sqlite.
 -- Martin Pitt <email address hidden> Fri, 26 Aug 2011 10:03:42 +0200

[Martin Pitt (pitti)]

Demoted to universe. Yohoo!