Hacker News: avinassh

Towards a Disaggregated Agent Filesystem on Object Storage

avinassh — Sun, 11 Jan 2026 13:32:09 +0000

Article URL: https://penberg.org/blog/disaggregated-agentfs.html

Comments URL: https://news.ycombinator.com/item?id=46575609

Points: 1

# Comments: 0

New comment by avinassh in "PGlite – Embeddable Postgres"

avinassh — Thu, 04 Dec 2025 11:17:27 +0000

previous Show HN post submitted by the author (109 comments) - https://news.ycombinator.com/item?id=41224689

Fermyon Joins Akamai

avinassh — Mon, 01 Dec 2025 14:38:57 +0000

Article URL: https://www.fermyon.com/blog/fermyon-joins-akamai

Comments URL: https://news.ycombinator.com/item?id=46107946

Points: 14

# Comments: 0

New comment by avinassh in "Beyond the SQLite single-writer limitation with concurrent writes"

avinassh — Wed, 15 Oct 2025 04:50:00 +0000

> You can shard your SQLite tables into multiple database files and query across all of them from a single connection.

You mean using ATTACH statement, right? If you use WAL mode, then you cannot get transaction safety / ACID with ATTACH [0]

> If the main database is ":memory:" or if the journal_mode is WAL, then transactions continue to be atomic within each individual database file. But if the host computer crashes in the middle of a COMMIT where two or more database files are updated, some of those files might get the changes where others might not.

Moreover, ATTACH do not support more than 125 databases, so that limits the shards to 125. [1]

ATTACH does not solve the concurrency problems. That's why SQLite also has a BEGIN CONCURRENT experimental branch

[0] - https://www.sqlite.org/lang_attach.html

[1] - https://www.sqlite.org/limits.html

New comment by avinassh in "Show HN: SQLite Online – 11 years of solo development, 11K daily users"

avinassh — Mon, 13 Oct 2025 14:10:13 +0000

how does collaboration works for SQLite, since the db is embedded?

New comment by avinassh in "Pop OS 24.04 LTS Beta"

avinassh — Fri, 26 Sep 2025 10:43:41 +0000

I have an old 2019 MBP, now I am tempted to try Pop on it. Does the external displays work?

New comment by avinassh in "Pass: Unix Password Manager"

avinassh — Sun, 14 Sep 2025 14:54:41 +0000

> I've been working on something similar... although with slightly larger scope (intended to be used within containers/sandboxes) https://github.com/andrewbaxter/passworth

> stored in encrypted sqlite3

you had me at encrypted sqlite3. it would be great if you mention in readme that it uses SQLCipher

Setsum – order agnostic, additive, subtractive checksum

avinassh — Sat, 13 Sep 2025 14:42:05 +0000

Article URL: https://avi.im/blag/2025/setsum/

Comments URL: https://news.ycombinator.com/item?id=45232455

Points: 4

# Comments: 1

New comment by avinassh in "Immich – High performance self-hosted photo and video management"

avinassh — Mon, 08 Sep 2025 15:45:17 +0000

any opinion on how does this compare with ente?

New comment by avinassh in "Gotosocial: We will not accept changes created with the aid of "AI""

avinassh — Mon, 08 Sep 2025 14:43:37 +0000

I find this interesting. This is probably the first time I am seeing a large-ish project ban AI outright

Gotosocial: We will not accept changes created with the aid of "AI"

avinassh — Mon, 08 Sep 2025 14:42:58 +0000

Article URL: https://codeberg.org/superseriousbusiness/gotosocial/src/commit/9b7db51436/CODE_OF_CONDUCT.md

Comments URL: https://news.ycombinator.com/item?id=45168946

Points: 4

# Comments: 1

New comment by avinassh in "GPT-5 Thinking in ChatGPT (a.k.a. Research Goblin) is shockingly good at search"

avinassh — Mon, 08 Sep 2025 10:02:26 +0000

Does substack let you add canonical URLs for the post? Otherwise won't you penalised by search engines for duplicated content?

Everything Is a []U8

avinassh — Sun, 07 Sep 2025 13:50:26 +0000

Article URL: https://www.openmymind.net/Everything-Is-A-u8-array/

Comments URL: https://news.ycombinator.com/item?id=45158137

Points: 2

# Comments: 0

Oldest recorded transaction

avinassh — Sat, 06 Sep 2025 14:34:55 +0000

Article URL: https://avi.im/blag/2025/oldest-txn/

Comments URL: https://news.ycombinator.com/item?id=45149626

Points: 182

# Comments: 106

Tufte CSS

avinassh — Wed, 03 Sep 2025 18:41:57 +0000

Article URL: https://edwardtufte.github.io/tufte-css/

Comments URL: https://news.ycombinator.com/item?id=45119103

Points: 207

# Comments: 48

New comment by avinassh in "Show HN: LightCycle, a FOSS game in Rust based on Tron"

avinassh — Wed, 03 Sep 2025 06:42:09 +0000

This is cool! The code base is small to follow easily and also TIL ggez.

In the single player mode, the computer is not so intelligent. So initially i just kept winning without understanding what was happening.

New comment by avinassh in "Replacing a cache service with a database"

avinassh — Sun, 31 Aug 2025 17:40:32 +0000

Is it possible to create a filter that can work over a complex join operation?

That's what IVM systems like Noria can do. With application + cache, the application stores the final result in the cache. So, with these new IVM systems, you get that precomputed data directly from the database.

Views in Postgres are not materialized right? so every small delta would require refresh of entire view.

Replacing a cache service with a database

avinassh — Sun, 31 Aug 2025 14:41:15 +0000

Article URL: https://avi.im/blag/2025/db-cache/

Comments URL: https://news.ycombinator.com/item?id=45083495

Points: 81

# Comments: 66

New comment by avinassh in "SQLite's documentation about its durability properties is unclear"

avinassh — Sat, 30 Aug 2025 06:53:57 +0000

> I don't think WAL can ever really have a durable transaction; it is essentially based on leaving a transaction open until it gets "check-pointed" or actually committed to the database file

why not? if you use synchronous=FULL, then WAL does provide durable transactions, no?

New comment by avinassh in "SQLite's documentation about its durability properties is unclear"

avinassh — Sat, 30 Aug 2025 06:49:39 +0000

I wrote the first article, and I thought documentation is clear, but then I saw comment by Hipp which got confused me:

> If you switch to WAL mode, the default behavior is that transactions are durable across application crashes (or SIGKILL or similar) but are not necessarily durable across OS crashes or power failures. Transactions are atomic across OS crashes and power failures. But if you commit a transaction in WAL mode and take a power loss shortly thereafter, the transaction might be rolled back after power is restored.

https://news.ycombinator.com/item?id=45014296

the documentation is in contradiction with this.