Daily Shaarli

All links of one day in a single page.

July 18, 2026

Joshua Khane (@JoshuaKhane): "Microsoft DELETED my account AND OneDrive!!?? After ACKNOWLEDGING that I’m the owner of the account and that it was compromised??? 25 fucking years of data, thousands of euros spended on games?? My son’s baby pictures? GONE! All because MICROSOFT couldn’t bring back a compromised account?? One of the biggest companies ever coulnd’t do that so they just deleted that shit like it was nothing?? Fucking shame on you!! @microsoftnl @MicrosoftHelps @MicrosoftHelpt @Microsoft #microsoft #hacked" | XCancel

Microsoft DELETED my account AND OneDrive!!?? After ACKNOWLEDGING that I’m the owner of the account and that it was compromised???

25 fucking years of data, thousands of euros spended on games?? My son’s baby pictures? GONE!

All because MICROSOFT couldn’t bring back a compromised account??
One of the biggest companies ever coulnd’t do that so they just deleted that shit like it was nothing?? Fucking shame on you!!

Ban on destruction of unsold clothes and shoes enters into application - Environment
Grâce à ses centrales nucléaires, EDF peut aussi refroidir les fleuves

Ainsi, les eaux de la Vienne affichent 28,49 °C en amont de la centrale et « seulement » 27,93 °C en aval, après avoir été mélangées à une eau rejetée à 24,65 °C.

No, People Don’t Want More AI In Their Life — Smashing Magazine

I 100% agree.

It's useless to argue with "by AI". What is it solving for me? Is it good and reliable for me?

And it doesn’t really matter if these features are branded as “AI”, “smart” or “automation”. However, they must work well for people using them. And that means that people must be aware of use cases where it actually helps them, and be inspired to find more use cases on their own.

Half a Second

About the xz backdoor

IPV6: la France devient championne du monde des activations, Free n'y est pas pour rien

La transition vers IPv6 s’accélère en France, portée par les efforts des opérateurs comme Free. D’après l’Arcep, la France est devenue en juin 2025 le pays le plus avancé au monde en matière d’adoption du nouveau protocole internet.

De 20% à 87% fin 2024, pour atteindre 98% selon les estimations pour fin 2017.

Cependant, 35 % des sites en .fr, .re, .yt, .pm et .wf sont accessibles en IPv6 fin 2024. Pire encore, la messagerie électronique associée à ces noms de domaine n’est compatible qu’à hauteur de 23 %.

Rust for offline development? : r/rust

TL;DR yes.

  • creates-mirror
  • cargo doc
  • cargo add <crate> --offline from the global cache registry
SQLite Is All You Need - DB Pro Blog

The short version: one file, one process, and the heaviest page in the app served 315 million requests a day on a M1-laptop. For almost anything you are building, SQLite in WAL mode is enough, and the Postgres container you spun up out of habit was never needed.

The SQLite setup:

const db = new Database('chirp.db');
db.pragma('journal_mode = WAL');       // readers and the writer stop blocking each other
db.pragma('synchronous = NORMAL');     // fsync at checkpoints, not on every commit
db.pragma('busy_timeout = 5000');      // wait for the write lock instead of throwing
db.pragma('foreign_keys = ON');        // off by default, which surprises people
db.pragma('cache_size = -64000');      // 64MB of page cache

Under WAL, across every scenario, zero SQLITE_BUSY errors. Not "few." Zero.

Limits of SQLite:

  • Reads stop scaling once anything writes.
  • There is only one writer.
  • One machine: the recovery time is always the time needed to restore a file.

Reach for Postgres when you have many writers contending on the same rows, when you need read replicas or automatic failover, when you need a real analytics engine over hundreds of millions of rows, or when your team genuinely needs the extension ecosystem. Those are real reasons."

Advantages of SQLite:

  • Backups are a file copy. From the shell: sqlite3 chirp.db "VACUUM INTO 'backup-$(date +%F).db'"
  • Local development is one file.
  • Resetting the database is rm
  • Tests get a real database each
  • Deploys are a binary and a file
  • There is nothing to operate

To optimize SQLite:

  • focus on single-core speed
  • buy enough RAM to hold the database: wait for GBs
  • local NVMe. Never put SQLite on network storage.
  • Pay for a dedicated core if you care about p99.
  • Use strict tables
  • Only INT, INTEGER, REAL, TEXT, BLOB, and ANY are allowed, and ANY is there when you actually want a key-value column. Store your JSON in a TEXT column and use the JSON functions on it.
  • Prepare every query on startup. Making it on every request is a way to make SQLite look slow

The hardest part is user acquisition either way. Don't loose time on operations.

The reflex to start with a database server is a habit, not an engineering decision. It made sense when SQLite did lock the whole file on every write. That stopped being true a long time ago, and the tooling caught up: WAL for concurrency, STRICT for type safety, Litestream for replication.