~betterdevlink | Issues #255 Apr 8, 2024 (18)

What even is a JSON number? Not a question people generally ponder, and seems fairly straightforward. It’s a number, obviously! But the question turns out to be somewhat hard to answer, and for API designers especially, the answer is really important to know!

Building My First Homelab Server Rack Michael share with us how he built his first homelab server rack, a genuine post without affiliate links so we know he wasn’t bias.

Using Multiple GitHub Accounts If you share laptop for home and work, or doing consultant for clients, you probably know the hassle of using different github account. This short guide help you configure just that, to make your life easiser by having git automatically load the right account based on directory.

Everything I know about SSDs Solid State Devices using NAND Flash, how they differ from Hard Drives, and how they affect file deletion and recovery

pid-controller explainer A PID controller is a way to solve problems with the following formulation: You can change some input to the system, called the process variable You have a sensor which monitors something about the system You want the sensor measurement to be close to some target value, called the set point The PID controller is a good way to decide what the...

Postgres Locks Explorer lock is a very powerful primitive. We use lock all the time in thread programming with mutex. Postgres offer locks to work as across server, so application can request lock and use the central Postgres server as a coordinator. This small website is like a flash card to review all different locks in Postgres.

Taming PostgreSQL WAL File Growth Have you ever wake up with an alert and look into Postgres datadir you notice pg_wal is growing massively in size? Read on to learn about why this happens, whether you should be concerned, and what you can do about it.

Optimizing SQLite for servers SQLite default config is optimized for embeded use case, so most people trying it will encounter poor performances and the dreaded SQLITE_BUSY error. However, you can configure SQLite to reach ~8,300 writes / s and ~168,000 read / s concurrently, with 0 errors, on a ~40€ / m commodity virtual server with 4 vCPUs

Linux networking This is somewhat a very low level. But recently I found I had not enough knowledge to understand networking at a very fundamental level. What exactly happen when we make a request, how the tcp connection is open, how the package is sent. how it picks which ethernet interface to send to? So I decide to google around and found this. I...

excelize Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

vernier Next-generation Ruby 3.2.1+ sampling profiler. Tracks multiple threads, GVL activity, GC pauses, idle time, and more.

pg_basebackup Since Postgres 12, it has built-in support to take a base backup of a PostgreSQL cluster. If you have been glueing together pg_dump, pg_restore, etc you will love this tool too. Pair it with an optinal compression setting to get the best compression rate.

doltgresql Imagine a Postgres with git style log, diff, branch, and merge functionality. This is just that. The company behind it originaly released a MySQL flavored, but now they are taming Postgres.

automq a cloud-native, serverless reinvented Kafka that is easily scalable, manage-less and cost-effective. It uses Object storage(s3, gcs) as the main storage. Using EBS for durable cache layer to accelerate write. It’s 100% compatible with Apache Kafka greater than 0.9.x and not lose any good features of it, but cheaper and better.

drawdb robust and user-friendly database entity relationship (DBER) editor right in your browser. Build diagrams with a few clicks, export sql scripts, customize your editor, and more without creating an account.

glimmer a DSL framework to build GUI app in Ruby. It contains a DSL engine to express he GUI, and a data binding lib to sync GUI with model attributes bidirectionally.