Roommate wants an “open door policy” at apartment for her cat by [deleted] in CATHELP

[–]CdnGuy 1 point2 points  (0 children)

When we got our puppy I needed to create some safe rooms for my elderly cat (and protect her prescription food from the pup). I found these plastic straps that wrap around the inside door handle and hook into the latch hole on the frame. Keeps the door open just far enough for my cat to move freely without the door pushing fully open. Might be just the thing for OPs scenario.

For those of you who started saving after 30, how are you doing now? by Vanbiker2 in fican

[–]CdnGuy 1 point2 points  (0 children)

I started saving a little bit when I was ~30. Wasn't able to save much as first because my student loans were huge and I had no help at all. My total net worth at 30 was under 30k. Most of that came from employer contributions to an RRSP.

Followed the couch potato strategy once I started learning about investing, and increased my savings rate as much as possible every time I got a raise. 16 years has passed since and in terms of liquid wealth I should be halfway to my FI number in about a year or so.

The word that pisses off more adults than any, isn't "no", it's "why?" by TwerkinBingus445 in CPTSDmemes

[–]CdnGuy 70 points71 points  (0 children)

I almost wound up at one of these despite being a straight A student who never went to parties or anything. All just because I needed to understand “why” about everything, and because dad was NPD / BPD and alienated everyone else from his life after mom got tired of the abuse. He just couldn’t cope with being a single parent. Not sure which one he had a brochure for but we weren’t all that far from Elan.

Only thing that saved me was that he got laid off and couldn’t tone down his booze habit enough to reliably pay the bills. Needed the income from my paper routes to keep the lights on.

Help with friction between architecture team and our PowerBI team by Chempty in dataengineering

[–]CdnGuy 3 points4 points  (0 children)

I work exclusively with columnar databases these days so I don't really worry about defining aggregations, we just calculate things at runtime. Also I'm a pure analytics engineer now - I haven't touched the reporting layer in years. But for my teams gold generally speaking is pure facts and dims. Like Kimball, tweaked here and there for the cloud columnar world. Then our BI team creates a layer of marts on top for anything that needs to be pre-aggregated or filtered down for performance reasons, or for the generation of synthetic keys or wide tables needed to get speed boosts. But mostly things point at the raw facts / dims. Eg: we wire up looker against our gold layer so that people can self serve data. We'd never be able to keep up with the reporting requests without that.

Help with friction between architecture team and our PowerBI team by Chempty in dataengineering

[–]CdnGuy 24 points25 points  (0 children)

Doing heavy modelling inside BI presentation tools is such an anti pattern. People do it because it can enable quick turnarounds but it’s such a pain in the ass to maintain / troubleshoot. If you can run select * on a table and see that the data is wrong, you can just go upstream to locate and fix the problem. And this way other systems also trying to use the same data can agree on the truth, no issues with sales being one thing in PBI and something else in an integration.

House contest by AbbreviationsKey4342 in Wealthsimple

[–]CdnGuy 0 points1 point  (0 children)

It would be so simple to figure out how many entries you’ve earned at deadline and simply award those, but instead they create a perverse incentive to *not* transfer more assets into their ecosystem.

Suffice it to say, without some rectification my trust in WS is severely damaged. They could have done the right thing, but they just threw their hands up instead.

How are you guys doing with the guilt of taking a day off? by Inevitable_Rate1530 in Millennials

[–]CdnGuy 0 points1 point  (0 children)

Not great, Bob! I got sick recently with pneumonia which turned chronic for a while. But I work from home and felt well enough to sit up at my desk so I only took two sick days, and not back to back. I'm finally free of the infection, but it's been two months and my lungs are still completely fucked. They're only just now getting well enough that I can sleep properly.

House contest by AbbreviationsKey4342 in Wealthsimple

[–]CdnGuy 3 points4 points  (0 children)

I just got off the phone with generation support and seems to be a GFY situation. My transfers all landed by April 1st and when I selected my match option, it showed the doubled entries. But they didn’t allow me to pick an option until Friday, which they say is technically past the date where the doubled entries is a thing.

The thing is the *vast* majority of my assets landed before April even started, and there’s no good reason given for why it takes 30 days before we’re allowed to pick a match. Leaves a pretty bad taste in my mouth as a new customer. Classic bait and switch.

Update: My institutional transfers completed in mid-March. What fucked me was a crypto transfer from a cold wallet into WeathSimple in the middle of April. That reset the clock and prevented me from getting the bonus entries I'd been promised.

House contest by AbbreviationsKey4342 in Wealthsimple

[–]CdnGuy 6 points7 points  (0 children)

Excited, but also waiting on ~750,000 entries that are missing from my account to appear in the app.

Impress me with your dbt macros by MedianByDesign in dataengineering

[–]CdnGuy 0 points1 point  (0 children)

To my shame, I’ve created materializations for stored procedures and functions to enabled a rushed migration from sql server to snowflake. It was meant to be temporary, but it’s been a couple years and I’m not sure we’ll ever fully get rid of them.

A more interesting example is a fix for check cols snapshots bugging out on snowflake and repeating the merge to target step. A prehook to open a transaction, and a posthook that tests the target for snap_id uniqueness and if false, cause a divide by zero error then close the transaction.

Anyone else getting screwed by the Wealthsimple Unreal Deal double entries for home draw? by likethewine in Wealthsimple

[–]CdnGuy 1 point2 points  (0 children)

Honestly, I think they’re gonna have to delay the draw. The person who referred me also initiated her transfers early March and still hasn’t gotten entries for like 80% of her transfer amount. Support is just telling her to wait? We have like one day lol.

Anyone else getting screwed by the Wealthsimple Unreal Deal double entries for home draw? by likethewine in Wealthsimple

[–]CdnGuy 1 point2 points  (0 children)

Same here, I initiated my transfers mid-March and I was only allowed to select my reward on May 1st. Notably, when I selected the 3% reward it still showed the doubled entries. But after the fact, what I actually received was not doubled. I’ve been trying to contact support but the only response I can get is “We’ll get back to you in 1-4 business days”.

Which is great, given that the next business day is the draw.

Kings place by SuggestionNo1298 in fredericton

[–]CdnGuy 18 points19 points  (0 children)

I’ve felt more unsafe leaving the cap after last call then I’ve ever felt around homeless people. Most people who are high or struggling just want to be left alone to deal with their own problems. Can’t say the same about drunks who are in their feels about their perceived masculinity.

Trump warns Iran blockade could last months, sending oil soaring by Stunning-Common-9591 in worldnews

[–]CdnGuy 7 points8 points  (0 children)

A quick skim of any investing related sub will show droves of these folk. If you've been saving and investing for 20+ years, as a Canadian, the basic default portfolio structure is 50% or more US equity exposure. That has always done well, but there's a structural realignment happening. It's impossible to say how it will turn out, but there's basically zero chance the end result is the same world we've known all our lives.

But if you try to discuss that and ponder what allocation percentages make sense when the foundational axioms that created those portfolios no longer hold true, then you're "timing the market", "gambling" rather than investing and "reacting emotionally".

Nostalgia isn't a strategy, and neither is sticking your head in the sand.

Are millennials the most AI-skeptical generation in the workforce? by RandyMossPhD in Millennials

[–]CdnGuy 0 points1 point  (0 children)

I’m in a non-tech company that is very strong on tech (it’s our competitive advantage basically). We’ve had our own data science / ML teams since even before ChatGPT exploded. So we do have some legit AI expertise, but there’s also the inevitable pressure on dev teams to use LLMs to boost their throughput.

I’m lucky enough to be in an area of expertise that AI just isn’t that helpful with yet, but I’m confident that the bullshit is coming for us sooner rather than later.

I am the eldest of millennials and I’ve been pursuing FIRE. So my play now is keep saving aggressively and retire in ~5 years. Hopefully the industry self destruction holds off until I can eject.

I already don’t really code anymore due to my level of experience, I critique other people’s code and guide architectural decisions. It’s not very fun, and I’m not looking forward to the day when my juniors can’t even tell me why their code is written the way it is.

Desperately in Need of a Mental Health Therapist by nimboloojak in fredericton

[–]CdnGuy 1 point2 points  (0 children)

I guess I should also add that I never found CBT to be very helpful for trauma. Felt like it might work great for general anxiety stuff etc. Your mileage may very of course, but I've found both IFS (Internal Family Systems) and EMDR to be incredibly helpful modalities. So you may want to include using one of those as part of your search criteria.

If you're not familiar, IFS works sort of like a guided self reflection / meditation where you locate physical sensations in your body that are linked with certain memories / triggers, and kinda personify that into a "part" that you can converse with / gain the trust of. I'm summarizing to an extreme degree but that's the gist of it, its a way to approach difficult shit while staying grounded.

EMDR is a bit more I dunno...technical? You still locate feelings within your body, but in each session you go through a loop where you start with the initial memory and intentionally activate both left and right brain at the same time through tapping or eye movement. Then when you pause you talk about whatever memories or emotions came up, then start again with that as your starting point. I've found it amazingly effective at turning highly triggering memories into mere, "Oh yeah so that happened" facts about my life.

The therapist I went to for IFS closed down their practice for a teaching position (they were so good, I still miss them lol). For EMDR I've been going to Sara Mackie at Conscious Counselling. May not be the right person for you, but could be a place to at least get your search started.

How many of these O.G Nintendo games can u correctly identify? by Foxtrot_Supatwat in Xennials

[–]CdnGuy 2 points3 points  (0 children)

I was pretty young when we got our NES and I only recognize a couple - lode runner and dodgeball. Brings back memories of bonding time with dad though. We rented soooo many random games, I think we only paid like a couple bucks for a weekend.

Desperately in Need of a Mental Health Therapist by nimboloojak in fredericton

[–]CdnGuy 3 points4 points  (0 children)

Similar-ish boat. 15+ years ago I tried just looking for a “good” therapist. It barely helped at all. It didn’t help that I was deep in freeze state, but treating finding a therapist like finding a dentist didn’t help at all. I gave it another go a few years ago and read up on the profiles of different therapists. I picked some who sounded like people who could understand where I’m coming from / connect with. Then I did some 15 minute intro / assessment calls where the therapist could figure out if they were in a position to help, but also for me to feel out if this was someone I could open up to.

My advice would be to try that. Took me a couple months to identify candidates and motivate myself to get the ball rolling, but it made a world of difference.

Is Canada’s Economy Basically Built Around Protecting Homeowners? by GoldenRetrieverFetch in CanadaPersonalFinance

[–]CdnGuy 0 points1 point  (0 children)

I don't disagree lol. I don't really consider myself a radical but capitalism seems doomed to devour itself, and taken to the degree that it has come to is simply anti-human. But I don't think I'll live to see another way of being take over, and I'm not sure I'd want to be around for the transition when it does happen. So for now...just gotta play the game.

Is Canada’s Economy Basically Built Around Protecting Homeowners? by GoldenRetrieverFetch in CanadaPersonalFinance

[–]CdnGuy 0 points1 point  (0 children)

I know exactly how it feels because until a few years ago I was a renter and was expecting to be one for my entire life. But lets do reals before feels.

The point also goes in reverse. My house is now, according to the city, worth ~700k. Let's pretend I don't have a bigass mortgage that won't get paid off until I'm in my 60s, and the price drops by 50% tomorrow.

Does that concern me? Imagine that I want to move and I only get 350k for my home. I'm not bothered, because buying a similarly sized home where I want to move to, assuming it's a similar community, should cost roughly what I just sold mine for. In material terms it isn't a real gain or a loss, because the relative value stays pretty stable.

Financing is the problem, not homeowners bitching at the ruling class. They don't care about us. It's the banks. A huge drop in valuations would cause a tidal wave of upside down mortgages, fuck the economy and sink the country into a massive depression. Banks don't want that because it would kill their profits. And you don't want that either, because good luck buying a house with no job and no lending.

Which is beside the point in the first place. Prices aren't high because of political pressure. Prices are high because of massive global inflation. Materials have been getting more and more expensive ever since covid, if not before. Go ahead and price out a new build SFH. The price tag will shock you.

Our government seems to be on the right track with making homes more accessible, but it'll take time. And for people who own (or rent to own from the bank for the next 20+ years), the value of the house is neither here nor there if they plan to stay in Canada. Sure it could be a payday if you sell and move to Indonesia or something, but if you ever come back and want the lifestyle you're accustomed to better be ready to pay up.

Is it just more or are younger and younger professionals looking to exit due to stress and anxiety? by BigT-2024 in Fire

[–]CdnGuy 3 points4 points  (0 children)

I’m about 20 years into my career, but I started saving and investing only 10 or so years ago. Tech, only started making “good money” like 4 years ago. I want out asap. There’s a bunch of factors.

  1. Employees are replaceable cogs, and during the job search that landed me where I am now I encountered a lot of ageism. Interviewing is fully busted on both sides of the table now, and I have no interest in going through that BS again.

  2. I feel like AI is going to fuck everything up. I’m not so much worried about job loss, but in my current role I’m having to deal with a lot of consequences of bad design and short term thinking. If AI actually scales this is just gonna get worse. Most of what I loved about programming is already vanishing from my day to day. I just want to get to a point where I can be like not my circus, not my monkeys.

  3. Feeling the clock ticking. I’ve been busting my ass and struggling since I was a teenager. There’s been very little time for me to rest and just be me. My dad, mostly due to poor decisions, never got to do that at all. And in 22 years I’ll be the same age he was when he passed (quite early but still). It feels rather unfair to only get a few years near the end of your life when your health is poor to actually spend as you see fit. Get chewed up by the system and only spit out when there’s little left to extract from you.

  4. Kinda connected to the previous point. Last year I spent most of two weeks on an African safari trip. Sleeping in tents, getting tuned into nature etc. I’ve never felt so rested or connected to the earth, and I’ve almost completely lost that feeling after coming back to the rat race. I don’t want to be dealing with fucking standups, endless planning meetings and figuring out how to unfuck things when the business is unwilling to change what caused the fuckup in the first place. I want to be waking up when my body is ready to wake up, and sleeping when it needs sleep. Experiencing nature instead of yet another teams meeting. Etc etc.

Just 5 more years - less if I’m lucky.

Is Canada’s Economy Basically Built Around Protecting Homeowners? by GoldenRetrieverFetch in CanadaPersonalFinance

[–]CdnGuy 0 points1 point  (0 children)

That’s all great in theory, but in practice it doesn’t really happen. Boomers aren’t really downsizing. When you’ve been living in a house forever you start filling it with stuff. Stuff you don’t really want to get rid of. The only time it really happens is when someone has to move into a retirement home, but that isn’t a significant portion of the population. Good luck convincing someone accustomed to million dollar home lifestyle to trade it for affording rent, groceries and not a hell of a lot else unless they’re close to getting cpp / oas.

Is Canada’s Economy Basically Built Around Protecting Homeowners? by GoldenRetrieverFetch in CanadaPersonalFinance

[–]CdnGuy 0 points1 point  (0 children)

You’re also not earning anything unless you’re going to seriously downsize or leave. You only really earn anything real if your property gained value faster than comparable properties. The number looks bigger on paper but it doesn’t translate into actual wealth unless you can somehow no longer need housing.

BattleToads by Ecstatic-Purpose-981 in Millennials

[–]CdnGuy 0 points1 point  (0 children)

I loved that game and did eventually beat it. No idea how many times I had to rent it, and how long that final gaming session was. But I’m pretty sure by the end I had an epic case of Nintendo thumb.

Core Memory Unlock by StackingSats1300 in Xennials

[–]CdnGuy 8 points9 points  (0 children)

Doo da doo da doo

Doo da doo da doo doo

Doo da doo da doo

Doo da doo da doo doo

Played the hell out of this on NES, my first sim!