SQLite may not have dedicated datetime data types, but that doesn’t mean we have to restort to queries filled with meaningless numbers and post-processing datasets in application code. Here we’ll take a look at a real world use case for SQLite’s datetime functions and see how they can make working with dates easier.
Cashapp’s SQLDelight, a great ORM-like library for Android apps and SQLite, recently extracted it’s database driver to support other types of databases, opening it up to other use cases. Here are some tips from my recent experience deploying SQLDelight in a web app.
While simplifying and modernizing my website I realized that I don’t need anything as invasive as Google Analytics, so switched to server side analytics. Here I detail what I tried, and the docker container I ended up building to support automatic, robust, server side analytics.
After reading a recent post by Sam Edwards detailing how he wraps mock objects for tests, I had a good discussion with him and others about the alternative: simply making Fake implementations.
How my experience as a freelancer changed my perspective on hiring and employment.
Properly scoping objects in Android apps to avoid memory leaks and avoid repeating work can be challenging. Let’s take a look at some ways that this could be done in the past, and also an approach that is clean and simple, but isn’t tied to the Android framework.
Some data communicated between view models and views shouldn’t be restored. Here’s a look at a simple way to deliver these transient events, avoiding complexity and common bugs.
This article looks at an approach to encapsulate view state, allowing us to move more logic into our more easily testable ViewModel classes, and simply our views.
Using a build cache can speed up builds a great deal. Here’s a look at how to enable a build cache in Google Cloud Build.
Many CI services use an incrementing build number to identify builds. Google Cloud Build, however, uses a randomly assigned unique identifier, as is common in large scale systems. In this article we take a look at how to support incremented build numbers in Google Cloud Build.