Mark Watkinson

Making your applications more reliable by keeping track of long running database transactions

Understanding the lazy nature of IEnumerable to make your code more efficient

The surprising demise of one of the better jobs boards

Using ADO.NET Data Readers for fun and/or profit

Optimizing the UI responsiveness of Angular applications slowed down by unnecessary component change detection

Extracting individual words from a sentence without spaces, in JavaScript/Node

Thoughts on managing inevitable quality issues in dependencies in the Ionic/Cordova/Capacitor ecosystem

Setting up Google Drive integration for an Android app is not an obvious process, but it's relatively straightforward.

An approach to handling database deadlocks in high transaction systems in Node.js

MySQL's ST_Distance_Sphere function is used to calculate distances between points on a sphere. Unfortunately, it's missing from MariaDB, but it's relatively easy to implement as a stored function

Using MySQL's spatial data types for processing real world location data, in terms of latitude/longitude or GPS coordinates

Android recently pushed a faulty update to the WebView component, which broke a surprising number of popular apps that you might expect to be native

Using spaCy from Node.js, or running arbitrary Python programs from Node, is surprisingly easy