Open Side Menu Go to the Top
Register
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** ** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD **

03-29-2020 , 09:51 PM
Quote:
Originally Posted by jjshabado
Congrats!

Is there a final tldr; on old company? Or is it basically just, people stopped getting paid, everyone left?

They formally laid everyone off and we all got backpay. I cant say much more other than in my personal opinion I think the company was a fraud.

Im making almost 33% more now.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-30-2020 , 04:00 AM
Really need to improve my DB related skills. Mainly MySQL and MariaDB. Good reminder was recently some Innodb corruption which was I unable to fix.

Any ideas for good advanced level online courses including hopefully data migrations, troubleshooting, auditing etc. The longer the course the better. Doesn't have to be free but ideally something like monthly fee on training site or Udemy course rather than professional course or boot camp costing hundreds of pounds

Last edited by vento; 03-30-2020 at 04:12 AM.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-30-2020 , 06:34 AM
Quote:
Originally Posted by vento
Really need to improve my DB related skills. Mainly MySQL and MariaDB. Good reminder was recently some Innodb corruption which was I unable to fix.

Any ideas for good advanced level online courses including hopefully data migrations, troubleshooting, auditing etc. The longer the course the better. Doesn't have to be free but ideally something like monthly fee on training site or Udemy course rather than professional course or boot camp costing hundreds of pounds
So far best I've found is https://www.udemy.com/course/mysql-b...a-mysql-admin/

Suppose I need to find individual tutorials for specific issues.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-30-2020 , 01:30 PM
Congrats jmakin.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-30-2020 , 06:15 PM
Congrats jmakin! Glad you found something interesting and are getting paid out by the old gig!
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-30-2020 , 07:59 PM
Quote:
Originally Posted by jmakin
They formally laid everyone off and we all got backpay. I cant say much more other than in my personal opinion I think the company was a fraud.

Im making almost 33% more now.
Glad to hear it.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-31-2020 , 12:14 AM
https://stackoverflow.com/questions/...method-has-bug

Anyone else ever run into this weird JS Date issue? One unit test was failing, but only in the CI/CD environment. Turns out that test was through some code taking an initialized Date() object and trying to set the month to June. Well June 31 doesn't exist so JS bumps the date to July 1.

Code:
// we want a Date object for 6/14/2019

const newDate = new Date(); 
// newDate = 3/31/2020

newDate.setYear(2019); 
// newDate = 3/31/2019 - so far so good

newDate.setMonth(5); 
// this should set the month to June because months are zero-based,
// while days are 1-based - because GFY that's why
// however now newDate = 7/1/2019 - not good
// JS bumps the date by 1 day, since 6/31 can't exist 

newDate.setDate(14); 
// newDate = 7/14/2019 - one month off the actual date we wanted
On my local machine it was still 6/30 so we weren't seeing the test fail - but the AWS CICD build job is on GMT so it was 6/31 - ARGH.

20+ years of JS development - never ran into that one before. If I hadn't figured it out today, and went back to test tomorrow - the situation would be reversed - my local would fail while CICD would work - and I'd be even more confused. Then one more day and everything would work again, which would have driven me nuts.

Not my code but this seems like a suboptimal way to create your own arbitrary date object. Is this even recommended?

For now I implemented the solution in the SO issue where you set month and day at the same time:
Code:
newDate.setMonth(6, 14);

Last edited by suzzer99; 03-31-2020 at 12:21 AM.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-31-2020 , 07:46 PM
What’s the reasoning for constructing it in steps in the first place? Any time I need a specific date, we just initialize it there
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
03-31-2020 , 09:18 PM
How - using a string? The dev who did this said he was having problems with inconsistencies on different browsers doing that. But he might have been trying a weird format or something.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-01-2020 , 06:55 PM
what happens if you did this a few weeks ago

const newDate = new Date();
// newDate = 2/29/2020

newDate.setYear(2019);
// newDate = ?

I remember mysql having a similar issue years ago, but it looks like it's fixed.
Now mysql will just go to the last day of the month

date_add("2020-03-31", interval 1 month)
2020-04-30

date_add("2020-01-31", interval 1 month)
2020-02-29

date_add("2019-01-31", interval 1 month)
2019-02-28

date_sub("2020-02-29", interval 1 year)
2019-02-28

It used to give you "2020-04-31" for the first query.

Last edited by blacklab; 04-01-2020 at 07:01 PM.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-01-2020 , 07:27 PM
Maybe it was this that I was thinking of

CREATE TABLE `test1` (
`id` int(11) NOT NULL,
`datex` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `test1` (`id`, `datex`) VALUES ('1', '2020-04-31');

SELECT * FROM `test1`

id datex
1 0000-00-00

I know oracle will give you an error on the insert.
Mysql says sure insert but we'll make it 0000-00-00
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 12:17 PM
Hey guys, I am set to graduate in August of this year and just received an offer from a FAANG. The only problem is that I have one very tough semester in front of me, with a notoriously difficult math course required for graduation. I've never failed a course before but am freaked out by the possibility of failing this one and losing my offer. The offer letter states that they will attempt to convert my job offer to an internship if my graduation date changes.

Do I request a December start date to buy myself time to re-take the course (if necessary)? Or do I take my chances and go with a September start date?

Under normal circumstances, I'd go with the September option. But given this COVID-19 mess, I am worried that if I lose this offer then I might be waiting a longgg time before I find another one.

Any advice is much appreciated.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 12:25 PM
Quote:
Originally Posted by suzzer99
How - using a string? The dev who did this said he was having problems with inconsistencies on different browsers doing that. But he might have been trying a weird format or something.

You can set all 3 (month year day) in the constructor, there doesn’t need to be interim steps using set functions


new Date(year, monthIndex [, day [, hours [, minutes [, seconds [, milliseconds]]]]])
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 02:25 PM
Quote:
Originally Posted by Mossberg
Hey guys, I am set to graduate in August of this year and just received an offer from a FAANG. The only problem is that I have one very tough semester in front of me, with a notoriously difficult math course required for graduation. I've never failed a course before but am freaked out by the possibility of failing this one and losing my offer. The offer letter states that they will attempt to convert my job offer to an internship if my graduation date changes.

Do I request a December start date to buy myself time to re-take the course (if necessary)? Or do I take my chances and go with a September start date?

Under normal circumstances, I'd go with the September option. But given this COVID-19 mess, I am worried that if I lose this offer then I might be waiting a longgg time before I find another one.

Any advice is much appreciated.

Haha this sounds like a post I would make. Just pass the course man. If you got into a FAANG on graduating you’re not gonna fail, I’m sure of it. And if you do fail and lose the offer - you got an offer from a FAANG, you’ll find another job no problem
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 02:27 PM
I thought FAANGS were all into dropping out before you graduate.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 03:23 PM
Thanks jmakin, I'll take your advice. I tend to overthink this kind of thing
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 03:30 PM
A. Obviously you are going to pass
B. They didn’t even check that I actually graduated after making an offer contingent on graduation
C. What suzzer said
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 07:14 PM
I agree with the others. It doesn't make sense to alter your plans based on something that you're worried about happening, but that is unlikely to actually happen. Plan for the best case scenario, and if something bad happens, make an adjustment at that time.

But I feel you on the intimidating math class. I absolutely hated Linear Algebra. The teacher sucked, and I just didn't get why it was important at the time. Not that I would want to take it over again, but I wish I could have known some of the interesting applications for it at the time. I had a bad trip in college, and I looked up at the sky and saw all the stars in their majesty. They turned in to a huge matrix, and all of a sudden I thought I was going to die. For a short time, I was afraid that Linear Algebra was going to kill me. Fortunately, it didn't. I passed the class, graduated, and got a job. You will, too.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 08:23 PM
Haha alright, I'm convinced. Thanks guys.

Re: the math class. It's numerical analysis. I had a rough time in both linear algebra and calc II and apparently this is a not-so-fun blend of those two topics. Yay math!
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-02-2020 , 08:36 PM
It is a hard class but in most colleges harder classes become easy to pass because your peers will suck at it too and the curves easy to beat for the smart student. I can assume just on the basis of the offer you got that you are likely in the top 10% of students (or better). It’ll be hard but you have a good job and a big salary over the horizon. And trust me there will be harder things you’re going to encounter out there in the wild.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-03-2020 , 01:12 PM
Oh man, I was really hoping the real world would be easier / less stressful than my CS degree. This has been the most difficult thing I've ever done. When I started, I thought that my several years of battling in the poker world would prepare me for the difficulty of this degree. NOPE! This is way harder.

For those of you with a CS degree, how do you compare the difficulty/stress of your job with the difficulty/stress of your school years? Do you miss school at all?
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-03-2020 , 01:39 PM
That was probably a poor choice of words. I am still a noob in this world. For me, what I am into now is much deeper and broader in scope (infrastructure engineer for a large ecommerce company). CS wasnt too bad for me. YMMV obviously.

Managing people was far more difficult than CS for me too.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-03-2020 , 01:47 PM
First week down as an individual contributor. It’s so nice just worrying about myself and my own contributions to the team rather than the team as a whole.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-03-2020 , 02:50 PM
Quote:
Originally Posted by Mossberg
Oh man, I was really hoping the real world would be easier / less stressful than my CS degree. This has been the most difficult thing I've ever done. When I started, I thought that my several years of battling in the poker world would prepare me for the difficulty of this degree. NOPE! This is way harder.

For those of you with a CS degree, how do you compare the difficulty/stress of your job with the difficulty/stress of your school years? Do you miss school at all?

School was way more stressful than essentially any job I have had so far if that helps. I miss the rate of learning and structure to it though
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote
04-03-2020 , 11:07 PM
Quote:
Originally Posted by Mossberg
For those of you with a CS degree, how do you compare the difficulty/stress of your job with the difficulty/stress of your school years? Do you miss school at all?
They're just very different. "Difficulty" is hard to compare but in general I'd say the majority of jobs are much "easier" than school. There's very few situations where there's a really hard work problem that you have to figure on your own in the way that you do in school.

Stress is a different animal and probably depends on your personality, ambitions, job, etc. I think I've only had a few times where I'd say I've been stressed at work more than times at school. But those times were pretty terrible because there's often not a clear end goal/date the way there is in school and a lot more can be on the line than just failing a course.

But for your last question, nope. Not at all. I may go back for fun at some point but that would be a totally different situation than when I did my undergrad.
** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** Quote

      
m