boxysean

Thank you for sharing <3

[dbt Labs employee here]

Cloud costs increasing could be a sign of more data being utilized productively. In any way, a mixture of data engineers and analysts is a healthy way to scale a dbt project to increase speed-of-delivery of analytics requests vs cloud costs. We at dbt Labs encourage the "analytics engineering" mindset to bring software engineering best practices into the dbt analytics workflow (git version control, code reviews), and so cloud cost considerations should be incorporated into mature dbt development practices.

[dbt Labs employee here]

Check out dbt-expectations package[1]. It's a port of the Great Expectations checks to dbt as tests. The advantage of this is you don't need another tool for these pretty standard tests, and can be early incorporated into dbt workflows.

[1] https://github.com/calogica/dbt-expectations

The name means to shift away from Oracle, red being an allusion to Oracle, whose corporate color is red and is informally referred to as "Big Red.

I learned this recently and thought I'd share! From https://en.m.wikipedia.org/wiki/Amazon_Redshift

Thanks! I eliminated that it was my machine -- I observed the same phenomenon on two machines.

I launched my own EC2 web instance in us-east-1 and hosted one of the slow files, and repeatedly downloaded it using a `python -m SimpleHTTPServer`. I similarly observed a slow download speed (128Kbps) without my NordVPN connection.

Oddly enough, I also observed a slow download speed to my us-east-1 server WITH my NordVPN connection, so that let me to believe it's a broader issue, however I did observe a fast download speed from an AWS server located in eu-central-1.

I'm generally confused. Connecting to NordVPN eliminates my issue, but the tests I am conducting are providing inconclusive evidence as to why this is the case!

I'm so sorry to hear that. I wish the best for you and your sister.

Warby Parker | New York, NY | Full-time | Onsite

Warby Parker is a transformative lifestyle brand with a lofty objective: to offer designer eyewear at a revolutionary price while leading the way for socially-conscious businesses. By engaging directly with consumers, we’re able to offer ultra-high-quality, vintage-inspired frames for $95 including prescription lenses and shipping. We focus on the bigger picture, too: social innovation is woven into the DNA of our company, and for every pair of glasses purchased, a pair is distributed to someone in need.

We are searching for a Data Engineer to join our 4-person team. Our tech stack includes Postgres, Google BigQuery, python, and Looker. Our team supports all of our business functions and is integral to speeding up our supply chain and gaining new business insights. We are situated in a team of 60 on-site engineers, where we constantly are finding and implementing best practices.

For more information, see our job posting http://grnh.se/57cr041 or reach out to me. Thanks!

Warby Parker | New York, NY | Full-time | Onsite

Warby Parker is a transformative lifestyle brand with a lofty objective: to offer designer eyewear at a revolutionary price while leading the way for socially-conscious businesses. By engaging directly with consumers, we’re able to offer ultra-high-quality, vintage-inspired frames for $95 including prescription lenses and shipping. We focus on the bigger picture, too: social innovation is woven into the DNA of our company, and for every pair of glasses purchased, a pair is distributed to someone in need.

We are searching for a Data Engineer to join our 60-person, on-site engineering team to help build the next generation of our data processing platform.

For more information, see our job posting http://grnh.se/57cr041 or reach out to me. Thanks!

Codeforces is similar to TopCoder, well-used, and is only focused on algorithms.

http://codeforces.com/

NYU team coach here writing from Russia. :)

Indeed, most of the top competitors have been practicing since high school. We were lucky to assemble a team that has been training well before.

MIT's team consists of freshmen who are still in good training since their national high school math olympiad trainings from their respective countries.

A good non-technical solution to this problem is an intentionally slow/standard Internet connection, such as at my cafe of choice.

For me, it is frustrating to be at this cafe at peak laptop hours and I think it causes people to churn in and out. So, I try to only use my laptop there when there are fewer laptop users at the cafe. I think this is a good psychological effect for the cafe to impart on its customers!

How does it feel to have a front page profile on HN? (Hi vlad! :D)

More UO nostalgia:

I started playing UO when I was about 13. My parents paid the monthly fees for a few months, but I couldn't convince them to keep paying for it. ("Do your homework, Sean!") Frustrated, my friends and I found the free, independent, emulator-run servers and started playing on them. Finding the nuances between the free servers (called "shards"), we settled on one in particular and stayed there for the next few years.

I got bored with playing pretty quickly -- I was never really good at games that required skill or huge amounts of time investment. I started talking with the shard staff, gained their trust, and "graduated" into being a moderator for the server when I was 14 by doing some minor policing (resolving disputes, busting people leveling up with macro programs like UOAssist, etc). I could warp anywhere and got to choose special colours of clothing and had this awesome counselor robe. Looking back, according to [1], I best fit a "socialiser" player.

Then I got bored of simply moderating. There were a backlog of feature requests to the lone shard developer, who was busy trying to, y'know, have a family and work his day job. At the behest of the Italian couple who ran the server, I began developing for the shard when I was 15 (having not programmed before). I did lots of simple things like create weapons and funny items with special abilities [2], my favourite being a bag of skipping stones. Then I started doing more complicated things like recreate Triple Triad from FFVIII [3], and useful things like remake the guild system.

These UO people were my friends, we hung out on IRC every day, and even did a couple of international Secret Santa gift exchanges.

I got bored again around 16 or 17 and forgot about UO, but it had a lasting impact on me:

At 18, I began studying computer science. I realized that the code I wrote to sort a list back in the UO days (not knowing any better) was actually the standard sorting algorithm, bubblesort.

(actually relevant to the link -->) At 19, I started to learn about economics and related it back in a very real way to my days playing UO. I was tempted to go back and try to design a method of distributing wealth that reduced inflation.

And by 20 I realized I was a very good programmer. (I'm now 26.) I still attribute UO at the Italians I've never met in person for that.

[1] http://www.mud.co.uk/richard/hcds.htm

[2] http://neverlands-library.com/index.php?id=4lvl - can't believe I found this / someone documented this

[3] http://neverlands-library.com/index.php?id=cards

He's in there. Try unorthodox combinations. I think there's some state stored on whether or not you went through "up" doors or "down" doors.

CBC's Spark podcast: http://www.cbc.ca/spark/

Recent stories: Limor Fried on Open Source Hardware, Cory Doctorow on the War on General Computing, Don Tapscott on the Future of Crowdsourcing.

I feel you were lacking in the number of iPads you were carrying (compared to her).

Practicing at all of these contests you mentioned basically guaranteed all my future steps (employment, school). It's not everything but it's a lot that you won't be able to do past college.

If you're in school and have the opportunity to participate in a club or practice by yourself, I definitely recommend it.