This Gist features two-way interactions between an Excel spreadsheet and a SQLite database exported from the Regularly Android app (APK available from other sources), enabling synchronization and updating of chores in the app. This writeup goes in a few different directions, so feel free to poke around:
- The usage guide is brief, but links to more details for all skill levels.
- Jump into changing the sheets for a tour of the kind of end-user code that carefully-prepared SQLModel models facilitate.
- See behind the scenes in the database model deep dive, powered by SQLModel, with special handling of quirks and gotchas.
- See the Excel and CSV data models for data model philosophy, and a few cool features:
- A `Datac