Tag: sqlite

# SQLite 2022 Recap

New features

  • -> and ->> operators on JSON
  • RIGHT and FULL OUTER JOIN
  • Compiling to WASM
  • The sqlite3_error_offset() C-language interface for better error reporting
  • The recovery extension
  • IS DISTINCT FROM and IS NOT DISTINCT FROM operators.
  • unixepoch() and format() SQL functions