SQLite can be used for many many applications.

Full-Text Search, JSON, high volume time serie data, Queue, Vector database, Cache (redis), file system (file under 100kB), graph database.

and again: the DB can fits in RAM or doesn't need a server. It's a simple file and avoid network requests for everything!

About some comparison:

For blobs under roughly 100KB, SQLite reads and writes faster than individual files on disk, and uses about 20% less space on top of it. The reason is that the file system charges you an open() and a close() and a directory traversal per item, while SQLite charges you one already-open file handle and a B-tree seek.
And here’s the kicker: a Redis GET over localhost is on the order of 100 microseconds. A SQLite point lookup against a warm page cache is on the order of 1 microsecond.

Using DEBUG compilation slows down the compilation by nearly ~40 times.

Why ?
LLVM represents variable locations through DBG_VALUE records. Heavy function inlining can create hundreds of thousands of these records in a single function.

WebAssembly’s Register Stackify pass moves values from virtual registers onto the operand stack to produce compact, efficient wasm. While moving instructions, it repeatedly scans basic blocks to find and update debug records. Those linear scans are repeated for many definitions, while the pass also leaves invalidated records behind and creates new records for duplicated cheap computations. The result is quadratic work on increasingly large instruction lists.

As example:
Module: repro total codegen
Current Rust: 52.58s
LLM fix:7.12s
Author fix: 1.99s

A board shared in real time with many users

XCF has been GIMP’s primary project format since 1997, and it has served many users well. Over time however, we’ve observed more and more limitations of the binary XCF format. Among other issues, it does not easily support very large or complex projects, such as the multi-page and animation features currently planned for GIMP 3.6.

The new project file format will follow a more common “zipped XML” structure. While the technical details are still being designed and implemented, this change will allow for faster saving since we’ll only need to update parts of the file instead of the whole thing each time. It will also set the stage for much desired features such as auto-saving, which will now be much more feasible.

Non destructive layer masks are also a great feature. PSD support improvements.

Another feedback about using plain text to keep track of the finances.

The tool used with the plaintext format is https://hledger.org/index.html

• <details>
• popover
• grouped <details>
• command & commandfor
• native input pickers
• <datalist>
• loading="lazy"
• hidden until-found

Eh oui c'est inutile en fait. Dans la plupart des cas, connaître le sexe de l'individu est inutile.

How much pressure will Google put on Firefox?

A collection of spinners created by state (thinking, searching, working, listening, composing, done). There are three types of spinner groups: Academy, Grid and Tape.

Témoignage d'un ancien ingénieur d'Azure (le cloud de Microsoft). Apparemment, Azure est vraiment un feu de poubelle, monté à la va-vite pour concurrencer Amazon AWS, sans réelle vision. Situation aggravée par le fait que les ingénieurs séniors - ceux qui maitrisaient vraiment le truc - se sont barrés, et le fait que Microsoft préfère investir dans l'IA que dans les personnes.

Partie 1 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion
Partie 2 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion-8f4
Partie 3 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion-f67
Partie 4 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion-2f5
Partie 5 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion-841
Partie 6 : https://isolveproblems.substack.com/p/how-microsoft-vaporized-a-trillion-b73

(via https://sebsauvage.net/links/?qnz_0A)

Similar to Signal

"AI” has only accelerated this trend. These days, you’re lucky to get a pull request from a real human being. Discussing changes is no longer fun when you’re talking to a bot 90% of the time.

I hope someone builds a community for developers; we need one now more than ever.

Another major outage

L'Amende Forfaitaire Délictuelle (AFD) punit un délit, entraîne une inscription au casier judiciaire (bulletins 1 et 2 si on ne la paye pas dans les temps), de 800-900€ à 3000€ et elle ne peut pas être contestée comme une amende classique.

Elle est délivrée par un policier de la police nationale.

1. En théorie, il est donc possible de refuser une Amende Forfaitaire Délictuelle et le refus de la signer devrait en être une preuve. En pratique, les flics mettent la pression et te font parfois signer des papiers sans dire ce que c’est. C'est prendre le risque d'être enmené en garde à vue ou d'être convoqué pour un procès ultérieurement.
2. L’agent ne peut pas non plus donner d’AFD si plusieurs infractions sont constatées simultanément dont au moins une ne peut faire l’objet d’une procédure d’AFD. De même, cette procédure n’est pas censé être possible s’il y a besoin de plusieurs PV pour caractériser l’infraction.

Le billet de blog renseigne comment contester une telle AFD.

Et conseille de se rapprocher de https://rajcollective.noblogs.org/ au besoin.