Live data from Hacker News

Bluesky migrates to single-tenant SQLite

github.com

121–130 of 247 posts

Re: Bluesky migrates to single-tenant SQLite

#121
post #99

Earlier quoted context omitted.

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

bsky-social-scbch-eolha bsky-social-fs26y-d6gnv bsky-social-2lx5u-ntrdv bsky-social-hboq7-dyuue bsky-social-b2v3f-3a23q

Thank you so very much! :-)

Re: Bluesky migrates to single-tenant SQLite

#122
post #63

Why sha256 hash the user into to get a two character target directory? Wouldn't md5 be much faster and solve the same problem?

At a guess: that hash is performed relatively few times, so any performance difference is lost in the noise floor. Never having to answer "why did you use this insecure hash" or eliminating/minimising any possibility of a class of security problem is worth more.

Re: Bluesky migrates to single-tenant SQLite

#123

Earlier quoted context omitted.

Come on, "over 1.8 million users" is not an impressive number These kind of movements makes me think they're not serious about scaling up. Wouldn't surprise me if then end up as an also-ran

Maybe not impressive but none of the services of my customers had or has 1.8 million users. And yet they do well (my customers.)

That. And none of the big social media platforms were big at the start either.

Re: Bluesky migrates to single-tenant SQLite

#124
post #6
post #4

Interesting... I like the strategy of having each user be 1:1 with a DB. What would be done for data that needs to be aggregated across users though? If I'm subscribed to another user and they post, how does my DB get updated with that new post? Or is this meant just for durable data and not feed data (like profile data, which users are followed / not followed / etc.) and all the interactive stuff happens separately?…

https://blueskyweb.xyz/blog/5-5-2023-federation-architecture

> The BGS handles "big-world" networking. It crawls the network, gathering as much data as it can, and outputs it in one big stream for other services to use. It’s analogous to a firehose provider or a super-powered relay node.

"Big-world" networking by Big Tech-to-be Bluesky with super-powers, I wonder? Is this BGS also going to be federated, or is that the big centralized beating heart of this platform managed exclusively by BS?

Re: Bluesky migrates to single-tenant SQLite

#125
post #123

Earlier quoted context omitted.

Maybe not impressive but none of the services of my customers had or has 1.8 million users. And yet they do well (my customers.)

That. And none of the big social media platforms were big at the start either.

Yes but 1.8Mi at a time where people are longing for a Twitter alternative is just leaving money on the table

Re: Bluesky migrates to single-tenant SQLite

#126
post #111
post #90

Earlier quoted context omitted.

bsky-social-lbjkg-gcxs4 bsky-social-zigwm-f3qpq bsky-social-2jlu7-apy5a bsky-social-6ct52-4egmz bsky-social-cy64m-53sqn

Maybe if you stop posting them with the easily-greppable first part they won't be so easy to scrape.

grep "bsky-" internet.txt

Re: Bluesky migrates to single-tenant SQLite

#128
post #42
post #8

Earlier quoted context omitted.

Less active than Mastodon, I'd assume more active than Nostr. But the interesting thing for me isn't activity — it's the people on there. Of the cohort who had >100k followers on Twitter, I think more of them post regularly on Bluesky than post on Mastodon. Bluesky definitely has a more cohesive feel, especially because there's currently just one instance & mod team.

Mastodon, and the Fediverse in general, make user interaction decisions on purpose to limit many of the issues common to social media. Think about: mob culture, addiction, and the like. I wonder if BlueSky intends to follow on those. For example, hiding user actions counts (repeats, favourites, etc...) until the user acts on one. Things like these may be strange for those accustumed to Twitter, but personally, is wha…

My bet is regardless of any initial good intentions, since BlueSky is a company, market pressures will inevitably force them into dark patterns like we see on every other commercial social network (going back to the early days of the companies, Facebook, Twitter, and even Google looked really good early on until all were corrupted by profit motive). My belief is that the profit motive is necessarily at odds with free communication.

To me, the ActivityPub network (Mastodon and friends) is relatively unique in the social media space in having no direct commercial pressures (the protocol is developed by W3C) and therefore being inoculated against the causes for these dark patterns.

Re: Bluesky migrates to single-tenant SQLite

#129
post #3

I am curious, does the HN folks know if bluesky is more active than nostr or the mastodon network?

I don't know about nostr, but I find it is a lot less active than Mastodon. In general the tech accounts I am interested in have moved to Mastodon rather than bluesky. I imagine this would depend on whose activity you are interested in, and where they have chosen to migrate to

Re: Bluesky migrates to single-tenant SQLite

#130
post #63

Why sha256 hash the user into to get a two character target directory? Wouldn't md5 be much faster and solve the same problem?

At their scale maybe they're worried about collisions? Or, like me, they're drowning in security tooling from corporate and don't want to have to carve out exceptions for md5 usage in each.

> At their scale maybe they're worried about collisions?

With their scheme, collisions are already guaranteed to happen if they have >256 users.

Post reply on HN