fatsdomino001

So begins another attempted colour revolution...

Originally created by Aaron Swartz, wow. Incredible to see his work enduring.

America in 20 years if trends don’t change

What is the evidence that is convincing you that "we've now done the experiment [of free speech] in a big way and the results seem overwhelmingly negative"?

Why not begin on web though? I mean I get it for clubhouse, instagram and snapchat because they're making use of phone functions like easily being able to record audio or take pictures... still it's interesting how much web gets belittled compared to apps these days.

Same with web users apparently...

Well there is criticism, it's just not being reported on - but I think that's your point.

Overall the degree to which information is being controlled right now is pretty alarming.

I suspect what you deem credible is substantially different from what's credible to people who are critical of the covid mrna treatment.

Incidentally the people theorizing about trees communicating through roots are actually saying trees are communicating via webs of root-connected fungi which act as the connections in between the trees. It's literally underground tunnels of fungi (mycelia) within which the chemical signals are transferred. Colloquially referred to as the Wood Wide Web; technically it's networks of mycorrhizal fungi.

Giving money to homeless people.

And as a general principle I don't like having all of my transactions logged and tracked. That's the same fallacy of "if you have nothing to hide, then submit yourself to complete tracking"

Is it the people who were using Parler that made the death threats, or the people who don't like that people were using Parler?

I honestly don't know, but I personally assumed the death threats came from people who simply didn't like that Parler existed in the first place.

A very worrying trend. Dangerous world to be managing a social network in right now. Damned if you do, damned if you don't.

Incorrect. You're discussing censoring people with a different opinion than you, but using minorities as political cover, which is morally dubious.

I'll admit that I'm not actually sure on the performance difference between BIGINT and UUID in postgres. So in that sense you're right that the question is a tradeoff of x% of performance (which may never be a problem) but with added complexity vs ULID which is simple/elegant and signifcantly less cognitive overhead (easier to maintain) but will cause bigger indexes vs bigint. It's a tradeoff.. and your post has me thinking again that realistically the maintainability and agility that ULID provides may actually be better than a potentially error-prone but x% more performant instagram-like bigint generator. I just don't know enough to properly compare the two, so I suspect opting for the easier cognitive load / maintainability / agility is best.

How does ULID compare to Instagram's bigint id_generator for postgres?[0]

ULID is 128 bits vs 64 bits for instagram id, so ULID is stored in a uuidfield but instagram id can be stored in bigint field.

There is some advantages of using the application code to generate the ID though (avoiding roundtrip to DB if need to use the ID afterwards), but I'm seduced by just offloading this work to the DB and being able to use bigint field to store the id.

As someone who is just about to commit to using ULID or an instagram-like bigint id generator, would you have any thoughts you could share on which may be better?

[0] https://instagram-engineering.com/sharding-ids-at-instagram-...

Someone should throw the sqlite database up with Datasette, probably some very interesting faceted search that could be had here

Sounds like they mean they're just hashid'ing the bigint id, likely stored in a separate slug column with the output

I've been using ULID as an alternative to UUIDs, e.g.: https://github.com/ulid/spec

I've found ULID to be great for my purposes. Wonder if anyone else has tried using them too?