Discourse already has an activitypub plugin

https://meta.discourse.org/t/activitypub-plugin/266794

One million hours in gimp

Why though? I’ve genuinely never had a problem with it. If something is wrong, it was always going to be wrong. Why is it preferable to have to write a bunch of bolierplate than just deal with the stacktrace when you do encounter a type error?

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’d go for syncthing over nextcloud for your specific usecase. Nextcloud isn’t good for unreliable connections and they’re sticking with the annoying decision of not supporting server to server synchronization.

If there’s something you want to search by in a database, you should index it.

Indexing will create an ordered data structure that will allow much faster queries. If you were looking for the username gazter in an unindexed column, it would have to check literally every username entry. In a table of 1000000 entries it would check 1000000 times.

In an indexed column it might do something like ask to be pointed to every name beginning with “g”, then of those ask to be pointed to every name with the second letter “a” and so on. It would find out where in the database gazter is by checking only six times.

Substring matching is much more computationally difficult as it has to pull out each potentially matching value and run it through a function that checks if gazter exists somewhere in that value. Basically if you find yourself doing it you need to come up with a better plan.

Cartesian explosion would be when your query ends up doing a shit load of redundant work. Like if the query to load this thread were to look up all the posters here, get all their posts, get the threads from those posts and filter on the thread id.

Lol why are people such dicks? My vets sent pics when my dog was recovering from an operation. It’s a pretty normal thing.

Anyway, if it was me I’d just set up a stream of the webcam on peertube via OBS.

I don’t know how far owncloud and nextcloud have diverged, but in the nextcloud client you can add filters to ignore files by clicking the three dots on the folder in settings.

You can also free up local space by using virtual folders, but it only works properly on windows.

Afaik Godot is designed specifically to be portable , so unless you’re wanting to use cutting edge features of unreal or something, you can use that and let everyone else focus on their own tooling.

All I want is a 3gb model for the raspberry pi. 7b is too big and 1.5b is too stupid.

I don’t know. When I first heard about the horizon scandal I understood what had happened immediately and have since been of the opinion that making financial software that isn’t Byzantine fault tolerant should be a criminal offence.

I’m all for scamming scammers, but I’m quite happy to give a tip to YouTubers I watch by way of e-commerce commissions.

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.

A very silly but useful hack I did to get the MS flight sim install down to about 40GB (normally ~270GB) before I gave up on windows was this.

Set up a nextcloud server on a raspberry pi.

Install the client on your windows machine.

Add your games install folder as a connection on the nextcloud client and enable VFS (virtual filesystem)

Once synced, right click the folder and select “free up space…”

This will basically delete the file data from your local machine and redownload it whenever windows tries to access a file.

Now launch your game and it’ll take a while to start as it has to redownload the files it actually needs to run, but it won’t bother getting what it doesn’t have to.

The fundamental problem with cryptocurrencies is that the people with the enthusiasm to make them (libertarians), are too stupid (libertarian) to understand why a deflationary asset cannot work as a currency.

It’s inherently a speculative investment. Nobody is going to spend something that might be worth dramatically more tomorrow and nobody is going work for something that might be worth dramatically less tomorrow.

There are sections of both the right and the left that have anti-authoritarian tendancies.

The libertarian right tends to view things purely in terms of government over reach, whilst the left tends to view things in terms of the power of capital.

Leftists saw Facebook pushing propaganda for the highest bidder, Reddit trying to be safe to sell to investors and twitter basically becoming a project to reflect Elon Musk’s personal opinions.

Out of that came a bunch of attempts at creating new social networks. The right wing attempts were not cognisant that the aforementioned were the natural result of trying to get rich off it, while the left attempted to make it impossible to get into that position.

Solar panels on cars are thought of the wrong way. The responses in this thread really demonstrate that.

It’s true that they’re kind of pointless on EVs, because they’re never going to supply enough power to not need a proper charge, which makes the panels redundant.

Where they could be useful is hybrids, sold as something that makes the engine 10-20% more efficient.

I know a joke about UDP.

I know a joke about TCP too.

Did you get it?

Right wing free software users love from each according to his ability, to each according to his needs until you point out what it is.

Then you get whatever this lemmy-wide tantrum is.

I disagree with Dessalines about some stuff but the guy is a don.

The point would be that it’s a failover. It takes about two seconds for the video here to start streaming from the webseed and that’s probably just the wait for enough video to load in order to render. The standard peers don’t really become load bearing until the server is struggling.