Random fact: The guy that did the hook a Macklemore’s thrift shop was partially responsible for that.

It’s a failure on the part of mastodon. I don’t really care about whatever drama dansup is embroiled in. Mastodon shouldn’t imply a post is only readable by followers when it’s just a public post that doesn’t show by default in their frontend.

Honestly pixelfed should have just not fixed it. It’s a fediverse problem that can be fixed and mastodon is just misleading people.

Platforms should either make it clear that it means just that the post isn’t advertised by default on all platforms but is always accessible to anyone that wants it or actually implement e2e encryption.

As funny as this is, I’d rather people understood how the AI actually works. It doesn’t reveal secrets because it doesn’t have any. It’s not aware that Musk is trying to tweak it. It’s not coming to logical conclusions the way a person would. It’s simply trying to create a sensible statement based on what’s statistically likely based on all the stolen content that it’s trained on. It just so happens that Musk gets called out for lying so often that grok infers it when it gets conflicting data.

Yeah I’m into indie hip hop and medieval beekeepers

What exactly can they parent here? Hyundai already make the software and SIM racers have been making the hardware for like a decade now.

Don’t get me wrong it sounds fun. This just doesn’t seem novel enough to validate a patent.

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.

And Malcolm x was killed within months of denouncing the racism of the NoI.

And Fred Hampton was killed the same year as founding the rainbow coalition.

Isn’t your executive currently saying they dictate the law though?

Also openSCAD if you struggle to get your head around normal CAD programs. Everything is written as a script and it’s surprisingly intuitive.

It’s not difficult though. They just can’t be arsed and are making excuses for being comfortable and lazy. If there was a $100 million marketing budget and their favourite celebrity was here, they’d sit an hour long entrance exam. The best we can do is make it fun enough here that people want to comment.

It was funny when Europeans would use BIPOC. Like 90% of us are indigenous and Americans invented that term specifically to exclude us.

Microcis

Wait 'til he finds out about Versace

I’m running deepseek-r1:14b on a 12GB rx6700. It just about fits in memory and is pretty fast.

I’m using an Rx6700xt which you can get for about £300 and it works fine.

Edit: try using ollama on your PC. If your CPU is capable, that software should work out the rest.