Start Debugging

sqlite

4 posts

2026-10-15 migration flutter dart

Migrate a Flutter App's Local Storage from Hive to Drift (hive_ce 2.22 to drift 2.35)

A one-time, crash-safe import of existing Hive boxes into a drift SQLite database on the user's device: schema design, the import function, idempotency, deleting the boxes, and the two gotchas that silently corrupt data (DateTime precision and class-name collisions). Tested on Flutter 3.44.8 with hive_ce 2.22.0 and drift 2.35.2.

2026-09-27 ef-core ef-core-11 sql-server

How to add a unique index on a JSON-mapped property in EF Core 11 (SQL Server and SQLite)

HasIndex(...).IsUnique() on a ToJson() member does not enforce uniqueness in EF Core 11 RC 1: SQL Server drops IsUnique and SQLite indexes the whole document. Expose the JSON value as a computed column and put the unique index on that instead.

2026-02-07 dotnet flutter sqlite

TrailBase v0.23.7: A Single-Binary Firebase Alternative for .NET 10 and Flutter

TrailBase is an open-source, single-executable backend built on Rust, SQLite, and Wasmtime. Version 0.23.7 ships UI fixes and improved error handling.

2023-09-01 sqlite

SQLite-net – No parameterless constructor defined for this object on ExecuteQuery

How to fix the 'no parameterless constructor defined' error in SQLite-net when using ExecuteQuery with primitive types like string or int.