Profile icon
David Burton
Data Scientist
Home
Interactive Dashboards
Data Science & ML
Engineering & Automation
Research & Writing
Back

Research & Writing

Explore my technical writing, data analysis notebooks, and research on data science, machine learning, and system optimization.

Browse by Topic

Machine Learning 2 Database Performance 4 Data Visualization 1 Data Engineering 1 System Optimization 6 Trading & Finance 2 DevOps 1 Automation 1 NLP 1

Articles

Building Atlas Forecasting System: Production ML Deployment at Scale (Part 2)

October 3, 2025 📝 Blog

Deep dive into deploying a production ML forecasting system processing 542,000 rows/second with real-time regime detection, async service architecture, and comprehensive health monitoring.

topic:machine-learningtopic:trading-financetopic:system-optimizationlang:pythonseries:atlasseries:ml-deploymenttype:case-studylevel:advanced

Optimizing Atlas Trading System: 810X Database Performance Improvement (Part 2)

October 3, 2025 📝 Blog

Deep dive into optimizing a production trading system's database initialization from 6.6 seconds to 8.2ms, unblocking 37 critical features and restoring real-time trading capability.

topic:database-performancetopic:system-optimizationtopic:trading-financelang:pythondb:duckdbseries:atlasseries:database-optimizationtype:case-studylevel:advanced

ML Deployment in Production: A Comprehensive Reference Guide (Part 1)

October 3, 2025 📝 Blog

Complete technical reference for deploying machine learning models to production, covering serving architectures, containerization, lifecycle management, performance optimization, and operational monitoring.

topic:machine-learningtopic:devopslang:pythonframework:dockerframework:kubernetesseries:ml-deploymenttype:reference-guidelevel:intermediate

Database Performance Optimization: A Practical Reference Guide (Part 1)

October 8, 2024 📝 Blog

Comprehensive reference for optimizing database performance in production systems, covering SQLite configuration, schema design, indexing strategies, transaction management, and monitoring.

topic:database-performancetopic:system-optimizationlang:pythonlang:sqldb:sqlitedb:postgresqlseries:database-optimizationtype:reference-guidelevel:intermediate

Database Optimization: A Practical Reference Guide

October 4, 2025 📝 Blog

Comprehensive reference for database optimization techniques, from predicate pushdown to result caching. Includes performance impact tables and code examples.

topic:database-performancetopic:system-optimizationlang:rusttype:reference-guidelevel:advanced

Replacing DuckDB: 10x Performance with Rust and Predicate Pushdown

October 4, 2025 📝 Blog

How a custom Rust query engine replaced DuckDB and achieved 10.4x speedup through predicate pushdown. Covers 5 optimization iterations with real metrics.

topic:database-performancetopic:system-optimizationlang:rusttype:case-studylevel:advanced

Transform Your Data Visualizations with Cinematic Styles in Python

January 15, 2025 📝 Blog

Learn how to create stunning data visualizations inspired by iconic films using the Cinestyle library. From Film Noir to Star Wars, transform your matplotlib charts into cinematic masterpieces.

topic:data-visualizationlang:pythontool:matplotlibtool:pandastype:tutoriallevel:beginner

Building a High-Performance B2B Lead Generation Pipeline with Local AI

August 14, 2024 📝 Blog

How I built an AI-powered data pipeline that extracts 296 businesses from Chamber of Commerce directories in 9 minutes, achieving 100% name/phone capture using local LLMs and intelligent web scraping.

topic:data-engineeringtopic:automationtopic:nlplang:pythontype:case-studylevel:intermediate

Prioritizing Processes on Your Mac: Boosting Performance Through Smart Management

July 26, 2024 📝 Blog

Learn how to optimize your Mac's performance through strategic process prioritization, including practical techniques with command-line tools and best practices for resource management.

topic:system-optimizationtype:tutoriallevel:beginner