MySQL: Composite indexes in 5 minutes
How MySQL composite index column order affects query plans, range scans, and date filtering, with EXPLAIN examples and a date-column alternative.
Read the postWell, that escalated quickly.
Notes on code, startups, and the decisions behind the software. From our team in Cambridge, MA.
From the archive
343 posts
An Edge Case of Time in AWS PHP SDK
How a one-second timestamp rollover caused intermittent AWS S3 presigned URL failures in the PHP SDK, and how the SignatureV4 fix made relative expirations consistent.
Read the postElectron: Beating anti-scraping software with Electron
How Electron, a full Chrome environment, and Tor can handle JavaScript challenges, rotate IPs, detect captchas, and collect scraped data.
Read the postFrom Academia to Industry
A junior developer compares undergraduate computer science projects with industry work, covering collaborative version control, databases, queries, builds, and practical skills.
Read the postJointDJ.com: Collaborative Music Tech
JointDJ's collaborative music app lets groups queue YouTube songs, select exact video results, use genre-based auto-fill, and follow a redesigned live player.
Read the post