php icon indicating copy to clipboard operation
php copied to clipboard

update sqlite

Open lekoala opened this issue 4 years ago • 5 comments

Feature Request

I'm considering deploying an app with a sqlite database that will be bundled during deployment. I see that the current sqlite library is quite old (3.7.17 released in 2013)

There has been quite a lot of changes since then. Is it possible to update the version of this library to a more recent one?

Not sure if I need any of the changes, but it makes me wonder :)

lekoala avatar Oct 30 '20 08:10 lekoala

Hi @lekoala. I am using PHP by https://rpms.remirepo.net/ and its based on Amazon Linux 2. There is limited way how things can be changed. Could you please show me how to install latest sqlite? I mean, only php-sqlite is required or something else?

f3l1x avatar Oct 30 '20 12:10 f3l1x

I'm not sure really it's surprising that it's no up to date. I see that there is also an amazon extra with stuff for php so maybe in there there is a more up to date version?

lekoala avatar Oct 30 '20 20:10 lekoala

Do you think it requires only recompile sqlite php extension or there is more stuff around?

f3l1x avatar Nov 20 '20 20:11 f3l1x

From what I've seen a simple update of sqlite should do it but really I have no experience in this matter so it's not like my ideas are accurate ;)

lekoala avatar Nov 21 '20 14:11 lekoala

This appears to still be an issue and needs to be resolved.

Working on a SlimPHP project that uses SQLite and receiving the following error when trying to prepare a statement:

SQLite3Stmt::getSQL(): The expanded parameter requires SQLite3 >= 3.14 and 3.7.17 is installed

EDIT: Re-reviewing my error and the original issue, I see that the issue now is that there is a newer version of SQLite that is needed (3.14)

Soben avatar Dec 16 '22 17:12 Soben