Viewing profile — avinassh

TIL electrobun. How does it compare against electron?

I'd love to learn how the database is built and the sync works

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

> 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, …

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

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

> 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…

any opinion on how does this compare with ente?

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

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

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 und…

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…

> 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 dat…

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 tra…