Reckoner Update June 2025
This month was a continuation of the work from last month
🚢 Releases
I had a big release this past week, version 3.0! Except it’s not a big release. It helps if you understand Reckoner versioning first. I use basic semantic versioning, MAJOR.MINOR.PATCH. My version numbers are incremented as follows:
- MAJOR: The schema version of the SQLite database.
- MINOR: A new feature which did not require a change to the database
- PATCH: Normally just a set of bug fixes
So, the database schema changed! What changed? Well, the default timezone is now saved in the user settings! This was an oversight I missed and no one seems to have encountered 🤷.
Everything else was minor cleanup. I removed the Merchants table (unused), removed sync_id field from transactions (unused), and made sure all merchant names on transactions trimmed whitespace. I have personally had this issue in my use of Reckoner and found the rename functionality did not fix it as it automatically trims whitespace.
So while the changes are relatively minor, since the schema changed, this is a major change! Not risky, but still a major change.
🔄 PowerSync
I am currently working on replacing the PocketBase synchronization service with PowerSync. I’ve gone over this before, but the large issue with PocketBase is the fact that they are still a beta product and I have had issues with continuing to support it.
Don’t get me wrong, PocketBase is an awesome product! It is just that I was using it as an “easy” mode for device synchronization. I was essentially trying to build and work through all of the issues that PowerSync has already solved! The big difference is that I want to preform this synchronization in an end-to-end encrypted fashion. This will involve me doing something novel with PowerSync which they have alluded to, but don’t have an example for. More details to come!
I am excited to get this work going! I’ve been dragging my feet a bit on it, but now don’t have any excuses! However, I have a busy month ahead of me with a bit of early summer travel, so I’m not going to be surprised if it takes me until the end of July to get this done.