Farm-IT
At Farm-IT I built desktop and web applications for the agricultural sector, and I was lucky enough to choose whatever stack best solved the problem in front of me. That freedom taught me that choosing your own stack is a big responsibility, because it shapes the whole life of a project.
I enjoyed designing interfaces that let people solve complex problems simply. I’m a firm believer that less is more, and in software that usually means less work for the person using it.
From the start I wanted these apps to work as well offline as online, and I was building web apps that way in 2012, before progressive web apps had a name.
GeoLIS
A GIS application silo managers used every day to run their operations. It was one of my first enterprise projects, finished in 2009 while I was still a junior developer, and it was still in daily use more than ten years later. I’m quietly very proud of that one.
A Windows desktop app in WPF with the MVVM pattern and Dapper. It kept its data in SQLite and synchronised with SQL Server, so it carried on working offline, and its reports ran in SQL Server Reporting Services.
GeoFarm
A single-page application for agronomists, managing input budgets against what was actually spent, field by field on the map.
It started on AngularJS and was later upgraded to Angular 4, with NgRx for state and OpenLayers showing vector and raster data from GeoServer. ASP.NET Web API and SQL Server sat behind it, and Jasmine and Karma tested the components.
A few of the GIS problems I wrote up at the time, like getting MapGuide to serve SQL Server 2008 spatial data, filtered per user. They’re in the archive on Bits to Live By, kept as they were written.