Better Dev Link

Rocket, SpaceX achievements are so greats. It would be really good to see how they built their software. StackOverFlow spoke with Steven Gerding, Dragon’s software development lead, about the special challenges software development has for SpaceX’s many missions. Don’t forgot part 2, Building a Space Based ISP

showcase a real-life example of debugging a seemingly weird database performance degradation. While I obviously intend to share the solution and what to avoid, I’d also like to take you through the journey and show you some tools & processes that can help you dig into SQL performance.

QuestDB billed itself as “the fastest open source time series database”, a very bold one. I can query 1.6mil rows in milliseconds. This is a high level overview of what they did to achieve that, The Problem with out-of-order data.

RedShift is almost de-factor Data Warehouse solution, especially for people already on AWS eco system. But what is for the rest of us who still on bare metal or run our own database on VM? What can we do to tune PostgreSQL for that purpose.

When you’re looking for that photo from a picnic a few years ago, you surely don’t remember that the filename set by your camera was 2017-07-04 12.37.54.jpg. Dropbox pore through all those images for you instead, and call out those which best match a few descriptive words that you dictated.

A Google engineer looks into website of F1 cars(Ferrari website, McLaren website etc) and compares them with the Google I/O website. It’s interesting to see what Google themselves do to their own site to improve performance

Multiplying huge integers of n digits can be done in time O(n log(n)) using Fast Fourier Transforms (FFT), instead of the O(n 2) time complexity normally required. In this paper we present this technique from the viewpoint of polynomial multiplication, explaining a recursive divide-and-conquer approach to FFT multiplication. We have compared both methods of multiplication quantitatively and present our results and conclusions in this paper, along with complexity analyses and error bounds.

curl is everywhere. any tools that usually has a download/install script start with curl. Daniel, author of curl was trying to explaining the main libcurl transfer state machine. Understanding the main transfer state machine in libcurl could be valuable and interesting for anyone who wants to work on libcurl internals and maybe improve it.