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.

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.

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

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.

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.

A checklist to help you secure your Github repository

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.

A 5 parts serie about building HTML form properly and best practices: Semantics, Accessibility, Styling, User Experience and Security

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