tnodir

Joined 5 years ago

Karma

Submissions

Member since

Nov 18

View on Hacker News

Recent submissions

Comment · 3 months 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.

Comment · 3 months 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 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.

Comment · 8 months 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.

Comment · 2 years 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 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, ..."

Comment · 2 years ago

> is sljit used in any larger projects?

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

Comment · 2 years 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 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.