lunch money sync using localStorage (WIP)

[dckc]

The main goal is to take the work we're doing in lunch money and apply it to the GnuCash database, since only GnuCash is double-entry.

Today I got a page working that

• [x] fetches accounts and some recent transactions from the lunch money API
• [x] caches them in localStorage
  • [x] TODO: explode accounts, transactions into individual localStorage items
    • [x] store 1 item with a list of keys (plus last-updated metadata) plus an item with data for each key

This branch also has an express node.js service with overlapping functionality:

• [x] GET lunch money accounts from sqlite3 DB

I think I want to

• [ ] server: GET gnucash transations from sqlite3 DB
• [ ] client: GET gnucash transactions -> localStorage
• [ ] client: match lunchMoney transactions with GnuCash transactions within an account
  • [ ] by date, amount
  • [ ] manually

stretch goal:

• [ ] secure mobile access using webauthn

[dckc]

I wonder about

• [ ] responding to DB updates using a UDF (a la md5) in a trigger.