search

vercel-community / php

🐘 PHP Runtime for ▲ Vercel Serverless Functions (support 7.4-8.3)
https://php.vercel.app
MIT License
1.24k stars 285 forks source link

update sqlite #129

Open lekoala opened 3 years ago

lekoala commented 3 years ago

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 :)

f3l1x commented 3 years ago

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?

lekoala commented 3 years ago

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?

f3l1x commented 3 years ago

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

lekoala commented 3 years ago

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 ;)

Soben commented 1 year ago

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)