- Jul 2022
-
www.techemails.com www.techemails.com
-
The WhatsApp UI sucks, but they took the hit on UI to focus on reliable sending and fast growth. Those are arguably the features that win over users, not UI.
At the end, the top priority is solving problems for users.
-
The way I think about things, consider FB a giant fly-wheel.... You want the external edge to move very quickly and iteratively -- and small dings when you get things wrong don't cost much, but the deeper you go in the stack / towards the infrastructure core (and really the human capital core even below that), you want things to move more slowly and predictably.
This is an interesting analogy
-
-
brandur.org brandur.org
-
The major benefit of foreign keys is that they guarantee referential integrity. For example, say you have customers in one table that may refer to a number of invoices in another. Without foreign keys, you could delete a customer, but forget to remove its invoices, thereby leaving a bunch of orphaned invoices that reference an customer that’s gone.
Note that GH doesn't use FK (at least back in 2016) https://github.com/github/gh-ost/issues/331#issuecomment-266027731 due to: * MySQL doesn't support it on partitioned tables * Performance impact. * FKs don't work well with online schema migrations
From Postgres has foreign keys to be fully compatible with partitioned tables since 12. But still it's not that commonly used for larger DBs.
-
If an operator ever queries the database directly they’re even more likely to forget deleted_at because normally the ORM does the work for them.
This happens relatively often, especially for 1) engineers that run SQL queries directly against the DB for analysis or triaging production issues, and 2) data scientists that do not use the same programming language as the enginners
Tags
Annotators
URL
-
-
www.ycombinator.com www.ycombinator.com
-
Most Favored Nation (“MFN”) provision (the “MFN safe”)
...giving the company money now but at the terms you will negotiate with other investors later.
-
-
www.theartnewspaper.com www.theartnewspaper.com
-
“The idea makes sense, but perhaps the timing was bad,” says the art market economist and author Magnus Resch, who in June published the book How To Create And Sell NFTs. “Prohibitively high prices and a complicated entry into collecting are the biggest problems with NFTs. But by holding events and educating people you’re building trust.”
A lot of the crypto/web3 ideas focus on "exiting" the physical world status quo. However, being more inclusive seems to be a better way to help better adoption of web3.
Opening up physical galleries feels very expensive, though.
-