Amazon Athena and Amazon Redshift - Overview and Comparison
How Amazon Athena and Redshift differ in setup, querying, performance, data types, cost, and scalability, including when Redshift Spectrum fits.
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
344 posts
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 postAn 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 post