The Unreasonable Effectiveness of SKIP LOCKED in PostgreSQL

Using SKIP LOCKED to distribute work across machines in a distributed system is a popular pattern. We explore why, the alternatives, and a real world example from our own codebase.
Nadeesha Cabral on 17-12-2024

When building distributed systems that need to process jobs or tasks concurrently, one of the most challenging problems is ensuring that work is distributed efficiently without duplication. PostgreSQL's SELECT FOR UPDATE SKIP LOCKED feature provides an elegant and performant solution to this problem that almost feels too good to be true. We're big believers in the just use postgres ethos, as our source code might tell you.

ripgrep (rg)
ripgrep is a line-oriented search tool that recursively searches the current directory for a regex pattern. By default, ripgrep will respect gitignore rules and automatically skip hidden files/directories and binary files. (To disable all automatic filtering by default, use rg -uuu.) ripgrep has first class support on Windows, macOS and Linux, with binary downloads available for every release. ripgrep is similar to other popular search tools like The Silver Searcher, ack and grep.

Longhorn delivers simplified, easy to deploy and upgrade, 100% open source, cloud-native persistent block storage without the cost overhead of open core or proprietary alternatives.

Parquet devrait remplacer le format CSV

29 décembre 2022par Éric MauvièreCartographie, Outils, R8 commentaires

Parquet est un format ouvert de stockage de jeux de données. Créé en 2013 par Cloudera et Twitter, longtemps réservé aux pros du big data, il a beaucoup gagné en popularité ces derniers mois. Bien plus compact, super-rapide à lire, compris par davantage d’outils, Parquet est devenu une alternative crédible à l’omniprésent CSV.

A fast viewer for CSV and Parquet files and SQLite and DuckDb databases that supports large files.
pivot

It's a Pivot Table for analyzing and exploring data. Internally, Tad uses DuckDb for fast, accurate processing.
puzzle

Designed to fit in to the workflow of data engineers and data scientists.

About rclone

Rclone is a command-line program to manage files on cloud storage. It is a feature-rich alternative to cloud vendors' web storage interfaces. Over 70 cloud storage products support rclone including S3 object stores, business & consumer file storage services, as well as standard transfer protocols.

Rclone has powerful cloud equivalents to the unix commands rsync, cp, mv, mount, ls, ncdu, tree, rm, and cat. Rclone's familiar syntax includes shell pipeline support, and --dry-run protection. It is used at the command line, in scripts or via its API.

Users call rclone "The Swiss army knife of cloud storage", and "Technology indistinguishable from magic".

Rclone really looks after your data. It preserves timestamps and verifies checksums at all times. Transfers over limited bandwidth; intermittent connections, or subject to quota can be restarted, from the last good file transferred. You can check the integrity of your files. Where possible, rclone employs server-side transfers to minimise local bandwidth use and transfers from one provider to another without using local disk.

Alfred 5 for Mac
Alfred is an award-winning app for macOS which boosts your efficiency with hotkeys, keywords, text expansion and more. Search your Mac and the web, and be more productive with custom actions to control your Mac.

et ça aussi :-)

our shortcut to everything.

A collection of powerful productivity tools all within an extendable launcher. Fast, ergonomic and reliable.

Il faudre que j'essaye ca un jour

Self host Ente in 1 minute (1 command only!)
March 21, 2025
manav@ente.io

We have drastically simplified the getting started steps to lower the barrier to entry for people trying to self host Ente.

macmon – Mac Monitor

Sudoless performance monitoring CLI tool for Apple Silicon processors.

Finally, a command line shell for the 90s

fish is a smart and user-friendly command line shell for Linux, macOS, and the rest of the family.

The minimal, blazing-fast, and infinitely customizable prompt for any shell!

NAPS2 - Not Another PDF Scanner
Scan documents to PDF and more, as simply as possible.

NAPS2 is free and open source scanning software for Windows, Mac and Linux.

Easily scan with devices from Canon, Brother, HP, Epson, Fujitsu, and more. Then save to PDF, TIFF, JPEG, or PNG with a single click.

Dialyzer (DIscrepancy AnaLYZer for ERlang programs) is a powerful static analysis tool that helps developers identify potential issues in their Elixir code without executing it. It excels at finding type mismatches, unreachable code, and unnecessary functions through sophisticated flow analysis.

Recently, I had discussions with several friends and colleagues about interviewing for software engineering roles, from entry level to senior levels. Some of them were going through interviews right now, and others asking about how to get better in interviewing in general.

So, I decided that instead of copy pasting resources every time, and having the same discussions repeatedly, I should write an article putting down all the generic advice I would give them. This way, our 1:1 discussions could focus on the specifics of their role, company, and skill-set instead.

difftastic
a structural diff tool that understands syntax

Difftastic is a CLI diff tool that compares files based on their syntax, not line-by-line. Difftastic produces accurate diffs that are easier for humans to read.

wine + macos + games

Le prix des autoroutes est élevé en France. Afin de réduire le coût de votre passage au péage, il existe une solution simple (et légale) qui consiste à fractionner vos paiements...

Si vous allez de la sortie 1 à 10, il peut-être avantageux de sortir à la sortie 6... et de re-rentrer aussitôt sur la même autoroute.

un super outils pour faire plein de manipulation sur les data, depuis le browser, en local

I present to you my complete and working guide to installing NixOS on a Raspberry Pi 4. I’m a newcomer to NixOS, so this guide is for Nix beginners, but I assume you have basic familiarity with Raspberry Pi and Linux.