339 private links
SQLite lessons:
- The SQLite gem supports user defined functions (udfs) and we used it to implement some missing functions in SQLite like regexp, if and stddev so that we wouldn't have to deal with too many sql migration workarounds.
- SQLite doesn't support unsigned bigints. Previously, the mariadb was using unsigned bigints for certain ids, so we had to switch those to bigints for the migration.
- Collation in SQLite is rather weak compared to MariaDB. Lobste.rs used utf8mb4_general_ci in MariaDB, but used NOCASE in SQLite. The downside of NOCASE is that it only supports ASCII characters, not the full UTF case folding.
- Use the preferred Contentless-Delete Tables in SQLite for your full text search tables. These are not the default. I'm constantly surprised by the default choices of SQLite.
[...]
Overall lessons:- I think a key ingredient in making this work was good communication from everyone that participated. I don't think this would have been possible otherwise.
- Migrating the underlying database without having access to the production database is really hard to get right. This was my first underlying database migration without having access to production. One lesson I'll take away from this is that I'll make sure to have realistic dataset sizes before doing another underlying database migration in the future.
Wishes:
- I wish we could say in a test, "Fail if you encounter any full table scans". Which would have caught the perf issues we experienced during the first deploy.
- I wish creating a production like dataset would be much easier than having to manually write something and waiting a week.
By the main developer of the Zig language
This repository is a place to collect together arguments for not breaking TLS. By "breaking TLS" I mean significantly weakening the protocol, or implementations or deployments of the protocol, so that the security claims made in the protocol specification can no longer be credibly maintained.
Google annonce documents à l'appui que le blocage DNS ne sert à rien, et provoque des dégâts collatéraux.
Maintenant, c'est vrai que Google ne joue pas les chevaliers blancs par pure bonté d'âme. En fait, ce qu'ils défendent, c'est leur résolveur maison, leur cloud et leurs clients. Elle reste par exemple très silencieuses sur tous les projets de loi de blocage qui avancent en ce moment même au Congrès américain.
À vendre
Ce domaine de marketing est à vendre : toute offre supérieure à 25 000 € HT sera prise en considération. Veuillez envoyer votre proposition avant le 21 juillet 2026 à l’adresse servicedesk@score-worldwide.com. Nous avons légèrement prolongé le délai afin de donner à RN ou à Marine Le Pen l’occasion de présenter une proposition sérieuse.
Bring the old Youtube-style back
The project support project target dir selections compared to cargo-clean-recursive.
La prise en saillie devient le nouveau standard.
En 2025, le nombre de vues à reculé de 8%.
Wikipédia utilise des accords pour se financer par les géants de la tech.
Wikipédia a d'ailleurs un compte TikTok https://www.tiktok.com/@wikipedia et Instragram https://www.instagram.com/wikipedia/
It's a 9MB binary that can run npm packages.
The packages can live on ants.land.
The startup time is two times faster than Ant, 4.5 faster than Deno and 5.22 faster than NodeJS.
How to architecture a website built before deployment. The pros and cons. How to build the content with Next.JS
Note it was a talk in 2025/2016
Erase a subject from a picture in the browser.
(via https://korben.info/inpainting-image-navigateur-local.html)
Le compteur de prend pas en compte les bots en eux-mêmes.
Il utilise pour cela un token API cloudflare, un script qui se lance régulièrement et un bout de JS pour charger ce nombre et l'insérer dans toutes les pages.
Basique.
J'aime pas devoir dépendre du seigneur Cloudflare cependant.
It should work with a Tailscape IP (or VPN) for example to be accessible from the Internet.
It's a set of tools to protect a webserver.
- USB: If the USB stick is removed, the LUKS keys are erased and the computer rebooted (it's smilar to a formatting of the hard drive because the data can not be decrypted anymore).
- Dead man switch : If a signal is not sent to a service every 24 hours, the similar operation occurs: Keys are erased and the server reboots.
It's kind of like in spy movies when you don't want your data to fall into the wrong hands.
Open Systems Theory is a body of knowledge developed over fifty years of research and practice. It explains how organisations interact with the environments around them — and how to design them so they thrive.