Nighed

joined 1 year ago
[–] Nighed@sffa.community 5 points 9 months ago (2 children)

SQL returns subsets of all tables with only those tuples that would be part of the traditional (single-table) query result set

So it returns only the data that would be returned from the query, so the filtering is done.

I can see some uses of it. If you look at what something like Entity Framework does behind the scenes to return nested objects, you can see how something like this might help.

[–] Nighed@sffa.community 1 points 9 months ago (1 children)

But they do go to the community mods, even on a different instance? And if the community mods remove the content that removal federates?

I prefer to rely on the community mods to remove most 'spam' as it's their role to decide what is spam in their community. (Obviously admins can/should remove illegal content etc)

Admins for the most part shouldn't have to remove content on their copy of other instances communities.

[–] Nighed@sffa.community 3 points 9 months ago (3 children)

The reports go to the community mods not your instance admins though don't they?

[–] Nighed@sffa.community 3 points 9 months ago

Yeh, it's all the network effect. Where people go will, generally be where they continue to go.

That's why threads was dangerous (and may still be) to and more grassroots federated options

[–] Nighed@sffa.community 27 points 9 months ago (3 children)

My understanding is tha some commercial/industrial users will get a highly variable tariff. This may be cheaper much of the time, but can get ridiculously expensive at times of high demand.

The difference is that a bitcoin farmer can shut down at those expensive times, but a home user still needs to heat/cool their house, run their fridge etc, so the savings cancel out. Because of this, averaging the costs works out easier/better for most home consumers

[–] Nighed@sffa.community 3 points 9 months ago

He would have had to agree to the non compete clause though, not sure what happened there....

[–] Nighed@sffa.community 8 points 9 months ago

There are a lot of institutional investors that own a stake in spacex, I know Google has a significant stake for example.

Their not publicly listed though, millionaires only....

[–] Nighed@sffa.community 2 points 9 months ago

For now, if richish people want to pay for it in their flat, go for it. (It would be interesting to see the carbon cost of the extra materials though!) They can pay for the building and maintenance, and everyone else gets a cool building to look at.

The hopefully the kinks get worked out and it can be done cheaper on other buildings.

[–] Nighed@sffa.community 4 points 9 months ago

So much sarcasm in the quick chat 🤣

[–] Nighed@sffa.community -2 points 9 months ago* (last edited 9 months ago)

A VPN either:

  1. Logs access/usage so it can be given to authorities. (And/or sold/stolen etc)

  2. doesn't log usage data and willingly accepts that some disgusting stuff will be done using their service.

1 might have to give browsing data if sued by a media company, 2 is ethnically bankrupt and shouldn't be trusted at all.

Doesn't mean their not useful, just be aware of who you are giving your money to and the limitations of their protection.

[–] Nighed@sffa.community 11 points 9 months ago (3 children)

Ah yes, give your browsing history to the shady VPN company instead.

Although that would help in this situation.

[–] Nighed@sffa.community 4 points 9 months ago (1 children)

I'm surprised they didn't blame the crash on the Decepticons!

... actually it was caused by one of the engines falling off! (or the nossle anyway)

view more: ‹ prev next ›