Techreport blog

Engineering Insights & Guides

The best problem-solving writing in software engineering — databases, performance, security, frontend and distributed systems, in one feed.

11,847 articles
Databases — Lessons Learned Running Presto at Meta Scale - High Scalability -

Lessons Learned Running Presto at Meta Scale - High Scalability -

Presto is a free, open source SQL query engine. We’ve been using it at Meta for the past ten years, and learned a lot while doing so. Running anything at scale - tools, processes, services - takes problem solving to overcome unexpected challenges. Here are four things we learned while scaling up Presto to Meta scale, and some advice if you’re interested in running your own queries at scale. Scalin

PBPhilip Bell·July 16, 2023Databases
Engineering — Release Radar

Release Radar

It’s been a while since we’ve published our Release Radar. You can blame IRL conferences coming back, getting influenza, and being struck down by the weather. But those are just…

MDMichelle DukeMichelle Duke·July 13, 2023Engineering
Career & Teams — (De)coding conventions

(De)coding conventions

Navigating the ebb and flow of programming paradigms–from the shifts in the JavaScript ecosystem and TypeScript’s rise, to AI’s role in advancing accessibility, and strategies for encouraging non-code contributions–tune in to the latest episode of The ReadME Podcast for more.

MWMartin Woodward, Neha BatraMartin Woodward, Neha Batra·July 13, 2023Career & Teams
SRE & Ops — Moving from a product to a service mindset

Moving from a product to a service mindset

Thanks to DevOps, cloud computing and other industry trends, many organizations are shifting from a product mindset to a service mindset. Here’s how you can implement a service-led strategy.

CRChris ReddingtonChris Reddington·July 13, 2023SRE & Ops
Engineering — PostGIS, ArcGIS Enterprise and the Tour de France route

PostGIS, ArcGIS Enterprise and the Tour de France route

How to analyze a stretch of the Tour de France in a hybrid environment, ArcGIS Enterprise & PostGIS - we’ll utilize PostGIS native geometry types instead of ESRI geometry types to analyze this challenging stage both in ArcGIS Pro and PostGIS

FNFlorian NadlerFlorian Nadler·July 12, 2023Engineering
Performance — GitHub Availability Report: June 2023

GitHub Availability Report: June 2023

In June, we experienced two incidents that resulted in degraded performance across GitHub services. June 7 16:11 UTC (lasting 2 hours 28 minutes) On June 7 at 16:11 UTC, GitHub…

JOJakub OleksyJakub Oleksy·July 12, 2023Performance
Engineering — The day my ping took countermeasures

The day my ping took countermeasures

Ping developers clearly put some thought into that. I wondered how far they went. Did they handle clock changes in both directions? Are the bad measurements excluded from the final statistics? How do they test the software?

MMMarek MajkowskiMarek Majkowski·July 11, 2023Engineering