peterth3

> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use.

Sounds reasonable to me.

Thats a lot of work for GitHub: 1) Find a backup from before this change was made. 2) Restore backup on new db instance separate from prod. 3) Export star gazers list for this one repo to CSV or something. 4) Destroy instance restored from backup. 5) Execute admin script with CSV against production database to insert lost stargazers.

This gets even more complicated if GitHub has more than one central database, which I’d assume they have something like sharded mysql.

Considering that they made the change acknowledging that it would destroy their stargazer list in the confirmation dialog, it’s unfair for them to expect any help from Github’s support recovering that list.

Just seeing this…

> FP implies immutability and heavily shared structures

FP does imply immutability, but not sure what you mean by “heavily shared structures.”

If you’re referring to a type system like Haskell’s then that’s what I meant by “FP-adjacent.”

> Rust is very far from having anything to do with FP

This thread has a pretty deep rust vs haskell discussion: https://www.reddit.com/r/rust/comments/4jh8hv/question_about... Clearly, there are some similarities.

> You have to jump through some massive hoops to get the same benefits of shared data structures in Rust.

Again, not sure what you mean by “shared data structures.” Functional styles work well in rust. You could use only immutable variables with clone/copy sprinkled throughout and the borrow checker won’t complain.

I’d assume that Stripe isn’t trying to solve problems like this because of a lack of priority. Not because of a lack of ideas. A big company gearing up for a blockbuster IPO probably has many other problems to solve with higher priorities.

Definitely agree about the excess of complaining in this thread though. HN isn’t a good forum for discussions like this, but that’s probably more a social media problem than an HN problem.

Come here to say this, here’s a link to flyway if anyone is curious - https://github.com/flyway/flyway. Many ORMs come with migration systems. For example, SQLAlchemy’s migration tool is Alembic - https://github.com/sqlalchemy/alembic.

Discussion on /r/rust about this article:

https://www.reddit.com/r/rust/comments/qw3w01/backdooring_ru...

So, you’re claiming that pure FP languages need less dependencies than FP-adjacent languages like rust?

This is really interesting. Do you have a source to cite proving this claim?