Live data from Hacker News

Bluesky migrates to single-tenant SQLite

github.com

91–100 of 247 posts

Re: Bluesky migrates to single-tenant SQLite

#91

Earlier quoted context omitted.

There you go folks: bsky-social-h3d4w-u6yn4 bsky-social-74bqi-vkmcq bsky-social-n3fdq-46nxz bsky-social-yippe-32vdr bsky-social-l2fbt-xnscx

Any more?

Some more for y'all!

bsky-social-ge2mz-mfmpi

bsky-social-hykwa-x3ox4

bsky-social-gh4mt-2od6p

bsky-social-dejzy-mmcxf

edit: all gone :(

Re: Bluesky migrates to single-tenant SQLite

#92
post #75

Earlier quoted context omitted.

Damn, they all gone.

There you go folks: bsky-social-h3d4w-u6yn4 bsky-social-74bqi-vkmcq bsky-social-n3fdq-46nxz bsky-social-yippe-32vdr bsky-social-l2fbt-xnscx

Either people were really prepared for these codes to appear, or they are being scraped. Regardless, they're all gone

Re: Bluesky migrates to single-tenant SQLite

#94
post #16

What do they mean by "Since SQLite does not support concurrent transactions" - it supports them, as long as you don't access the .db file through a file share (UNC, or NFS, etc) - https://www.sqlite.org/wal.html I've been using this to update/read db from multiple threads/processes on the same machine. You can also do snapshotting with the sqlite backup API, if you want consistent view, and to not hold on transaction…

> Writers merely append new content to the end of the WAL file. Because writers do nothing that would interfere with the actions of readers, writers and readers can run at the same time. However, since there is only one WAL file, there can only be one writer at a time. I think the OP meant that updates have to run sequentially.

I've been importing data to sqlite databases running being actively written to for years. Just throws exception if the database is locked and I retry. Do 10k row batches, with a small sleep between. No issues. Helps if your use case doesn't really care about data being in order I guess.

Re: Bluesky migrates to single-tenant SQLite

#97

I've got a bunch of invites if folks want them: bsky-social-etdu7-njigu bsky-social-2ktcs-uwoxg bsky-social-6f5nh-36gnq bsky-social-ciwro-3gzk5 bsky-social-y4h57-dxh3g

The codes are all gone. That was fast.

E: Happy to take one, if somebody happens to have a spare one left. Email is in my bio.

Re: Bluesky migrates to single-tenant SQLite

#99
post #76
post #62

Cool, but maybe let people actually use your service before everyone forgets what it is?

They have over 1.8 million users currently, or do you mean PDSes specifically? Federation is in open beta on a test network, you can try it out today if you'd like.

I have been on the wait list since they launched. They seem to mostly rely on invites.

Re: Bluesky migrates to single-tenant SQLite

#100

Earlier quoted context omitted.

I prefer to have clear commits that tell a tidy story. For example: * Refactor function `foo` to accept a second parameter * Add function `bar` * Use `bar` and `foo` in component `Baz` to implement feature #X If you give me a commit history like this, I can easily validate that each step in your claimed process does what you describe. If you instead give me a messy history and ask me to read the diff, you might know…

In the context of Github PR you can’t leave reviews on commits other than what’s currently the tip commit of the pr branch so structuring this way is just wasted effort. What you should be doing is breaking down PRs more finely so that your unrelated refactors are all separate single-commit PRs. That ofc requires that your pr review round trip time is fast

I'm pretty sure I've left comments on a commit before in a GitHub PR. The comment just goes in the right place in the PR diff, assuming no changes, or comments can actually be attached to commits themselves (which is what happens when a comment becomes stale—it retains a reference to the original commit).
Post reply on HN