JSON in SQL: Query Semi-Structured Data in SQLite
In SQLite, a total stored as the text 9.50 passed a filter for totals over 20; a cast fixed it.
Video #128 ยท SQL and analytics
Steps in the video
Files
- events.py (23 lines)
- queries.py (27 lines)
- run.py (27 lines)
Tested with
Python 3.12.15
What this does not show
Five made-up events checked only in SQLite, with no indexes or timings, and no JSONB or arrow operators.
Sources
Learning IT by Example.