> 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.
> 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…
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.
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…
> is sljit used in any larger projects? https://github.com/PCRE2Project/pcre2/tree/master/src/sljit
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 -…
Also see https://github.com/frang75/nappgui_src
https://sshuttle.readthedocs.io/en/stable/how-it-works.html
Consider adding 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.
> 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…
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.
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…
> is sljit used in any larger projects? https://github.com/PCRE2Project/pcre2/tree/master/src/sljit
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 -…
Also see https://github.com/frang75/nappgui_src
https://sshuttle.readthedocs.io/en/stable/how-it-works.html
Consider adding layers.