Hacker News Reader

tnodiron SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers

> even if the server crashes, only the uncommitted transactions in the WAL are lost

I'm mainly referring to this quote.

So, you can lose committed transactions too.

tnodiron SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers

> PRAGMA synchronous = NORMAL;

> In NORMAL mode, the database engine syncs to disk only at critical moments (e.g., during checkpoints) rather than at every single transaction commit. In WAL mode, this is completely safe from database corruption; even if the server crashes, only the uncommitted transactions in the WAL are lost, but the database integrity remains intact.

No, this is not safe. You can lose the latest committed transaction with this pragma.

tnodiron Microsoft open-sources LiteBox, a security-focused library OS

It'll be interesting if MS allows to write e.g. WFP callout drivers via LiteBox and not requiring attestation signing. It'll still work in kernel mode, unlike NetworkExtensions in MacOS.

tnodiron SQLite Transactions

https://www.sqlite.org/isolation.html

"In WAL mode, SQLite exhibits "snapshot isolation".

When a read transaction starts, that reader continues to see an unchanging "snapshot" of the database file as it existed at the moment in time when the read transaction started.

Any write transactions that commit while the read transaction is active are still invisible to the read transaction, ..."

tnodiron Sljit: Platform independent low-level JIT compiler

> is sljit used in any larger projects?

https://github.com/PCRE2Project/pcre2/tree/master/src/sljit

tnodiron Ask HN: What apps have you created for your own use?

1. https://github.com/tnodir/fort - Fort Firewall for Windows 7+.

I needed:

- app groups to easily enable/disable group of programs - wildcards in program path names - efficient IP addresses blocking, as in PeerBlock - speed limiting - auto-apply program's rules to its child processes - control SvcHost services by service names - traffic statistics history

2. https://github.com/tnodir/luaplsql - LuaPlSql is a Lua Plug-In framework for PL/SQL Developer IDE.

I used it 10 years ago to write scripts in IDE for Oracle DB.

tnodiron Capy – Cross-platform library for making native GUIs in Zig

Also see https://github.com/frang75/nappgui_src

tnodiron Poor man's VPN (pay for only what you need)

https://sshuttle.readthedocs.io/en/stable/how-it-works.html

tnodiron Tldraw – a tiny little drawing app

Consider adding layers.