Changelog

Unreleased

sqlite_engine v0.1.0

• breaking: rebrand the package, OTP app, config, Elixir namespace, telemetry, NIF, native symbols, environment, and private SQL namespace as SqliteEngine.
• added: transactional migration of complete valid Exqlite 0.40 procedure catalogs, receipts, and results with an exact branding-only runtime ABI update.
• added: immutable SQLite Bedrock and Luau locks, reproducible target-native setup, compiled build identity, and checksummed CI artifact provenance.
• changed: support current Elixir 1.20, OTP 29, and NIF ABI 2.18 precompiled artifacts on macOS and Linux x86_64/aarch64 with glibc or musl; Windows and Android are not supported.
• migration: see guides/migrating_from_exqlite.md; back up databases, clear predecessor NIF caches, and perform a full VM restart.

Predecessor Exqlite release history

The entries below describe releases produced under the predecessor identity and are preserved without rewriting their historical API names.

v0.40.0

• added: Exqlite.Procedures immutable SQLite catalog, lazy per-connection warming, typed command arguments, structured results, atomic heterogeneous batches, idempotency receipts, and durable result references.
• added: bounded Luau db.scalar, db.one, db.all, db.exec, changes, and last-rowid APIs with a connection-local 128-entry statement LRU.
• added: instruction/deadline/memory/SQL/result limits, cancellation recovery, read-only/application-write/trusted profiles, deterministic mode, redacted structured errors, telemetry, testing helpers, and ROADMAP001 benchmarks.
• changed: Update sqlite to 3.53.4.

v0.39.0

• fixed: Raise exception with statement is prepared for a different conneciton.
• fixed: Always close a connection if it fails to open, regardless of success.
• changed: Remove duplicate prepare function.

v0.38.0

• added: Finer-grained :mode support when opening databases (e.g. [:readwrite] for read/write without implicit CREATE, [:readwrite, :create]). The atom :readwrite default is preserved for backward compatibility (still creates if needed). This aligns the API more closely with sqlite3_open_v2 flags. See #347.
• changed: Update sqlite to 3.53.3.

v0.37.0

• added: Exqlite.Sqlite3.cancel/1 to cancel a running query, waking both the busy handler and VDBE execution.
• added: Exqlite.Sqlite3.set_busy_timeout/2 to update the busy timeout without replacing the custom busy handler.
• added: Exqlite.Sqlite3.set_progress_handler_steps/2 and the :progress_handler_steps connection option to control the cancellation progress handler.
• added: Android (aarch64-linux-android, armv7a-linux-androideabi) precompile targets and precompile workflow.
• changed: Update sqlite to 3.53.2.
• changed: :busy_timeout is now applied through set_busy_timeout/2 so the custom busy handler is preserved.
• changed: Connection.disconnect/2 calls cancel/1 before close/1 so teardown can break out of running statements and busy waits.
• fixed: Deadlock when canceling queries stuck in VDBE execution or the busy handler.

v0.36.0

• added: Ability to set an authorizer with set_authorizer/2.
• changed: Update sqlite to 3.51.3.

v0.35.0

• fix: potential connection use after database closer by other process in parallel
• changed: Update sqlite to 3.51.2.

v0.34.0

• fixed: Do not force journal mode unless specified.
• changed: Update sqlite to 3.51.1.

v0.33.1

• added: Allow SunOS builds in Makefile

v0.33.0

• changed: Update sqlite to 3.50.3.
• changed: Implement upgrade to no-op when erl init is called.

v0.32.1

• fixed: Compiler optimizations when cross compiling for Linux.

v0.32.0

• added: Added named params support
• added: Custom type extensions. See: Exqlite.TypeExtensions.
• changed: Update sqlite to 3.50.1.

v0.31.0

• changed: Update sqlite to 3.50.0.

v0.30.1

• changed: Make precompile linux image use ubuntu-22.04 instead of ubuntu-latest.

v0.30.0

• fixed: Remove excess target triplets.
• changed: Update sqlite to 3.49.1.

v0.29.0

• changed: Removed Exqlite.bind/3, please use bind/2 instead.
• changed: Improved multi-threaded access to underlying sqlite resource.
• changed: Document issue with calling close/1 immediately after calling interrupt/1. If you encounter the issue where the entire BEAM crashes, put a short sleep between the call to interrupt/1 and close/1.

v0.28.0

• changed: Update sqlite to 3.48.0.
• fixed: Debug build to not fail assert due to passing module_str to enif function.

v0.27.1

• changed: Update sqlite to 3.47.1.

v0.27.0

• changed: Add ability to set default_transaction_mode for the connection configuration.

v0.26.0

• changed: Update sqlite to 3.47.0.
• changed: Pre-define atoms in NIF.
• changed: Adds ability to set individual binds and re-implements bind/3 using the new bind_* functions. And also deprecates bind/3 in favor of bind/2 since we don't need conn reference anymore.
• fixed: Pre-compilation steps for ARM.

v0.25.0

• fixed: Handle binding large 64 bit integers better for ARM systems.
• fixed: Raise Exqlite.BindError when an argument fails to be bound.

v0.24.2

• fixed: Add SQLITE_ENABLE_DBSTAT_VTAB to windows build.

v0.24.1

• fixed: Pre-compile images for Apple and Windows

v0.24.0

• changed: Update sqlite to 3.46.1.
• fixed: Return :invalid_flags instead of :"invalid flags".
• fixed: Allow accent characters to be used for opening files.

v0.23.0

• changed: update sqlite to 3.46.0.

v0.22.0

• changed: update sqlite to 3.45.3.

v0.21.0

• added: Exqlite.Sqlite3.interrupt/1 to interrupt long running queries in the background.

v0.20.0

• changed: update sqlite3 to 3.45.2.
• changed: use single nif version.
• changed: use Erlang/OTP 24 (NIF 2.16) for macOS.
• changed: updated to elixir_make v0.8.2.

v0.19.0

• changed: Dropped support for Elixir v1.13.
• changed: Updated readme documentation.
• changed: Updated locked dependencies.

v0.18.0

• added: Ability to specify build parameters programatically.
• changed: Updated sqlite3 to 3.44.2.

v0.17.0

• changed: Updaetd sqlite3 to 3.44.0.
• added: :before_disconnect hook.

v0.16.2

• fixed: Precompile support for Windows.

v0.16.1

• fixed: Precompiled binaries for OTP 26. Windows precompiled binaries should work now.

v0.16.0

• added: set_log_hook.
• removed: utf8.h as it is not necessary.

v0.15.0

• added: set_update_hook.
• fixed: sqlite extension alignment problem by utilizing size_t.
• changed: Drop support for Elixir 1.12.
• changed: Drop support for OTP 23.
• changed: Updated sqlite3 to 3.43.2.

v0.14.0

• changed: Updated sqlite3 to 3.43.1.

v0.13.15

• fixed: allow gnu compiled binaries to be included on the checksum update step.
• fixed: do not bind atoms that are prefixed with nil as NULL. https://github.com/elixir-sqlite/exqlite/pull/258

v0.13.14

• fixed: OTP26 and Elixir 1.15 compilation issues.

v0.13.13

• fixed: Check for null sqlite db connection.

v0.13.12

• changed: Updated sqlite3 to 3.42.0.

v0.13.11

• fixed: Wrap include directory with string so it works with the compiler.

v0.13.10

• added: Ability to specify :load_extensions for custom sqlite extensions.
• changed: Updated sqlite3 to 3.41.2.

v0.13.9

• fixed: Do not free mutex if it is not set.

v0.13.8

• fixed: Handle SEGFAULT when trying to open a database that the application does not have permissions to open.

v0.13.7

• added: precompilation support for musl based libc.
• changed: Updated sqlite to 3.41.1.

v0.13.6

• fixed: Error responses from sqlite NIF come back as an atom, the message field in Exqlite.Error is expected to be a string.

v0.13.5

• changed: Allow :force_build to be specified in application configration to allow projects to force build the application rather than use precompiled binaries.

v0.13.4

• changed: Updated sqlite3 to 3.41.0.

v0.13.3

• added: precompilation support.

v0.13.2

• fixed: -O2 flag was not being set when compiling binaries in non windows environment.

v0.13.1

• added: SQLITE_ENABLE_DBSTAT_VTAB=1.
• changed: Allow EXQLITE_SYSTEM_CFLAGS to be appended to the CFLAGS regardless.

v0.13.0

• removed: Remove support for Elixir 1.11
• added: Support for custom pragmas to be set.
• changed: Updated sqlite3 to 3.40.1

v0.12.0

• changed: Use multi_step for Repo.stream calls.
• added: Ability to use URI for a database path. See sqlite docs. Example: file:/tmp/database.db?mode=ro.

v0.11.9

• fixed: step/2 typespec was specified incorrectly.

v0.11.8

• changed: Updated sqlite3 to 3.40.0

v0.11.7

• fixed: Segfault issue when database connections would time out.

v0.11.6

• changed: Updated sqlite3 to 3.39.4

v0.11.5

• changed: Updated sqlite3 to 3.39.3

v0.11.4

• changed: Use sqlite3_open_v2.
• changed: Expose :mode.
• changed: Removed old macro hack for erlang nifs.

v0.11.3

• changed: Updated sqlite3 to 3.39.2

v0.11.2

• changed: Fix incorrect ordering due to Enum.reverse/1.

v0.11.1

• changed: Updated sqlite3 to 3.38.5

v0.11.0

• added: top level interface for Exqlite similar to Postgrex's interface.
• added: optional table protocol support for results.

v0.10.3

• fixed: Improved fetch_all/4 call speed.

v0.10.2

• changed: Updated sqlite3 to 3.38.
• revert: change made to Visual Studio 2022 vcvars64.bat

v0.10.1

• fix: path to Visual Studio 2022 vcvars64.bat

v0.10.0

• added: Custom memory allocator for sqlite to leverage erlang's enif_alloc functionality. This allows the memory usage to be tracked with the erlang vm usage stats.

v0.9.3

• fixed: SIGSEGV issue when a long running query is timed out.

v0.9.2

• added: Ability to set :journal_size_limit in bytes.
• added: Ability to set :soft_heap_limit in bytes.
• added: Ability to set :hard_heap_limit in bytes.

v0.9.1

• added: Documentation about compiling with system install sqlite3.
• fixed: Debug output during mix compile process.

v0.9.0

• added: Allow setting :key option PRAGMA before all other pragmas to allow for use of encrypted sqlite databases.

v0.8.7

• added: Ability to compile exqlite using the system sqlite3 installation as opposed to building from source.

v0.8.6

• changed: Compile SQLite3 with -DHAVE_USLEEP=1 to allow for more performant concurrent use.

v0.8.5

• changed: Update SQLite from 3.37.0 to 3.37.2

v0.8.4

• fixed: Improved typespecs.

v0.8.3

• changed: Compilation output to be less verbose. If more verbosity is desired V=1 mix compile will remedy that.
• changed: When the path to the database does not exist, mkdir_p is invoked.

v0.8.2

• fixed: unicode handling when preparing sql statements.

v0.8.1

• fixed: unicode handling when executing sql statements.

v0.8.0

• changed: Updated SQLite from 3.36.0 to 3.37.0.

v0.7.9

• changed: Debug build opt in, instead of opt out. export DEBUG=yes before compilation and it will add a -g to the compilation process.

v0.7.3

• added: support for static erlang compilation.

v0.7.2

• added: support for android compilation.

v0.7.1

• fixed: segfault on double closing an sqlite connection.

v0.7.0

• added: Exqlite.Basic for a simplified interface to utilizing sqlite3.
• added: ability to load sqlite extension.

v0.6.4

• changed: Updated SQLite from 3.35.5 to 3.36.0

v0.6.3

• fixed: perceived memory leak for prepared statements not being cleaned up in a timely manner. This would be an issue for systems under a heavy load.

v0.6.2

• changed: Handle only UTC datetime and convert them to iso form without offset.

v0.6.1

• fixed: compilation issue on windows.

v0.6.0

• added: Exqlite.Sqlite3.serialize/2 to serialize the contents of the database to a binary.
• added: Exqlite.Sqlite3.deserialize/3 to load a previously serialized database from a binary.

v0.5.11

• changed: add the relevant sql statement to the Error exception message
• changed: update SQLite3 amalgamation to 3.35.5
• fixed: issue with update returning nil rows for empty returning result.

v0.5.10

• fixed: maybe_set_pragma was comparing upper case and lower case values when it should not matter.

v0.5.9

• changed: Setting the pragma for Exqlite.Connection is now a two step process to check what the value is and then set it to the desired value if it is not already the desired value.

v0.5.8

• added: Exqlite.Error now has the statement that failed that the error occurred on.

v0.5.7

• changed: Update SQLite3 amalgamation to 3.35.4

v0.5.6

• fixed: SQLite3 amalgamation in 0.5.5 being incorrectly downgraded to 3.34.1. Amalgamation is now correctly 3.35.3.

v0.5.5

• changed: Update SQLite3 amalgamation to version 3.35.3

v0.5.4

• fixed: incorrect passing of chunk_size to fetch_all/4

v0.5.3

• fixed: :invalid_chunk_size being emitted by the DBConnection.execute

v0.5.2

• added: Guide for Windows users.
• added: Exqlite.Sqlite3.multi_step/3 to step through results chunks at a time.
• added: default_chunk_size configuration.

v0.5.1

• changed: Bumped SQLite3 amalgamation to version 3.35.2
• changed: Replaced old references of github.com/warmwaffles

v0.5.0

• removed: Ecto.Adapters.Exqlite. Replaced with Ecto Sqlite3 library.