sqlite2 support

[lainme]

I installed the latest oneiric beta version, and find that php5-sqlite doesn't come with sqlite2 support. There are only sqlite3.so compiled. After checked the debian/rules file, I find such configuration

--without-sqlite \
--with-sqlite3=shared,/usr \

which disables sqlite2. Since there are still some application using sqlite2, this causes some compatibility problem. I have to rebuild the package to let sqlite2 works.

[Dave Walker (davewalker)]

It was a concerted effort to remove this support, see bug 747325. Please can you outline the packages which require sqlite support?

Thanks.

[lainme (lainme)]

I am using a dokuwiki plugin - blogtng, which use sqlite2 as its database.

I checked the bug report mentioned. May a separate package for sqlite2?

[Stefan Großmann (visor1999)]

I also have PHP applications running which are using a sqlite2 database. So support for the php5 sqlite extension is quite important to me.

[Philippe Rio (rio)]

It's needed for roundcube as well!!!

Thanks
Philippe

[OmniUni (omniuni)]

I too have some older applications that I have not moved to the PDO model. Please re-add support for SQLite 2; it is causing a lot of trouble during upgrades.

[Ondřej Surý (ondrej)]

Are we reiterating the "please don't remove php4, I have old applications"?

If you have an old application which needs a rewrite you should stay on LTS. You can have a API stability or the newest version of PHP5. You cannot have both.

While I was not involved in the original decision I quite agree with it and I'll probably merge the drop in the next Debian PHP5 build.

[Stefan Großmann (visor1999)]

As far as I can see from the official PHP5 documentation, sqlite2 support is enabled by default:

"The SQLite extension is enabled by default as of PHP 5."
http://www.php.net/manual/en/sqlite.requirements.php

"As of PHP 5 this extension is enabled by default, so simply do not disable it and it'll be available."
http://www.php.net/manual/en/sqlite.setup.php

So in my opinion the conclusion "You can have a API stability or the newest version of PHP5. You cannot have both" is inaccurate since SQLite2 is by default *part of* the newest version of PHP5. For the newer SQLite3 there is a separate package php5-sqlite3, so what for should the package php5-sqlite be if not for SQLite2 support?

[Ondřej Surý (ondrej)]

I am not speaking about PHP5.

Sqlite 2.x is long discontinued and is not supported by upstream. So there were no official security/stability updates since 2006.

And BTW it has been removed from php 5.4 anyway.

Anyway I don't really care what Ubuntu is going to do. The fact is that sqlite 2.x is long overdue and we should have removed it long ago from Debian packages.

[OmniUni (omniuni)]

Unfortunately, there is still a lot of software that requires SQLite2, and I still believe that it should be provided as long as people keep having a need for it and major software (like RoundCube) require it. I can see distributing it as a separate package that is not by default included, but please leave us an option!

For those who are having a problem, I have tried to put together a SQLite2 package to help fix the problem. Install the package, and restart Apache. If it works or doesn't, or if you would like a 64bit version, please let me know.

http://omniimpact.com/packages/php5-sqlite2_5.3.5-1dm1_i386.deb

[Micah Gersten (micahg)]

Users who need sqlite2 support should probably stay on the 10.04 LTS which has support on the server until April 2015. As Ondřej Surý mentioned, sqlite2 has been deprecated for 5 years now upstream and by the time that 10.04 has reached its end-of-life, it'll be almost 10. I don't believe that this should be added back to precise to give people an extra 2 years of support for a long deprecated library.