teej

61 ms·

661.
by teej 9y ago
Minted | Senior Data Engineer | San Francisco, CA | Full-time, ONSITE | https://www.minted.com/jobs?p=job%2Foenw4fwV Minted’s mission is to enable the design independence of both consumers and artists around the world, and
662.
by teej 9y ago
This is certainly disappointing to see, but it's not new and it's not surprising. It is incredibly difficult to get a travel visa from Afghanistan to the US, last year's refusal rate was 74%.
663.
by teej 9y ago
I tried to build a flight search site a few years back and many sites have measures in place to actively mitigate scraping. It quickly became obvious that I was going to spend more effort getting data than working on the product, so I scra
664.
by teej 9y ago
How old is "old", and what do you need it for? I've written code to parse the utmz cookie and separate code to recreate the whole organic/referral/utm attribution model in GA using first party log data. The only maj
665.
by teej 9y ago
I'm sure you thought of this, but what are the drawbacks to simply INCR/DECR some counters when an object changes state?
666.
by teej 9y ago
We do the same thing with Redshift. Using temp tables also gives us more direct control over the query plan, since we can specify distribution and sort keys. On top of that, we can run unit tests on the temporary table (explained in another
667.
by teej 9y ago
To make progress on this problem, I wrote a light SQL preprocessor to support INCLUDE statements. It enables me to write code like this: WITH frequently_bought_together AS ( INCLUDE frequently_bought_together.sql ) SELEC
668.
by teej 9y ago
I would call the gameplay mundane, but that's the point. Completing a tedious task with high accuracy and throughput while the complexity and stakes ramp up. I found it to be a very entertaining challenge.
669.
by teej 9y ago
For those who aren't aware: Papers, Please is a video game about paperwork. You play a border agent in a fictional eastern bloc country, checking passports, visas, and work permits. It's surprising and tense and incredibly good. I
670.
by teej 9y ago
You always have to spend time and money to get performance and consistency at scale.
671.
by teej 9y ago
The reporting DB in my case is Redshift. The business use case isn't exactly charting. My goal is to enable a business user to reference certain types of important aggregates in Google Sheets. By enabling this, business users can then
672.
by teej 9y ago
The add on doesn't talk to the reporting database directly, Google's Apps Script JDBC service doesn't support Postgres/Redshift. The add on gets data from a REST API. I then have an etl job that precalculates the aggrega
673.
by teej 9y ago
Can we talk about getting data into Google Sheets? Is there a standard way to build a pipe from, say, a reporting database to dump aggregates into Google Sheets? I built a private Add-on for my company that surfaces specific aggregates as S
674.
by teej 9y ago
SQL is quickly turning into the new Excel. Most excel power users at our company have picked up SQL easily. Our product, merchandising, marketing, finance, and operations have all managed to teach people SQL for everyday use. This tool is f
675.
by teej 9y ago
This seems so overengineered. If you're using a BI tool like Looker, you can configure how often and how long you would like your "query" to be persisted. They also support dynamic triggering - when value X changes, rerun que
676.
by teej 9y ago
You cannot run a massive, scalable website without analytics the same way you cannot run massive, scalable infrastructure without monitoring. It's like driving with your eyes closed. This discussion got me thinking about releasing my o
677.
by teej 9y ago
I don't think it's worth tossing out such a statement without at least some justification of the tradeoffs and costs. Do you think it is a smart deployment of capital and mindshare to spend money for server costs, eng implementati
678.
by teej 9y ago
To be completely honest, the legal and cultural landscape in Europe is nothing at all like the US when it comes to letting employees go. Being US based, I would be extremely hesitant taking your advice if you haven't spent time in the
679.
by teej 9y ago
Maybe I just don't have enough experience with the competitors but I had to spend significant time writing wrappers and tooling to make Lambda usable in a sane way. Off the top of my head, I added - prefix logging, controlled timeouts
680.
by teej 9y ago
I'm surprised no one has commented on this. Reddit has 270m monthly actives? Doesn't that make it as large as twitter/instagram/Snapchat?
681.
by teej 9y ago
Can't the user just reset their password again?
682.
by teej 9y ago
The right solution on earth, with its fancy pants atmosphere.
683.
by teej 9y ago
Cyber security is everyone's responsibility. In the US at least, hospitals and their staff are held responsible for the proper care and handling of patient health data. In my opinion a hospital administrator should definitely be held a
684.
by teej 9y ago
Amazon is literally an online store. A vast majority of their sales comes from selling things to you. Including the damn Echo this service runs on.
685.
by teej 9y ago
> Coincidentally, many of the "fake news" links they knocked down were sites that also criticized Facebook. Citation needed.
686.
by teej 9y ago
> You are mostly right, but are there any cases that a programmer wants to join a company and he can't even write a FizzBuzz program? Maybe I'm just being cynical but once you get involved in the process of screening candidates
687.
by teej 10y ago
You can use: <meta name="googlebot" content="nosnippet"> https://support.google.com/webmasters/answer/6229325?hl=en
688.
by teej 10y ago
Sorry, this is just vanilla redshift.
689.
by teej 10y ago
Just for comparison's sake, I recreated Jeff's example queries on my in-house table that's ~8B rows. COUNT(*) takes 6s and the SELECT with 2 groups, 2 sums, and 2 averages takes 52s. The downside is that the table takes 600GB
690.
by teej 10y ago
Job posts should wait until the monthly Who's Hiring thread posted on the 1st.

More ›