Level 1
Any update for that question ? It will be quite complex to me to install JSON1 extension (need to update whole ubunto to support good sqlite version etc...) so I need an answer before trying to install it.
Sep 21, 2017
5
Level 1
Laravel 5.3+, JSON column with SQLite
Hello,
I red that since laravel 5.3, you can work with JSON columns.
I wonder if it works with SQLite with the JSON1 extension that normally bring JSON stuff to SQLite.
My objective is to make some database database where statements on json values like that :
->where('meta->favorite_color', 'red')
but on a SQLite database with JSON1 extension enabled.
Will it works ?
Level 1
It doesn't. You can use whereRaw('JSON_EXTRACT()')
I've made a proposal to bring that support to Laravel https://github.com/laravel/internals/issues/811
Level 1
Thanks for the answer, your initiative is really great. I'm in a SQLite environment and being able to use JSON columns would be a huge plus !
Level 3
Guys, any update on this? i just installated https://github.com/spatie/laravel-tags and i use :memory: storage inside my tests suite,
however, laravel-tags does use where condition like this: where('name->en', 'name') to query json column, and yea, i get null back since it doesnt work
i tried to install sqlite3 with version of 3.22 but cant get JSON1 extension to work :(
Level 26
@patrikw1 it works for a while now whereJsonContains('name->en', 'name')no support for sqlite unfortunatelly
Please or to participate in this conversation.