HackerTrans
トップ新着トレンドコメント過去質問紹介求人

avinassh

no profile record

投稿

Bun's problem may be developing in the open

00f.net
1 ポイント·投稿者 avinassh·2 か月前·0 コメント

SQLite prefixes its temp files with `etilqs_`

avi.im
3 ポイント·投稿者 avinassh·3 か月前·0 コメント

Towards a Disaggregated Agent Filesystem on Object Storage

penberg.org
1 ポイント·投稿者 avinassh·6 か月前·0 コメント

Fermyon Joins Akamai

fermyon.com
14 ポイント·投稿者 avinassh·7 か月前·0 コメント

Setsum – order agnostic, additive, subtractive checksum

avi.im
4 ポイント·投稿者 avinassh·10 か月前·1 コメント

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

codeberg.org
4 ポイント·投稿者 avinassh·10 か月前·1 コメント

Everything Is a []U8

openmymind.net
2 ポイント·投稿者 avinassh·10 か月前·0 コメント

Oldest recorded transaction

avi.im
182 ポイント·投稿者 avinassh·10 か月前·106 コメント

Tufte CSS

edwardtufte.github.io
207 ポイント·投稿者 avinassh·10 か月前·48 コメント

コメント

avinassh
·2 か月前·議論
TIL electrobun. How does it compare against electron?
avinassh
·2 か月前·議論
I'd love to learn how the database is built and the sync works
avinassh
·7 か月前·議論
previous Show HN post submitted by the author (109 comments) - https://news.ycombinator.com/item?id=41224689
avinassh
·9 か月前·議論
> 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
avinassh
·9 か月前·議論
how does collaboration works for SQLite, since the db is embedded?
avinassh
·10 か月前·議論
I have an old 2019 MBP, now I am tempted to try Pop on it. Does the external displays work?
avinassh
·10 か月前·議論
> 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
avinassh
·10 か月前·議論
any opinion on how does this compare with ente?
avinassh
·10 か月前·議論
I find this interesting. This is probably the first time I am seeing a large-ish project ban AI outright
avinassh
·10 か月前·議論
Does substack let you add canonical URLs for the post? Otherwise won't you penalised by search engines for duplicated content?
avinassh
·昨年·議論
this lwn article supports the argument that many cloud providers contributed back to Redis: https://lwn.net/Articles/966631

> It is also hard to reconcile the claims that cloud providers do not contribute with the actual commits to the Redis repository. A quick examination of the commits since the 7.0.0 release using gitdm shows 967 commits over that time period:

    Top changeset contributions by employer
    (Unknown)         331     34.2%
    Tencent           240     24.8%
    Redis             189     19.5%
    Alibaba            65     6.7%
    Huawei             50     5.2%
    Amazon.com         50     5.2%
    Bytedance          19     2.0%
    NetEase            13     1.3%
> Binbin Zhu, of Tencent, is responsible for nearly 25% of the commits to the project. Some of the contributors without a readily identifiable employer surely are Redis employees, but it's clear that the company has not been working alone.
avinassh
·昨年·議論
Garnet fascinates me. Their benchmarks even claim that it is better than Redis and also Dragonfly. Are there any papers or write ups explaining what makes Garnet fast? (I do know its based on FASTER)
avinassh
·5 年前·議論
Damn, $50 is quite sweet for unlimited. $150 seems bit on the higher on the side. I am cursing myself for missing that offer
avinassh
·6 年前·議論
> I can't even create an account with an email in Feedly.

umm, you can? It isn't obvious from the UI, but you can definitely create one - https://feedly.com/v3/auth/login?newUser=true