sqlite.md

layout	page
published	true
noToc	false
noComments	false
noDate	false
title	Fun - SQLite extension (optional)
subtitle	Documentation for SQLite extension (optional)
description	Documentation for SQLite extension (optional)
permalink	/documentation/extensions/sqlite/
lang	en
tags	extension optional sqlite

• CMake option: FUN_WITH_SQLITE=ON
• Purpose: Access SQLite databases via the native C API.
• Homepage: https://www.sqlite.org/{:class="ext"}

Opcodes:

• OP_SQLITE_OPEN: pops path; pushes handle (>0) or 0
• OP_SQLITE_CLOSE: pops handle; pushes Nil
• OP_SQLITE_EXEC: pops sql, handle; pushes rc:int (0=OK)
• OP_SQLITE_QUERY: pops sql, handle; pushes array

Notes:

• Requires SQLite development headers/libs.
• See also: libSQL for a compatible alternative backend.