Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade sqlite in workspace container #2833

Closed
mattcrn opened this issue Feb 2, 2021 · 2 comments
Closed

Upgrade sqlite in workspace container #2833

mattcrn opened this issue Feb 2, 2021 · 2 comments
Assignees

Comments

@mattcrn
Copy link

mattcrn commented Feb 2, 2021

The current version of sqlite in the workspace container is 3.22.0.

It would be greate to upgrade it to at least 3.25.0. so the syntax for renaming columns works.

@ionparticle
Copy link

In addition, sqlite 3.24.0 is the minimum required for the new upsert() method in the query builder.

Laravel Upsert: https://laravel.com/docs/8.x/queries#upserts
Using upsert results in an error as sqlite 3.22.0 doesn't understand the "on conflict" clause: https://sqlite.org/lang_upsert.html

@bestlong
Copy link
Member

now is 3.31

$ docker-compose build --no-cache --pull workspace

$ docker-compose up -d workspace

$ docker-compose exec workspace bash
root@37a46c430eda:/var/www# sqlite3 -version
3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1
root@37a46c430eda:/var/www#

@bestlong bestlong self-assigned this Jun 11, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants