Rémi Bardon

Recently published

1. TIL: Debian Trixie uses a new format for APT Sources

   Since February 2025, Debian 13 (Trixie) and APT introduced the deb822 format for managing APT sources. It is more structured and readable than the previous sources.list format.

2. TIL: sqlx can insert 100 000 BLOB fields in <200ms

   It only takes Rust’s sqlx crate around 200ms to insert a JSON array of 100 000 32 bytes BLOB fields, and only 1.2s when inserting one by one in a transaction!

3. TIL: SQLite in-memory databases with shared cache

   In SQLite, each connection to a :memory: database is isolated, but one can have two connections pointing to the same in-memory database by using file:filename?mode=memory&cache=shared!

4. TIL: Prosody can automatically read environment variables

   Environment variables can be referenced directly in a Prosody configuration file, using the ENV_ prefix: example_setting = ENV_EXAMPLE_ENV_VAR!

5. TIL: assert_no_alloc: A Rust crate to catch unexpected memory allocations

   The assert_no_alloc Rust crate allows temporarily disabling memory (de)allocations for a thread, to abort or print a warning instead. This helps catching unexpected (de)allocations to improve performance.