Skip to content

Instantly share code, notes, and snippets.

View blakeNaccarato's full-sized avatar

Blake Naccarato blakeNaccarato

View GitHub Profile
@blakeNaccarato
blakeNaccarato / $ Change the sheets 'Regularly' with SQLModel and XLWings.md
Last active January 20, 2024 23:40
Two-way interactions between an Excel spreadsheet and a SQLite database exported from the Regularly Android app, enabling synchronization and updating of chores in the app.

Change the sheets 'Regularly' with SQLModel and XLWings

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