I have a friend who went on holiday in Amsterdam. Got a flight back home. When he got in the taxi from the airport, the driver asks if he smokes weed. “Yeah a bit. Why?” “Cause you’ve got a bud stuck to your hat”. Dude managed to go through customs with weed on full display on his beanie and didn’t get caught out.

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.

The hose at the petrol station reaches the opposite side of most cars if you park with your rear window in line with the pump.

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.

it’s pretty good for things that I can eye scan and verify that’s what I would have typed anyway. But I’ve found it suggesting things I wouldn’t remotely permit to things that are “sort of” correct.

Yeah. I haven’t bothered with it much but the best use I can see of it is just rubber ducking.

Last time I used it was to asked how to change contrast in a numpy image. It said to multiply each channel by contrast. (I don’t even think this is right and it should be ((original value-128) * contrast) + 128) not original value * contrast as it suggested), but it did remind me I can just run operations on colour channels.

Wait what’s my point again? Oh yeah, don’t trust anyone that can’t tell you what the output is supposed to do.

Search for “Hexamethyldisiloxane adhesive remover”. It’s designed for removing ostomy bags but it will remove pretty much any gummy sticky glue from anything with very little effort.

I know a joke about UDP.

I know a joke about TCP too.

Did you get it?

I don’t mind if indie devs try something experimental that melts your computer. Like beamNG needs a decent computer but the target audience kinda knows about that sort of stuff.

The problem is with games like cities skylines 2. Most people buying that game probably don’t even know how much RAM they have, it shouldn’t be unplayable on a mid range PC.

I can think of a few games franchises that wouldn’t have trashed their reputation if they’d have had an internal rule like “if it doesn’t play on 50% of the machines on Steam’s hardware survey, it’s not going out”

I don’t know if this something you’re deliberately trying to avoid. Apologies if you are, and I’ve missed the point, but

I gave up on doing anything in TK years ago. For all the effort to make stuff work in it, you might as well just use flask and have a HTML frontend. That way, you know it’s going to work on everything and includes remote access as a bonus.

Edit: for a lot more power with a little bit more learning curve, look at fastapi.