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.

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.

Also do some research over whether you actually do need cuda if you need cuda. It’s synonymous with a lot of AI stuff, but in my experience it all works with rocm anyway.

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

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

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.

Yes when you run the model locally.

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.

It can be integrated into the website, admins just need to tick these options…

Admins are able to add external search engines. Most use sepia search and it pretty much covers all the non-sketchy stuff.

My theory is more based on vibes and multiple continuous layoffs from the majority companies over the last few years.

The only thing that we can be pretty much certain on is that the banks think twitter is overvalued and think other Investors see it as undervalued.

I’m not an econ major but I’m going to give you my theory anyway.

We’ve been circling the drain on a major global recession for two years. We’ve been avoiding it through sheer denial.

Nobody ever mentions it, but tech stocks were the first to take a beating in 2008. The reason is that they’re actually kinda worthless and just a place where billionaires gamble the way trust fund kids do with cryptocurrency. There’s just not really that much collateral in digital property. Unlike land, it’s value can just disappear overnight if people decide it’s uncool.

When asset managers are about to be called on their bets and have to find money somewhere, the first thing they’ll do is sell tech shares to bail out other investments. Houses will always have some value even if you end up having to manage it yourself, whereas any social network risks going the way of MySpace.

Twitter being in trouble isn’t just a sign that twitter is in trouble, but that investors need that money for something safer, and if they’re looking for something safer that may mean sheer denial isn’t working anymore.

and again

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

A thought that just hit me in the shower.

I don’t feel like lemmy is too small. It quite comfortably fills all my lazing on aggregator time without getting stale. The thing is, like many here, I’m a libertarian leftist politics nerd that’s into linux and self hosting.

That description describes a sizeable chunk of this project’s userbase so enough content is being posted enough to saturate the feed.

If you want the project to expand into other niches, you will have to post into the void about whatever you’re into. Seed forums with TV shows or photography or hiking or warhammer or whatever you’re into and encourage others to do the same.

All forums are dead at first but if you want people to come and talk about pottery, you’re going to have to make that forum cozy before it gets enough interaction to become self sustaining.

So, capitalism then.