User-defined Order in SQL
How do you design a system that allow user to define their own ordering of item in SQL. The challenge is that the order is arbitrary and can change when the user rearranges items.
Building DigitalOcean's API gateway
The history of building DigitalOcean’s API gateway. How we made it easier for folks to build new microservices instead of continuing to add code to our monoliths, the successes, failures and lessons learned. We all learn from real world experience by looking at how major companies do a certain things.
Always-on Time-series Database: Keeping Up Where There's No Way to Catch Up
As a thought exercise, consider this for a moment: What if, as a core business requirement, you found you needed to provide for the capture of data from disconnected operations, such that updates might be made by different parties at the same time—or in overlapping time—without conflicts? what if your service called for you to receive massive volumes of data almost continuously throughout the day, such that you couldn’t really afford to interrupt data ingest at any point for fear of finding yourself so far behind present state that there would be almost no way to catch up
Your legacy database is outgrowing itself
How do you scale database for a website that is rank 215th on the world by alexa. They got over 4M unique daily users and over 7B queries hitting all our MySQL databases combined.
Re-Introducing Hash Indexes in PostgreSQL
B-Tree is the defactor index type. There is another type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index.
SSL incident of Algolia
TLS and Public Key Infrastructure is hard. What do you do when the root certification authorities expired.
A lesson from Algolia team on solving an incident When things don’t work completely, it is often easier to identify what does not work rather than in situations when some things work and some things don’t.
Discovering and exploring mmap using Go
how to deal with data in disk that is bigger than the available memory? One of the ways a database storage engine can solve the larger than memory problem is to make use of virtual memory and the concept of memory-mapped files. This uses Go as an example but you’re free to use any language. The core idea is to learn aboit syscall of mmap
Code to read
Turn your own kindle into an information panel summarizing my day such as my calendar, surf and weather forecast, garbage schedule, school closures, etc.
A pure Ruby code highlighter that is compatible with Pygments
Simple HTTP and REST client library for Go
a distributed POSIX file system built on top of Redis and S3.
Executes commands in response to file modifications
Cloudsplaining is an AWS IAM Security Assessment tool that identifies violations of least privilege and generates a risk-prioritized report.
Detect, track and alert on infrastructure drift
Simple backup script for PostgreSQL
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this