The latest articles on DEV Community by Praire-Roots (@alexjvv52ops). https://dev.to/alexjvv52ops https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4132186%2F79a1ab4c-2d80-43c7-8e4d-2680ed243036.jpg https://dev.to/alexjvv52ops en Praire-Roots Fri, 18 Sep 2026 23:17:32 +0000 https://dev.to/alexjvv52ops/free-offline-microgreens-farm-ledger-for-windows-i-replaced-a-spreadsheet-with-a-local-first-tauri-2oaf https://dev.to/alexjvv52ops/free-offline-microgreens-farm-ledger-for-windows-i-replaced-a-spreadsheet-with-a-local-first-tauri-2oaf <p>A spreadsheet let me overwrite a harvest cell. The total still looked fine. That tray was already promised.</p> <p>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.</p> <p>That is Groundtruth 0.1.3. Apache-2.0. I run my own microgreens farm on it.</p> <p>Repo: <a href="https://github.com/alexjvv52-ops/groundtruth-app" rel="noopener noreferrer">https://github.com/alexjvv52-ops/groundtruth-app</a></p> <h2> The job: standing order tracker + honest books </h2> <p>Small growers sow trays, harvest by weight, and sell to kitchens or a market. The failure mode is not seed. It is promising the same tray twice, then finding out when the sheet and the WhatsApp thread disagree.</p> <p>Groundtruth is a local-first desktop app for that loop.</p> <ul> <li>Today: move to light, harvest, sow the shortfall</li> <li>Standing orders next to what is actually on the rack (promised vs sown)</li> <li>Money in / money out — unpaid stays unpaid</li> <li>Farm currency in Settings; bills and Payment Links use that currency</li> <li>Export the database, event log, receipts, and CSVs and leave</li> </ul> <p>Not a phone CRM. Not farmOS. Not QuickBooks.</p> <h2> Stack </h2> <ul> <li>React + Vite UI</li> <li>Tauri commands into a Rust farm core</li> <li>SQLite on disk</li> <li>Append-only event log beside the database</li> <li><code>%APPDATA%\com.prairieroots.groundtruth</code></li> </ul> <h2> Constraints that are code, not slogans </h2> <p><strong>Unpaid stays unpaid.</strong> No silent mark-paid with no trail. Corrections and voids are new events.</p> <p><strong>Tray cost is computed when you look.</strong> Not a cached cell. Missing rows → it refuses to invent a number.</p> <p><strong>Health is not stored.</strong> A scan replays the event log against the database. Status is not a mood from yesterday.</p> <p><strong>Marketing cannot carry dollars.</strong> Samples and follow-ups stay money-free so a pipeline cannot pretend it is revenue.</p> <p><strong>One operator, one machine.</strong> No logins. Export everything. Stripe keys never ride along.</p> <p><strong>Restore checks a stamp.</strong> Bad bundles are rejected. Farms do not merge.</p> <p>Those rules live in <code>src-tauri</code> (<code>db.rs</code>, <code>events.rs</code>, <code>import.rs</code>, <code>export.rs</code>) and <code>docs/GT-D-SERIES.md</code>.</p> <h2> Offline farm books, no subscription </h2> <p>Cloud farm software does real work: calendars, pack lists, a phone. It also keeps the ledger on a server you do not own and bills you whether the week sold.</p> <p>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.</p> <h2> Why this is on DEV </h2> <p>Local-first is easy to print on a landing page. It is harder when a cook is waiting on a tray count.</p> <p>If you build desktop tools that have to survive a bad cell in a sheet, steal the event log + computed-health pattern. The microgreens skin is just the job I had.</p> <p>Issues and PRs on the repo.</p> rust tauri opensource webdev