Laravel Tech Community
Feb 24, 2022 · Databases
SQLite 3.38.0 Released with New JSON Operators, Enhanced Date/Time Functions, and Query Planner Improvements
SQLite version 3.38.0 introduces new JSON operators compatible with MySQL and PostgreSQL, built‑in JSON functions, added unixepoch() and auto/julianday modifiers for date/time, renamed printf() to format(), enhanced virtual table interfaces, CLI columnar output options, and query planner optimizations using Bloom filters and balanced merge trees.
JSONQuery PlannerSQLite
0 likes · 4 min read