Debugging random slow writes in PostgreSQL
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.
Using PostgreSQL as a Data Warehouse
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.
How image search works at Dropbox
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.
Performance-testing the Google I/O site
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 using fourier transforms
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.
The libcurl transfer state machine
curl is everywhere. any tools that usually has a download/install script start with
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.
Code to read
Go package implementing Bloom filters
A Ruby library that encodes QR Codes
A front-end game engine specifically for creating interactive game projects.
an open-source Python library that lets you create custom interactive web apps and dashboards by connecting user-defined widgets to plots, images, tables, or text.
an open benchmark for procedural workloads in RDBMSs
One Stop Anomaly Shop (
Anomaly detection using two-phase approach: (a) pre-labeling using statistics, Natural Language Processing and static rules; (b) anomaly scoring using supervised and unsupervised machine learning.
If you read manga, this terminal based app blow your mind. You can access mangadesk without all the non-sense stuff from a normal webapp
provide a simple authentication system. support OAuth2, MFA, permissiion model, registration, lost password etc
Postgres to elasticsearch sync. Make it easiser to search some data with minimal effort on your backend
the easy, secure way to log in to your Kubernetes clusters. including support for OpenID Connect.
A concise API for exploratory data visualization. Could be very useful to quickly add some nice charts to your app :-).
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this