News for hackers. Stuff that matters.
Re:The database I wish I had by roenxi on Tuesday September 01, 2020 @04:56AM (#24339762)
> Immutability is an interesting property, but reality is messy.

Words have fuzzy boundaries - immutable obviously doesn't mean actually immutable. It means immutable like how git is immutable - you're not meant to change history. It'll fight like a tiger to stop you easily changing history. It'll give you two different ways to get what you want while preserving history. But if you want to change history you can.

SQL is said to be declarative but if you get hit dealing with the wrong sort of workload in SQL then the implementation details can start to matter extremely quickly.

In practice, the author probably only means 'much more immutable' rather than 'illegal to use with European data' level immutability.

Re:The database I wish I had by juped on Tuesday September 01, 2020 @05:55AM (#24340042)
Git's primary advantage over other VCS is how it makes it trivially easy to change history, though.
Re:The database I wish I had by andriosr on Tuesday September 01, 2020 @07:34AM (#24340659)
True. And what makes it easy is it's immutability. When you change history in Git, you rewrite it (rebase). But re-writing is only possible if you know every bit of the journey up to now. When you have actual updates, history is lost.
Re:The database I wish I had by afiori on Tuesday September 01, 2020 @08:21AM (#24340992)
the way git changes history is a stretch on the word change, rebasing creates a parallel history and then promotes it to be the true one. the reflog still remembers the previous history.