Adventures with ChatGPT
December 16, 2022ChatGPT is incredibly impressive but it's easy to poke through the facade
ChatGPT is incredibly impressive but it's easy to poke through the facade
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