Is there any plans for yunohost integration?

I'd love to self host piefed just so I can munge my peertube and threadiverse feeds.

I think it was only like 24 hours. It's all automated though. So you get a thirty second countdown mashing buttons to try and work out how to get your headlights on if you spawn at night.

When it comes to searching the database, the index will have already been created. When you create an index, it might take a while as the database engine reads all the data and creates a structure to shadow it. Each engine is probably different and I don't know if any work exactly like that, but it's an intuitive way to understand the basics of how B-trees work. You don't really need to think much about how it works, just that if you want to use a column as a filter, you want to index it.

However, when you're thinking about the structure of a database it's a good idea to think what you'll want to do with it before hand and how you'll structure queries. Sometimes searching columns without an index is unavoidable and then you've got to come up with other tricks to speed up your search. Like your doctor might find you (i'm presuming gaz is sort for gary and/or gareth here) with a query like SELECT * FROM patients WHERE birthdate = "01-01-1980" AND firstname LIKE "gar%" The db engine will first filter by birthdate which will massively reduce the amount of times it has to do the more intensive LIKE operation.

I'm just going to assume every billionaire pulling this shit for trump has an unfathomably disgusting record in the Epstein files. There's no way that every single one of them is deciding to be this overtly fucking pathetic.

The spark plug example is popular because presumably you find both old sparkplugs and spare car windows at junk yards. What it really is that the ceramic that they're made out of hard and sharp enough when broken to damage the surface of the glass which causes the chain reaction.

The most recent release is headless and only has a web front end.

You can use tribler as your client. It has built in onion routing.

You buy several matching sets and can't match the lids to the tubs so you buy more sets and make the problem worse.

Maybe I'll actually get round to implementing my ideas 🤷

I guess there's no harm in making it work even if nobody uses it.

I know the peertube one is sorta broken at the minute because the WASM POW script doesn't accept difficulty as a variable. Maybe I should check up and see if anyone has fixed it.

To deal with moderation conflicts you could basically just unlink the thread.

Also we could also just add flags to activitypub messages on creating posts to tell the boosting server whether or not merging is permitted.

If you've worked hard on something and want everyone to see it, set it to True and people can boost it to different communities.

If it's something personal or an in-joke that you only want to be advertised to the community it's posted in set it to False and the option won't be available when cross posting in the UI.

They're selling ~900g tins at the big Asda. Quality street are gram for gram even cheaper than the plastic ones.

I think something like peertube would be a good solution for media, but there's obstacles to getting it deployed in terms of adoption.

The player is quite mature and does everything you could want. For servers it saves resources by being peer to peer using webRTC. For clients it handles graceful degradation and redundancy.

A way it could be implemented for other drivers servers could go like this...

I upload a video to Lemmy. My Lemmy instance forwards that video to peertube. Peertube processes the video and releases it as unlisted. Peertube sends the URL back to my Lemmy instance. Lemmy publishes my post with the peertube player iframe as a video.

The issues with this are getting app developers and instance owners to adopt the changes and getting users to understand the implications of the P2P aspect.