Sivaprasad Murali

An index access method for LIKE and ILIKE in PostgreSQL.

Biscuit records which character sits at which position in every indexed string, counting forward from the start and backward from the end, plus length bitmaps. It answers an anchored pattern by intersecting a fixed number of bitmaps. The results are exact, so PostgreSQL never has to recheck rows against the heap.

-- load first, then index
CREATE INDEX idx_users_name ON users USING biscuit(name);
SELECT * FROM users WHERE name LIKE '%son';

[ Source | Docs | PGXN | Talk materials ]

Deterministic fault injection for PostgreSQL.

Error paths are the least-tested part of most database code. With Macavity, a session arms a fault at a named execution point and chooses the exact occurrence where it fires. The fault can be an error, a one-second delay, or an unclean backend crash. That turns “what happens if commit fails?” into a repeatable test.

SELECT macavity_arm('before_commit', 'error', 3);
-- the third commit in this session fails, on cue

• Four fault points: executor_start, executor_end, before_commit, before_abort
• Events are session-local, one-shot and counted. Faults fire in a fixed order: delay, then crash, then error
• Built only on supported hook APIs. It patches nothing in core

[ Source | PGXN ]

Copy and move files on Linux, with undo.

Fylex does what cp and rsync do on a local machine, and adds safety nets. Every run is journaled under a process ID, so you can undo or replay it exactly. Files are hash-verified, and conflicts are resolved the way you choose.

pip install fylex
fylex copy ~/work ~/backup --resolve newer --verify
fylex undo 2023   # roll the whole run back

• Hashes with xxhash, blake3, SHA or MD5, backed by a SQLite hash cache for deduplication
• Eight conflict strategies, from rename to newer, larger and prompt
• Atomic writes. Keeps permissions, timestamps, xattrs and ACLs
• CLI and Python API. Blazefox is a GUI built on top of it

[ Source | PyPI ]

A web address that behaves like an ordinary file.

A browser bookmark is stuck inside one browser profile. A .web document lives in the filesystem instead. You can keep it next to the project it belongs to, and mv, cp, commit, archive or mail it. Double-click it in the file manager and it opens in a browser.

$ web create postgres https://www.postgresql.org/
$ web open postgres
$ cat postgres.web
{ "version": 1, "url": "https://www.postgresql.org/" }

• The web CLI is a thin front end over libwebdoc, the C library that holds all the logic
• Atomic writes, exclusive creation that refuses symlinks, and no shell anywhere
• No network access, no background service, no database. Ships as a Debian package

[ Source ]