meritt

I mean it just happened 2 hours ago, so pending a formal police report, I imagine details will indeed be light. Here's aftermath footage and bystander details: https://twitter.com/JennyGShao/status/1153066059802402816

These sort of unfortunate accidents happen every day but any self-driving vehicle will be scrutinized. If the driver was in control and ran a red light, they're obviously at fault. If the AP went haywire and caused this, who is legally culpable?

> I am in the process of dockerizing almost everything in sight

How many other individuals in this clearly legacy organization have the knowledge and experience to take over your "superior" variant of technical debt once you get sick of the job and move to something trendier?

I'm routinely confused about the role these sort of tools play. I conceptually understand what they're doing but weren't these problems solved a long time ago with materialized views and foreign data wrappers?

The hard part of ETL for me has always been gracefully handling the outliers, the data that you need to look at within the context of multiple rows (e.g. duplicate rows that aren't exactly the same so it's not a simple SELECT DISTINCT) in order to make the correct decision, or the entity matching/mapping/categorization that often is necessary. Having the lookup tables that often need manual oversight when new entries show up that haven't yet been properly tagged. Or if you're ingesting address data and you want to normalize it through a geocoder, where exactly does that occur in these SQL-templating "pipelines"?

I feel like these are basically focused on moving data between different DBs and generating group-by queries to populate some rollup tables?

> breaking the site's T&C

T&C's have absolutely no bearing on publicly accessible information [1][2][3]. They only apply to registered users accessing login-required portions of your website or application. Browsewrap does not represent a legally binding contract, no matter how much you pay your lawyers to write up your irrelevant T&C's.

[1] https://www.eff.org/deeplinks/2018/04/scraping-just-automate...

[2] https://www.eff.org/deeplinks/2018/04/dc-court-accessing-pub...

[3] https://www.eff.org/deeplinks/2018/01/ninth-circuit-doubles-...

> then surely Twitter themselves blocking individuals is also a violation

That's quite the leap. Twitter is not a representative of the federal government.

Correct, this behavior is well-known and has been around for 20+ years. Leading spaces are removed and additionally other spaces or dots are converted to an underscore.

For this reason, many frameworks ignore the default $_GET structure and instead access the raw URI query in $_SERVER['QUERY_STRING'].

That's not perfect btw, many apps today are using websockets (e.g. https://github.com/daltoniam/Starscream) to connect upstream and they bypass iOS/Android proxy settings entirely with no way for http based mitms to see that traffic.

Gotta fall back to wireshark for 100%.

Have you read about the 2016 United States election interference? [1] Or the Russian probing of the US power grid? [2]

Russia has been attacking critical infrastructure in the US for years. This is at best an incredibly latent response from a government who in many cases welcomes these attacks.

[1] https://en.wikipedia.org/wiki/Russian_interference_in_the_20...

[2] https://www.nytimes.com/2018/07/27/us/politics/russian-hacke...

What was the monthly revenue for this startup? Those are absolutely insane numbers.

That guy still works at Panera and guess where he worked prior as Sr Director of Security Operations... Equifax!

https://www.linkedin.com/in/mike-gustavison-b020426/

It comes from a sample size of 3: https://www.levels.fyi/salary/Lyft/SE/T3/

There's zero validation to this data. If you feel it's too high, just submit a lower data point: https://www.levels.fyi/addcomp.html

Just because a profession is challenging or time-consuming does not mean the pay will be commensurate. Those little Wordpress sites are often responsible for significant amounts of small business revenue and the people who keep them running smoothly are paid accordingly.

If you want to get paid more, find a position where your work has a direct and measurable impact on revenue or profit and your compensation will flourish. And if you're already doing that without the pay, then it's time to find a new employer.

Interestingly enough, the use of toxicants for animal control was made illegal on federal lands in 1972 by Nixon [1] (Executive Order 11643) and then later amended by Ford in 1975 (to specifically allow cyanide bombs) and finally revoked entirely in 1982 by Reagan.

[1] https://www.nps.gov/subjects/legal/upload/Proclamations_and_...

Sorry I'm not following your math here. Which numbers allow you to back into $85mm and $80mm?

Keep in mind you're replying to the CEO of a YC W13 company that wasn't acquired two months ago for $150M by Google (that was his competitor, Alooma [1]) and wasn't acquired in November for $60M by Talend (that was Stitch Data, another competitor [2]). Your points are absolutely valid, you're just barking up the wrong tree. Both of those were SaaS-based ETL connector companies that were acquired while executing a similar enough strategy, and they both saw nice exits.

If you look at his comment history, you'll notice he mentions Snowflake at every single opportunity. Snowflake raised $450M last October (~$1B valuation), so they have a nice warchest for strategic acquisitions.

[1] https://techcrunch.com/2019/02/19/google-acquires-cloud-migr...

[2] https://technical.ly/philly/2018/11/07/stitch-acquired-by-ta...

Just 50 states would be easy. You're forgetting county and municipal/locality taxes. Or the varying due dates for each of those jurisdictions. Or whether or not your widget business creates a nexus in those states and requires you to register as a foreign entity. Or whether or not your specific widgets trigger a higher or lower taxation rate. Or that whether or not shipping should be taxed also varies state to state. Or...

It's a whole lot of work to be legally compliant.

For us, it was due to the relatively high PUT cost if you're storing a large number of small files. We ended up changing our approach and we now store blocks (~10MB archives) instead of individual files into S3. The S3 portion of our AWS bill was previously 50% PUT / 50% long-term storage charges. After the change, we managed to reduce the PUT aspect to nearly $0 and reduced our overall AWS bill by almost 30%, while still storing the same amount of data per month.

e.g. if you write 1 million 10KB files per day to S3, you're looking at $150/mo in PUT costs. If you instead write 1,000 10MB blocks, you're looking at $0.15/mo in PUT costs.

Due to S3's support of HTTP range requests, we can still request individual files without an intermediate layer (though our write layer did slightly increase in complexity) and our GET (and storage) costs are identical.

Never noticed any speed difference due to bucket size. S3 is generally slow anyway (250ms for a write isn't uncommon) but it scales very well and we use it for raw data storage that's not in our critical path, so the latency isn't a problem.

Edit Response: I've always used the partitioning conventions they suggest so not sure what sort of impact you encounter without.

It's not exactly what you're asking for, but we have a large bucket with billions of files (don't ever do this, it was a terrible idea) and we manage deletions via lifecycle rules. If your file naming convention and data retention policy permits it, far easier than calling delete with 1,000 keys at a time.

Also just a word of warning, if you do have a lot of files, and you're thinking "let's transition them to glacier", don't do it. The transfer cost from S3->Glacier is absolutely insane ($0.05 per 1,000 objects). I managed to generate $11k worth of charges doing a "small" test of 218M files and a lifecycle policy. Only use glacier for large individual files.

[1] https://docs.aws.amazon.com/AmazonS3/latest/user-guide/creat...

Sure we do, we have the laws of physics. HughesNet has geostationary satellites. They orbit at ~22,200 miles up. Assuming speed of light, it's going to take ~120ms per hop. There's a minimum of 4 hops (you -> satellite -> ground station -> satellite -> you), or 480ms.

And that's assuming perfect conditions and ignoring the rest of the normal latency encountered online. It's physically impossible to have a latency lower than ~480ms with geostationary satellites.

Renting from a coworking space (We've never used WeWork but have multiple others) is generally month-to-month with a one-page contract and I can pay with a credit card.

Getting an office lease is a huge process with a stack of contracts, pushy agents, ridiculously long leases, misleading prices, hidden costs, furnishing, and establishing all the necessary services. And if you're a small company, the owners are expected to personally financially guarantee the lease.

Apple has a lot of hardware design employees who need something to do.

The simulation runs on the server. The client side (browser/webgl) is a dumb client.

While the data is accurate, it's a bit misleading. Tesla started Model 3 deliveries to Europe in March from pre-orders that began three years ago. We're seeing the impact of these pre-orders all coming in at once and the number of vehicles registered last month is very anomalous.

In total there were 18,375 cars registered in March compared to 11,106 in February '19 and 14,401 in March '18. If you back out the Tesla Model 3 impact (-5,300), you're left with 13,075 vehicles registered last month.

[1] Data source: https://ofv.no/bilsalget/bilsalget-i-mars-2019-1

> There should be a name for this law by now

https://en.wikipedia.org/wiki/Golden_Rule

It's never been about price, it's about form factor. The iPhone 7 is 28% larger (HxW) than the iPhone SE. That's precisely why I've refused to upgrade to the later versions too: They're absurdly large.

If there some sort of language barrier because half of you in this sub-thread are talking about escalators and the other half elevators.

Curious, what features do you need that are missing? We use bitbucket but honestly I never log into the interface (because it does seem just like an unnecessary visualization of what I can see on the command line). It's mostly just a hosted backup for our repo.

So maybe I'm missing a ton of awesome features that github/gitlab provide?

> After payments, hosting, and risk—our only three costs of doing business

What is risk in this context and how is it quantified as a dollar amount? Is that an amount allocated for returns/chargebacks/fraud?

A significant portion of his compensation was via recurring Amazon.com stock grants (RSUs). By year 4+ most employees are looking at least 3 separate stock grants vesting every single year.

Had you bought $100,000 of $AMZN in 2010, it'd be worth $1.35M today (and $1.6M in September) which would go a long way toward evening things out in a similar manner.