Readit News logoReadit News
tybit commented on Knowing where your engineer salary comes from   seangoedecke.com/where-th... · Posted by u/mooreds
tybit · 5 months ago
> At successful tech companies, engineering work is valued in proportion to how much money it makes the company

If you look at what it actually takes to get promoted at most tech companies I’d say this isn’t generally true at many big tech companies.

Being on a very lucrative part of the product may not get you as much “impact” on your promotion packet as if you are working on a platform/infra touching the whole org. Even if that platform isn’t generating the company much money even indirectly.

tybit commented on DELETEs Are Difficult   notso.boringsql.com/posts... · Posted by u/radimm
redox99 · 9 months ago
I think garbage collection memory management can be thought of a delete optimized database.
tybit · 9 months ago
Runtimes with garbage collectors typically optimize for allocation, not deletion.
tybit commented on PostgreSQL internals: Things to know about update statements   patrick.engineering/posts... · Posted by u/ppati000
GauntletWizard · 2 years ago
I don't disagree, but it's so uncommonly used, and I don't know any orm that will do it for you- it'd be easy enough to precompile, but that'd require compiler integration. (Or a hit to every select statement - which probably wouldn't matter for most apps!)
tybit commented on The growing pains of database architecture   figma.com/blog/how-figma-... · Posted by u/kiyanwang
tmikaeld · 2 years ago
Why not distributed databases like CockroachDB?
tybit · 2 years ago
CockroachDB is presumably what they’re referring to in:

> For Postgres-compatible NewSQL, we would’ve had one of the largest single-cluster footprints for cloud-managed distributed Postgres. We didn’t want to bear the burden of being the first customer to hit certain scaling issues

I find their claim a bit hard to believe.

tybit commented on Information about a recent security incident at Mailchimp   mailchimp.com/january-202... · Posted by u/guiambros
tybit · 3 years ago
While they don’t specify it sounds like they don’t even require 2FA to access their systems?
tybit commented on API Mismatch: Why bolting SQL onto noSQL is a bad idea   chrisarmstrong.dev/posts/... · Posted by u/chris_armstrong
tybit · 3 years ago
Tangential to the authors point, but it’s funny to note many new SQL databases(e.g CockroachDB, TiDB, MyRocks) are written on top of RocksDB, a “NoSQL” key value store.
tybit commented on Cache invalidation really is one of the hardest problems in computer science   surfingcomplexity.blog/20... · Posted by u/azhenley
PaulHoule · 3 years ago
It's the other way around.

90% of the cases are easy cases, where thinking too hard about invalidation (as opposed to testing what works) is likely to give you worse performance.

There are a rare set of cases that are devilishly hard such as synchronizing the caches across an SMP microprocessor or making a system like Cloudflare really speed up your web site as opposed to slowing it down.

tybit · 3 years ago
When it comes to cache invalidation worse performance isn’t the primary concern in most cases, correctness is.
tybit commented on My Overemployment Story   overemployee.blog/my-over... · Posted by u/thunderbong
WorkerBee28474 · 3 years ago
I think there's an interesting social conflict in these stories.

A state wants to maximize the output of its working population. More output, more taxes, more power. A company wants to capture all of the produced value of the employee's time and labor.

So, if an employee is underutilized, the state should want them to get another job and produce more, while the company would prefer they sit around and do nothing because they might get bored and produce something for the company's benefit.

Who will win?

tybit · 3 years ago
It’s usually a safe bet that the state will preference companies over both employees and taxation unfortunately.
tybit commented on I'm all-in on server-side SQLite   fly.io/blog/all-in-on-sql... · Posted by u/dpeck
tybit · 3 years ago
I think this architecture would be really powerful paired with the actor model to shard databases to nodes.
tybit commented on Some discouraging anecdotes on how services handle account deletions   ctrl.blog/entry/account-d... · Posted by u/nathan_phoenix
andrei_says_ · 3 years ago
How does the law relate to backups? What about reports run in the past and possibly saved on someone’s local drive?
tybit · 3 years ago
At big tech companies I’ve seen and heard about, the answer is crypto shredding. Encrypt all PII at rest with a per user data key. GDPR deletion requests can then delete the data key. This isn’t perfect, but it’s a step in the right direction IMO. Unfortunately I don’t see it being feasible for a typical company anytime soon.

u/tybit

KarmaCake day786November 7, 2016View Original