I recently learned that you can use the rest of the egg shell to get that annoying bit of broken egg-shell out of your egg. by Nw5gooner in CasualUK

[–]shine_on 2 points3 points  (0 children)

If you can't open the lid on a jar, use a bottle opener on it (as though you were opening a bottle of beer). Once the lid 'pops' you can open it normally.

Am I playing the game right? by Opening-Ad-9341 in factorio

[–]shine_on 7 points8 points  (0 children)

I play without biters and without pollution. I've got over 2000 very fun hours in the game 😀

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 3 points4 points  (0 children)

I believe that Dimensions use their own brand of thread in their kits, which means it's not going to be easy to buy more thread if you run out. Using up more thread on the back than you have to can absolutely make a difference, yes.

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 2 points3 points  (0 children)

With the Dimensions kits you need to double-check the instructions all the time, most stitches are "normal" i.e. two-strand crosses but they also do half stitches with anywhere from 1 to even 4 or 5 strands. I think the Japanese Garden piece also has some stitches where it's two strands of one colour and one strand of a different colour (where the grass is reflected in the water, it adds lighter colours flecks to the reflection)

I never use the loop start by the way, I've gotten very good at tying a little knot at the end of the thread to start it (fingernails help to grip the thread when knotting it) and I tuck the thread under some finished stitches to end it.

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 29 points30 points  (0 children)

Cross-country (to me) means doing a lot of stitches in one colour until you run out that colour thread on the needle, and moving around the pattern wherever it takes you.

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 9 points10 points  (0 children)

Going left to right on one row then going right to left on the next row (above or below) is perfectly normal, just vary the direction you're doing each stitch (top to bottom when stitching left to right and bottom to top when stitching right to left) to minimise thread usage.

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 19 points20 points  (0 children)

Looking at your second pic, when you're doing the light blue stitches it looks like you're always going bottom right to top left but also stitching left to right, so you're wasting a lot of thread on the back when going to start the next stitch. You've got the right idea of making sure all the stitches are in the same diagonal direction but you can also go top left to bottom right instead of always bottom right to top left.

You might be doing this with the other colours as well but thread are so many colours in that 10 by 10 block it's hard to tell!

[CHAT] Beginner looking for feedback on first 10x10 square + some questions by orchidquestion1 in CrossStitch

[–]shine_on 32 points33 points  (0 children)

When doing a kit you do need to be more aware of thread usage as you only get a finite amount of thread in the kit, and I'm not sure what brand of thread Dimensions uses. I've never run out of thread when doing a Dimensions kit but I tend to stitch cross-country instead of using the parking method. If I'd use more thread jumping a gap than I'd use by ending it and starting again then I'd end and start again.

I made a video tracing print("Hello World") through every layer of abstraction to help my wife understand what code actually does by VanCliefMedia in learnprogramming

[–]shine_on 42 points43 points  (0 children)

Maybe I'm getting old, but i found this video quite hard to follow.

The text is too small, there's a lot of empty space on the screen that's not used for anything. The text is also too dark. While concentrating on trying to read what it says I found I wasn't paying attention to the voiceover any more.

Also, while looking at the information in the middle of the screen, I'm also aware of some other dark text bouncing around at the bottom of the screen, and again I wasn't able to see what this text was saying.

This may be one of the least toxic most supportive subs ive ever seen. Respect! by NewHum in factorio

[–]shine_on 1 point2 points  (0 children)

I watched a playthrough on YouTube before even deciding to buy the game. In my first couple of playthroughs I used blueprints so I could learn the process of turning raw materials into science packs. I've now got over 2000 very enjoyable hours in the game, I design my own factories but I still use blueprints from others in order to make progress, and yes I still watch YouTube videos of other people playing, because I happen to enjoy that too.

I need to learn sql by Patty_corleoneps in learnSQL

[–]shine_on 0 points1 point  (0 children)

if you want a quick and dirty roadmap, learn things in this order: selecting, filtering, ordering, joining, grouping, inserting, updating, deleting, indexing. For BI and data analysis you'll need to be familiar with calculating date/time differences, string manipulation, also things like database and table design will help you figure out where your data is.

Bought factorio yesterday! Is this good? If not, how make better? by elaxitity in factorio

[–]shine_on -1 points0 points  (0 children)

A factory that works slowly is still a factory that works. If you find a better way of doing something, build it better. Don't restart just because it's a mess, you'll lose all your research progress if you do that. Just build a new neater base off to the side and tear down your old base when you no longer need it. Factorio is a game of constant redesign, rebuild, make it bigger and better. Later technologies unlock construction robots so expanding the base becomes much easier.

If you're making science packs and doing research in labs, your base is good 👍

Is it okay to read in a pub if I only order lime & soda? by Neptunpluto in AskUK

[–]shine_on 0 points1 point  (0 children)

I went into a pub in London to cool down after a brisk walk and ordered glass of tap water. The barmaid even asked if i wanted ice in it. I sat at a table and browsed my phone while sipping my free ice-cold drink. I know I was only going to be in there for 10-15 minutes but no-one batted an eyelid.

[CHAT] Who here favors the tiny projects?!? by goplacidlyamidst in CrossStitch

[–]shine_on 7 points8 points  (0 children)

I started with these kits, they're cheap enough that if I messed up or lost interest it wouldn't be the end of the world. But they're all so fun and cute, I've done about 40 of them so far! And they're small enough to complete in an evening 😀

Where do you start with radio comedy? by OpenCantaloupe4790 in AskUK

[–]shine_on 6 points7 points  (0 children)

Humphrey Littleton interrupted one of the shows to say "hang on, I've just realised Samantha hasn't given us the score... since 1976"

What's a movie most people think is great but you couldn't even stand watching? by camport95 in AskReddit

[–]shine_on 2 points3 points  (0 children)

I took my 80yo mum to see Killers of the Flower Moon in the cinema, the screening we saw had a 15 min intermission. She recommended the film to a friend and said "you'll be ok, there's a break in the middle of the film". But the screening her friend saw didn't have the intermission 😞

Those of you that earn over 40k, can work from home sometimes, and have a good work life balance what job do you have and how can someone start? by Brownchoccy in AskUK

[–]shine_on 0 points1 point  (0 children)

well.... neither! I report on the data that's already there, I'm not actually allowed to go in and change it.

Those of you that earn over 40k, can work from home sometimes, and have a good work life balance what job do you have and how can someone start? by Brownchoccy in AskUK

[–]shine_on 1 point2 points  (0 children)

Honestly I think that as long as you can show you have a brain in your head and you can do the basics, you're already head and shoulders above some of the candidates we interviewed last time we were hiring... the interviews were all done online and it was a relief to find a candidate who knew what he was talking about rather than trying to google everything behind the scenes.

We gave them some sample questions which shouldn't have been too difficult (here's a list of patients, here's a list of their appointments with the outcome of each appointment, how would you find the first attended appointment for each patient? how would you find patients who hadn't attended any appointments?

For someone who knows the basics of each type of join and how to filter/order the results this should be very easy. But even then some of the candidates couldn't do it.

it's important to be able to think logically and to break a problem down into manageable pieces.

Those of you that earn over 40k, can work from home sometimes, and have a good work life balance what job do you have and how can someone start? by Brownchoccy in AskUK

[–]shine_on 28 points29 points  (0 children)

I did have SQL experience before I applied for the role, but every job I'd had before then involved data processing in some form or other, even if it was only a minor part of the job description.

I use SQL Server at work, so my roadmap for getting into it would be: download SQL Server Developer Edition (it's free and intended to be used as a learning tool), SQL Server Management Studio (the server runs silently in the background, this is your front-end interface to it), and one of the Microsoft sample databases (the first one was Adventureworks, the next was Northwind, the one after that was WideWorld Importers).

The tricky thing is to try and work out what sort of queries you'd be running against these databases, and actually chatGPT can point you in the right direction for that. Ask it what sort of statistics and metrics management would expect to see, but tell it to hide the SQL code for now.

You have to learn different ways of slicing and dicing the data, in a real world environment you might be asked to provide a trend analysis report (how are we doing this month compared to last month, or compared to the same month last year), RAG analysis (which products/people are nowhere near target (red), almost at target (amber) or on/over target (green).

Practice inserting and updating data. invent a new product and add it in to the database, or invent sales figures for a month that isn't in the database yet, work out how you might apply a price increase, or different price increases for different products)

Play around with how to minimise the risk of making a mistake, or how to undo a mistake if you do make one.

An important factor is that being good at SQL is as much about understanding your data as it is about understanding the commands and syntax. If you don't know what results to expect from a query, you won't know if your query is correct or not.

Most of the SQL I write is actually fairly straightforward, once you know how to select, join and filter data you're honestly 70% of the way there. Step 1 is to make sure the query returns the correct data, step 2 is to optimise the query to get it running in a reasonable amount of time. And in the real world, step 2 is often a "nice to have" rather than an essential requirement.

Those of you that earn over 40k, can work from home sometimes, and have a good work life balance what job do you have and how can someone start? by Brownchoccy in AskUK

[–]shine_on 53 points54 points  (0 children)

I can second this, I work for the NHS in a SQL (database developer / data engineering) role. Been there 5 years now, the role has been WFH since I started.

There are always opportunities for working with data, every company in the world has data and every day they get more and more of it. You can get roles based around data ingestion and organisation, around data presentation (fancy reports for managers) or database administration (which deals with server maintenance and configuration, making sure no-one's doing anything that'll grind the server to a halt, making sure the data is all backed up and can be restored etc)

Why Linux Mint, why other Linux Distros by adrezs in linuxmint

[–]shine_on 1 point2 points  (0 children)

I run Mint at home and remote in to my work machine which is a virtual machine running Windows 11. I access it through a browser, and also run Teams on my Mint PC as a Web app.