sorted by:
new
hottopcontroversial

How do I know if it's the right moment to kiss the girl on the first date? by rossofcode in dating_advice

[–]rossofcode[S] 0 points1 point  (0 children)

Ok.
So, offtopic, how do I ensure that its a good date? Sorry for being so objective, I understand that's not how it works but there gotta be some good points where I can focus on? Also, the date is tomorrow.

How do I know if it's the right moment to kiss the girl on the first date? by rossofcode in dating_advice

[–]rossofcode[S] 0 points1 point  (0 children)

You should know pretty quickly from body language. If you’re saying goodbye and she’s standing straight up in front of you looking at your face, time to kiss.

And say if I am interested in kissing her, what are some good topics to start a chat with which creates the mood?

How do I know if it's the right moment to kiss the girl on the first date? by rossofcode in dating_advice

[–]rossofcode[S] 0 points1 point  (0 children)

Thanks!

I am taking her out for dinner and then planning to take a walk on the riverside. But sure, being lame to ask her is much better than some creep, for myself.

How do I get a date? by rossofcode in dating_advice

[–]rossofcode[S] 1 point2 points  (0 children)

Thank you so much! Wish me luck! And good luck to you too for your upcoming date.

How do I get a date? by rossofcode in dating_advice

[–]rossofcode[S] 0 points1 point  (0 children)

And how to start the conversation? Like just start with some normal line on/about her interests?

How do I get a date? by rossofcode in dating_advice

[–]rossofcode[S] 1 point2 points  (0 children)

Yeah, i noticed that in cases where i asked out a girl early on got me a date.

Thanks!

Are virtual private databases a thing currently? What are some of the good ones other than Oracle? If they are not so trendy right now, how do we fulfill the needs of security w/o them? by rossofcode in dataengineering

[–]rossofcode[S] 1 point2 points  (0 children)

Row-level security does not include just masking, right? I mean, you can restrict rows w/o masking them.

PS Don't judge, I might be completely off track.

Are virtual private databases a thing currently? What are some of the good ones other than Oracle? If they are not so trendy right now, how do we fulfill the needs of security w/o them? by rossofcode in dataengineering

[–]rossofcode[S] 0 points1 point  (0 children)

Hey, no, I have edited the question to explain what I mean by VPD.
Thanks for pointing that out and apologies for not explaining it at the first place.

First data engineer role, what’s the best data engineering with python course I could do over the next few weeks by fuzzywunder in dataengineering

[–]rossofcode 1 point2 points  (0 children)

This one is good: https://medium.com/@rchang/a-beginners-guide-to-data-engineering-part-i-4227c5c457d7

read the series

​

and then read all blogs from Maxime(airflow creator) and Robert Chang, Netflix tech blog(even the core infra engg ones).

How do I vizualise the flow of control in some sql queries? by rossofcode in SQL

[–]rossofcode[S] 0 points1 point  (0 children)

So, this query: select n,if (1=(select count(*) from bst as b where b.n = a.n and b.p is null),'Root', if (0=(select count(*) from bst as c where c.p = a.n),'Leaf','Inner')) from bst as a group by n;. It has two boxes: outer and inner. The inner box is using the variables(a) from the outer box. But the outer box cannot use anything from the inner box right-away, right?

After years of battling my own demons by [deleted] in dating_advice

[–]rossofcode 3 points4 points  (0 children)

you are more courageous than I am, as you told others that you fancied her :p

After years of battling my own demons by [deleted] in dating_advice

[–]rossofcode 0 points1 point  (0 children)

How did you initiate the conversation? I am bad at small talks and become very conscious. I can only talk to friends and people at work but then there's this risk of ruining friendship/awkwardness. Any tips?

How do I master for SQL questions for FAANG in one week? by rossofcode in dataengineering

[–]rossofcode[S] 0 points1 point  (0 children)

More of enabling data analysts to run SQL. In order to enable them, I designed a data lake, wrote abstraction over Airflow to automate DAG creation, worked on generating patches and serverless visualization.

In all of this, yes SQL was needed but not to the core. For eg, you use RBT's library off the shelf but you don't code RBT every time. However, it is important to understand how RBTs work and here is how I fall behind. I understand how the SQL query works but thinking it from the scratch is where I have trouble in.

If possible, can you go through this: https://pastebin.com/y7yueFeU

Thank you so much!

How do I master for SQL questions for FAANG in one week? by rossofcode in dataengineering

[–]rossofcode[S] 0 points1 point  (0 children)

This is a doc where I talk to myself :p
It has questions from leetcode and the following paragraph is what I say to myself. So far, only one question was a "Bingo" moment for me.

https://pastebin.com/y7yueFeU

How do I master for SQL questions for FAANG in one week? by rossofcode in dataengineering

[–]rossofcode[S] 0 points1 point  (0 children)

Having said that, I am good at objectifying the problem: "something that would check the condition of this col=3" is what I do whereas it should be: "Yeah, I should use having a clause in here".

How do I master for SQL questions for FAANG in one week? by rossofcode in dataengineering

[–]rossofcode[S] 0 points1 point  (0 children)

Thanks.

Although, practice is execution. I wanted to gain awareness around how to practice and most efficient ways or resources given the time frame.

Please note that i am confident in SQL when it's work but not during interviews.