search

dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.06k stars 67 forks source link

feature request: sqlite3.38+ support for json to use its new features #152

Open laoshaw opened 1 year ago

laoshaw commented 1 year ago

the > and >> operators on json objects are not yet supported in litecli, they're added in 3.38. Thanks.

mjpieters commented 9 months ago

This doesn't appear to be litecli specific; litecli uses the Python standard library sqlite3 module, which loads the currently-installed version of the sqlite library. If you want to use a newer sqlite version, you have to upgrade that library.

How to do that is system specific; see the following Stack Overflow questions on some of the specifics for each operating system: