avinassh

avinassh

vor 2 Monatendiscuss

TIL electrobun. How does it compare against electron?

avinassh

vor 2 Monatendiscuss

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

avinassh

vor 7 Monatendiscuss

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

avinassh

vor 9 Monatendiscuss

> 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

vor 9 Monatendiscuss

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

avinassh

vor 10 Monatendiscuss

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

avinassh

vor 10 Monatendiscuss

> 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

vor 10 Monatendiscuss

any opinion on how does this compare with ente?

avinassh

vor 10 Monatendiscuss

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

avinassh

vor 10 Monatendiscuss

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

avinassh

letztes Jahrdiscuss

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

letztes Jahrdiscuss

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

vor 5 Jahrendiscuss

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

vor 6 Jahrendiscuss

> 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

Submissions

Bun's problem may be developing in the open

SQLite prefixes its temp files with `etilqs_`

Towards a Disaggregated Agent Filesystem on Object Storage

Fermyon Joins Akamai

Setsum – order agnostic, additive, subtractive checksum

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

Everything Is a []U8

Oldest recorded transaction

Tufte CSS

comments