Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
tnodir
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
tnodir
2mo ago
> 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.
2.
▲
by
tnodir
2mo ago
> 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
3.
▲
by
tnodir
8mo ago
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.
4.
▲
by
tnodir
2y ago
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 a
5.
▲
by
tnodir
2y ago
> is sljit used in any larger projects? https://github.com/PCRE2Project/pcre2/tree/master/src/sljit
6.
▲
by
tnodir
3y ago
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 PeerBl
7.
▲
by
tnodir
4y ago
Also see https://github.com/frang75/nappgui_src
8.
▲
by
tnodir
5y ago
https://sshuttle.readthedocs.io/en/stable/how-it-works.html
9.
▲
by
tnodir
5y ago
Consider adding layers.