Free offline microgreens farm ledger for Windows

A spreadsheet let me overwrite a harvest cell. The total still looked fine. That tray was already promised. I needed a free offline farm ledger for Windows: standing orders, trays by the ounce, and books that do not live in a $30/month cloud farm app. No account. No subscription. File stays on the PC. That is Groundtruth 0.1.3. Apache-2.0. I run my own microgreens farm on it. Repo: https://github.com/alexjvv52-ops/groundtruth-app

The Job

Groundtruth is a local-first desktop app designed for the microgreens farming loop. Its core responsibilities include:

• Standing order tracker - Keeping track of what needs to be grown before it is harvested
• Honest books - Tracking inventory accurately without relying on external systems
• Money management - Separating income and expenses using a custom farm currency defined in Settings; bills and Payment Links draw from this currency
• Export capability - Users can export the database, event log, receipts, and CSVs while leaving the system untouched

This is explicitly not a phone CRM, not farmOS, and not QuickBooks. It is a lightweight tool built for a specific operational reality: one operator, one machine, no logins required.

Technical Architecture

The application stacks React + Vite for the UI and uses Tauri commands integrated into a Rust farm core. Data persistence relies on SQLite on disk, with an append-only event log located at %APPDATA%\com.prairieroots.groundtruth. The codebase includes several key modules:

• src-tauri/db.rs - Database layer
• src-tauri/events.rs - Event handling
• src-tauri/import.rs - Import functionality
• src-tauri/export.rs - Export functionality
• docs/GT-D-SERIES.md - Documentation series

These components together ensure that the ledger remains self-contained and portable.

Design Constraints

The design follows strict constraints that prioritize transparency over convenience:

• Unpaid stays unpaid. There are no silent mark-paid operations with no audit trail. Every transaction must be explicit.
• Corrections and voids are new events. Rather than mutating existing records silently, changes create new entries in the event log.
• Tray cost is computed when you look. Prices are not pre-cached; they are calculated on-demand based on current data.
• Health is not stored. Instead, a scan replays the event log against the database to verify integrity.
• Status is not a mood from yesterday. The system reflects actual state rather than subjective impressions.
• Marketing cannot carry dollars. Samples and follow-ups remain money-free, preventing pipelines from pretending revenue where none exists.

Why This Approach Matters

Cloud-farm software typically keeps ledgers on remote servers, charges recurring fees ($30/month in this case), and requires accounts and logins. In contrast, this build is the opposite bet: Windows x64, unsigned installer, early 0.1.x, dead-laptop recovery documented and not magic. If you want the notebook gone tonight, do not. The goal is a resilient, local-first solution that survives bad data entry, missing rows, and unexpected failures-without requiring any online connection or third-party services.