That's always been the system. That's how they keep the wages so low.

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.

I think that's the event this song is about. It definitely reflects the mood.

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

ollama run deepseek-r1:1.5b

That'll get you a 1.1gb model. Probably knows less trivia but still functional.

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 feel like back in the day trolling was more of an art where you'd say something stupid to expose someone's cognitive dissonance.

Now it just refers to people being dicks. Trolling itself has become enshittified.

.ml vs .world fights are always hilarious. And for that reason, they should stay federated.

Good point. I kinda rushed it and didn't really think to check. Just bought it cause .uk is a better tld

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.

I wish IPFS was a solution but it's just broken. I've got goto social running on a raspberry pi on a residential connection. If I try to run IPFS, my router crashes as it seems to try and connect to every peer on the network.

A torrent file and a webseed is enough. The client uses the torrent file to validate the download from a standard http source.

The webseed can be the same source as the file your browser would normally download.

So yeah the site needs to seed the file, but not necessarily using a torrent client.