A developer reflects on 20 years of blogging about tech topics like Columnstore Indexes, Vector Indexes, AI, and Product Management.
A developer reflects on the first year of their tech-focused newsletter, sharing growth stats, key lessons learned, and strategies for consistent content creation.
Explores implementing a data mesh architecture using dbt, outlining how dbt Mesh projects can align with data mesh principles for large-scale organizations.
Demonstrates a 6x speedup for analytics queries using EDB Postgres Distributed's new analytics engine compared to the standard Postgres engine.
Discusses the risks of running analytics on operational databases and offers solutions to separate workloads.
A developer built stats.store, a free, open-source, privacy-first analytics backend for Sparkle-based Mac apps, avoiding invasive tracking.
A tool for calculating SaaS churn rate, revenue leakage, and annual loss, with suggestions for improving customer retention.
A data-driven analysis of the AWS News Feed's performance and user engagement during AWS re:Invent 2024, highlighting traffic, features, and release volume.
A developer reflects on reaching 1 million blog page views, discussing their blogging journey, static site tooling, and evolution of technical content.
Explores the differences between event and entity data modeling, when to use each approach, and practical design considerations for structuring data effectively.
Explains the data lakehouse architecture, its layers (storage, table format, catalog, processing), and its advantages over traditional data warehouses.
A data engineer reflects on their 2-year career journey at the City of Boston, sharing lessons learned in data warehousing, ETL, and civic tech.
An introduction to analytical data warehouses, explaining their purpose, differences from transactional databases, and their role in team-based analytics.
A developer's perspective on the challenges and purpose of implementing analytics and tracking in software features.
A guide for iOS developers on implementing private analytics using TelemetryDeck SDK, covering setup and basic event tracking.
Explains survivorship bias in web performance, using examples like Project Feather to show how missing data from failed users skews metrics.
A developer introduces Webmention Analytics, a tool for visualizing and filtering webmention data from webmention.io to combat spam and gain insights.
An update on TinyPilot's 5th month, covering a 20% revenue increase, the launch of a new pre-assembled Voyager model, and a new paid course.
A developer analyzes a third-party widget causing severe performance issues, blocking the main thread for 2.5s on a high-end laptop and 48.6s on a low-end Android device.
