#SQLite
2 posts
5 min read
Wails in Practice #3 Full-Text Search and Data Flow — FTS5 and Event-Driven Updates
Add fast full-text search to the notes app and settle the data flow. Covers SQLite FTS5 virtual tables and triggers that keep the search index in sync automatically, exposing search as a service in Go, and a design that keeps the truth in one place by refreshing the frontend with Wails events when data changes.
5 min read
Wails in Practice #2 SQLite Local Database — Pure Go, No CGO
Add persistence to the notes app. Covers the CGO trap that blocks cross-compilation when using SQLite in a Wails app and how the pure-Go driver modernc.org/sqlite sidesteps it, the repository layer implementation, schema and migrations, and CRUD with validation applied in the service layer.