K Karthikeyan Singaravelan personal blog

New JSON query operators in SQLite 3.38.0

tirkarthi.github.io 6 min read

SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...

Points

397

HN comments

33

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2022

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

Pphiresky20211,812 points314 commentscited by 26 details

I'm all-in on server-side SQLite

Fly.io Blog20221,353 points565 commentscited by 16 details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

Datomic is Free

DDatomic Blog20231,099 points368 commentscited by 5 details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details