About Adam McKee.
I’m a software consultant in Raleigh, NC. For more than 25 years, I’ve built software for businesses, from founders’ first products to the systems enterprise teams depend on. My full history is on LinkedIn.
How I think.
Many of the decisions that matter come up before anyone writes code. Here’s an early decision I made on a construction software product I lead. It’s a mobile app for residential builders that keeps their teams updated in real time as their projects progress.
-
Find a platform that fits the need and the budget.
Our goal was zero loading spinners anywhere in the app, with all data always up to date. That meant enabling real-time data sync, supporting offline updates, and running a backend that wouldn’t eat the budget.
AWS was the safe pick: the industry standard, with a familiar relational database, a natural fit for data like ours. I chose Firebase. It syncs data in real time out of the box, keeps working offline, and catches up when the connection returns. Its database, Firestore, comes with a daily free usage allowance, so a small app like ours can stay cheap to run.
-
Make every change feel instant.
When someone signs in, the app pre-loads the data for their account and listens for changes. I built an optimistic cache on top of the listeners, so edits show up the instant they’re made. Sign-in costs a burst of reads, and the rest of the session is effectively free. At our size, that’s kept us within the daily free allowance about 95% of the time.
-
Take the trade-offs on purpose.
Our data is relational, and Firestore isn’t, so I had to design how our data is stored and retrieved carefully to keep costs and speed in check. There’s also some vendor lock-in to Firebase, and no failover yet. Those are calculated risks for a product our size.
-
A year later, it’s held up.
We have a handful of paying customers, some of whom needed the app to speak Spanish. We decided to make the whole app bilingual, and when we did, the data layer took the change without breaking a sweat. The whole infrastructure costs about $1.50 a month, and that’s mostly photo storage. Even with a hundred times the customers, the database would cost dollars a month. I’d make the same call today.
Tell me what you’re building.
A few sentences is plenty. I read every message myself.
Start a conversation