Blog

Here is some interesting papers I’ve read this year. Weaponizing Middleboxes for TCP Reflected Amplification https://www.usenix.org/system/files/sec21-bock.pdf This paper uses the fact that some middleboxes are non-compliant TCP stacks. In particular, middleboxes sometimes see only one side of a connection and as a result, it’s possible that they answer spoofed packets. After an initial training (with a genetic algorithm) on a subset of known censoring networks to optimize amplification factors, the authors present the results of applying this to the whole IPv4 internet....

SQL pragma are statements (like SELECT … or CREATE TABLE …) that change the database behaviors or call a special functions. This post is a short list of SQLite pragma I use in my projects built on SQLite, to get better performance and more consistency. TL;DR When Opening the DB PRAGMA journal_mode = wal; -- different implementation of the atomicity properties PRAGMA synchronous = normal; -- synchronise less often to the filesystem PRAGMA foreign_keys = on; -- check foreign key reference, slightly worst performance and check user_version....

Posts about my keyboard-centric configuration