Skip Navigation

InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)M

manicdave

@ manicdave @feddit.uk

Posts
6
Comments
65
Joined
2 yr. ago

  • New Dad Can't Wait to Show Newborn Child Hard Drives Full of Pirated Movies Once He's Old Enough

    Jump

  • I'm already planning a Minecraft world with my 7 month old. Been trying to find a TV that allows multiple HDMI connections so we can do three way split screen with the wife when he's old enough.

  • What's the dumbest weed related thing that's happened to you or someone you know did?

    Jump

  • 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.

  • Have you ever cared how much tax you pay?

    Jump

  • In Britain we have a pressure group that's inexplicably on TV every other week pedalling this lie and the one that corporation tax hurts businesses. (Corporation tax is paid on net profits, so businesses only pay if they can afford it).

    What's funny is they're called the "taxpayers alliance" yet their narrative suggests none of them actually have any experience of paying tax.

  • Asklemmy @lemmy.ml
    manicdave @feddit.uk

    Have you ever cared how much tax you pay?

  • Deleted

    Permanently Deleted

    Jump

  • Join a union and ask for their advice. Even if there's limitations on what they can do as it seems the process has already started, they'll still be able to advise on what you're able to do deal with constructive dismissal.

    Look for another job. It's way easier to find work when you're in work and don't have to explain why you're not at your last job.

    Do both of these things. Your health isn't going to benefit working at a place where you're not wanted, even if they can't just fire you.

    Oh and if you're in a country where you're allowed a representative in meetings and you can take one, always have your union rep there, no matter how friendly it seems.

  • What were you ahead on the curve of in hating?

    Jump

  • Tesla/Musk.

    Back in 2014 Tesla and Ecotricity had an agreement to upgrade Ecotricity's charging network to be compatible with Tesla's superchargers. Tesla whined that it wasn't being rolled out fast enough. Ecotricity wasn't a very big company and was basically working for free, so asked Tesla to actually support the roll out if they needed it faster. Musk went mental has been trying to destroy the company ever since. The 2014 Tesla patent release was never about collaboration or saving the planet, he just hoped somebody, somewhere would use it to undermine Ecotricity.

  • I want to interrogate a database of blog posts using AI but ChatGPT has token limits

    Jump

  • If you want to try the openwebui route, This guide might be helpful.

    Edit: in fact I don't think this is for openwebui specifically, but I remember the chapter at the timestamp is what helped me increase the context window. That's the important bit if you're wanting to ask it questions about documents.

  • Why are there no big artists doing protest songs ?

    Jump

  • It's funny how Macklemore's redemption for humiliating Kendrick Lamar is humiliating Kendrick Lamar again.

  • Labels go brrrr

    Jump

  • 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?

  • Linux is too hard

    Jump

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

  • Diversity in your ear holes

    Jump

  • muskrat's data eng expert's hard drive overheats while processing 60k rows

    Jump

  • 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.

  • How do you like to transfer large files between friends across the internet?

    Jump

  • 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.

  • muskrat's data eng expert's hard drive overheats while processing 60k rows

    Jump

  • 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.

  • [Serious] How can a glass shower pane shatter by itself?

    Jump

  • The spark plug example is popular because presumably you find both old sparkplugs and spare car windows at junk yards. What it really is that the ceramic that they're made out of hard and sharp enough when broken to damage the surface of the glass which causes the chain reaction.

  • [Serious] How can a glass shower pane shatter by itself?

    Jump

  • Tempered glass, the type which is used for stuff like shower screens or car windows is under constant tension against itself. The inside of the glass wants to be bigger than the outside. Normally this makes it harder to break as the bonds on the outside are so strong and uniform they prevent it from bending or shearing as easily as normal glass.

    The problem is that if you manage to break those bonds, the outside can very rapidly tear itself apart as it finds a way to relieve that tension. It basically pops like a balloon. The reason it breaks into small pieces is because anything bigger is still under tension and once the surface is damaged the crack will spread to ease it.

    So your glass could have had a defect or damage which broke a few of those bonds, and heat cycles eventually pushed it to break the next bond along and start a chain reaction which destroyed the whole thing.

    Edit: it could even be that some grit fell in the housing or something. The reason spark plugs break car windows is because the edges are sharp enough to cut the glass with very little force.

  • Advice for quick and easy pet cam with remote access

    Jump

  • 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.

  • What's a craving or longing you have that would sound oddly specific to anyone else?

    Jump

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

  • What do you believe that most people of your political creed don't?

    Jump

  • It seems like the atmosphere is changing now but I've been saying this for years.

    The language of privilege is backwards and counter productive.

  • File sync without wasting bandwidth

    Jump

  • 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.

  • Programmer Humor @programming.dev
    manicdave @feddit.uk

    TIL ROCm stands for "Radeon [redacted] [redacted] mlatform

  • Asklemmy @lemmy.ml
    manicdave @feddit.uk

    What's something that's taken for granted that occasionally makes you think, wait wtf?

  • Showerthoughts @lemmy.world
    manicdave @feddit.uk

    "three fold" should mean 8x not 3x

  • Lemmy @lemmy.ml
    manicdave @feddit.uk

    Can Lemmy treat a crosspost like a boost? (merge threads?)

  • Memes @lemmy.ml
    manicdave @feddit.uk

    agile is far left too. I will die on this hill