Comment 2 for bug 747325

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 (6 rdepends)
  libgpeschedule0 # NOT OK: Depends on libsqlite0 (5 rdepends)
  libgpepimc0 # NOT OK: Depends on libsqlite0 (9 rdepends)
  libeventdb2 # NOT OK: Depends on libsqlite0 (6 rdepends)
  libdbd-sqlite # NOT OK: Depends on libsqlite0 (2 rdepends)
  libcontactsdb0 # NOT OK: Depends on libsqlite0 (5 rdepends)
  kannel-extras # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (0 rdepends)
  kannel # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (2 rdepends)
  gpesyncd # NOT OK: Depends on libsqlite0 (0 rdepends)
  gpe-todo # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-timesheet # NOT OK: Depends on libsqlite0 (1 rdepends)
  gpe-contacts # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-confd # NOT OK: Depends on libsqlite0 (1 rdepends)
  gpe-calendar # NOT OK: Depends on libsqlite0 (3 rdepends)
  gpe-bluetooth # NOT OK: Depends on libsqlite0 (0 rdepends)
  gpe-announce # NOT OK: Depends on libsqlite0 (4 rdepends)
  gambas2-gb-db-sqlite2 # NOT OK: Depends on libsqlite0 (1 rdepends), should be dropped as gambas2-gb-db-sqlite3 exists
  csync2 # NOT OK: Depends on libsqlite0 (0 rdepends)
  asterisk # NOT OK: Depends on libsqlite0 (33 rdepends)
  sqlite # OK: Build from sqlite (see above for rdepends)
  php5-sqlite NOT OK: Depends on both libsqlite0 and libsqlite3-0 (12 rdepends)
  libsqlite0-dev # OK: Build from sqlite
  libsasl2-modules-sql # NOT OK: Depends on libsqlite0 (4 rdepends)
  libqt4-sql-sqlite2 # NOT OK: Depends on libsqlite0 (2 rdepends), should be dropped as libqt4-sql-sqlite exists
  libmono-sqlite2.0-cil # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (13 rdepends)
  libmono-sqlite1.0-cil # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (6 rdepends)

stgraber@castiana:~$ apt-cache rdepends libsqlite0-dev
libsqlite0-dev
Reverse Depends:
  kannel-dev # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (6 rdepends)
  cl-sql-sqlite # NOT OK: Depends on both libsqlite0 (1 rdepends)
  libqt4-dev # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (65 rdepends)

stgraber@castiana:~$ apt-cache rdepends libsqlite0-tcl
<libsqlite0-tcl>