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.

Sign up for GitHub

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

Jump to bottom

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

Open
laoshaw opened this issue Jan 5, 2023 · 1 comment
Open

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

laoshaw opened this issue Jan 5, 2023 · 1 comment

Comments

@laoshaw
Copy link

laoshaw commented Jan 5, 2023

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

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:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mjpieters @laoshaw