// the take
A small Flutter example app showing CRUD note persistence with the sqflite plugin using raw SQL statements instead of a query builder. It's the companion repo to a YouTube tutorial, aimed at Flutter beginners who want to see local SQLite storage done by hand rather than through an abstraction layer.
Clean separation between db/model/page/widget layers makes it easy to trace exactly how a note gets written, read, updated and deleted through SQLite. Using raw SQL (rather than wrapping sqflite in a generated ORM) is actually useful pedagogically — you see the actual CREATE TABLE and parameterized queries instead of magic. Small enough (one table, one model) to read end-to-end in a sitting.
No migration handling at all — schema changes between app versions aren't addressed, which is the first thing that breaks in any real sqflite app. No tests, and the only query layer is string-based SQL with no validation beyond sqflite's own parameter binding, so there's no feedback if a query shape changes. Last push is November 2023 with no apparent maintenance since, and the README is almost entirely course/channel promotion rather than usage or API docs. It's a single-file database layer for a single-entity app — nothing here demonstrates handling concurrent writes, larger schemas, or indexing, so it doesn't scale as a reference beyond the toy example.
We read the README, the directory tree and a key source file in October 2026. Nobody pays to be listed. How we judge →