data management

I’ll show you how I built a command-line utility using .NET Core and C# to track my Tesla by leveraging a reverse-engineered REST API. This project lets you authenticate via OAuth2 and retrieve real-time vehicle data like location and velocity, even without official SDK support.

If you are looking to visualize personal wellness data from the Oura Ring in Power BI, this post details my process for building a custom connector that supports OAuth2 authentication. I share how I overcame the limitations of standard JSON connectors to create a solution that automatically pulls live data from the Oura API, offering steps that are applicable to any custom API integration.

I explain how I designed and built a custom content editor to streamline writing for my Astro-based blog, specifically to handle metadata and store images in Azure Storage while keeping Markdown files in GitHub. By leveraging AI-assisted engineering rather than random "vibe coding," I created a user-friendly, offline-capable tool that simplifies the publishing process and makes content creation more efficient.

I share my experience building a custom Twitter analytics tool because the platform's limited 28-day analytics window frustrated my desire for deeper historical insights. I detail my initial attempts to use Azure Logic Apps, highlighting the challenges posed by strict API rate limits that prevented successful data retrieval. This post explains why I pivoted away from Logic Apps and considered Azure Functions to overcome these technical hurdles.

I explore the modern shift from legacy FTP to SFTP for secure data ingestion into Azure Storage Accounts, highlighting why this new preview feature simplifies integrating external CSV data. By enrolling in the public preview, you can leverage SSH-based secure transfers directly within Azure Storage, offering a more robust alternative to the cumbersome FTPS setup in App Services.