I've been working on a JS database to support optimistic concurrency control. I did some research and arrived on 2 seemingly related concepts but from independent research lines. Software transactional memory in functional programming/Haskell land versus snapshot isolation in database research.
After reading them both, I asked this unanswered question on SO: https://stackoverflow.com/q/72084071/582917. My theory is that STM is the same as SI, but most SI database implementations don't just do value comparisons, but actually check a logical timestamp. This is probably done for performance reasons as databases handle larger pieces of data than functions would when using STM.
Along the way I also discovered SSI serializable snapshot isolation but it isn't yet available in rocksdb but cockroachdb apparently has a fork of rocksdb with it but I couldn't find it.
Anyway the db library which wraps around rocksdb is available to be used embedded in any nodejs program at https://github.com/MatrixAI/js-db.
Containers for STM
I think you are right about STM being roughly equivalent to snapshot isolation.
What STM offers is an easy way to invent "containers for snapshotted values" aka TVars. Using them carefully may result in better scaling: https://hackage.haskell.org/package/stm-containers
Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.
High performance Transactional Memory for Common Lisp
Common Lisp has it too, via https://stmx.org/ I believe it supports the Intel TSX stuff if present and falls back to a software implementation if not present.
Concurrent algorithms in Haskell using software transactional memory (STM monad)
I have a repo with six sample algorithms of increasing complexity: https://github.com/jasonincanada/stm-haskell
How to achieve "Run at most one parallel async action per user"?
1 project | reddit.com/r/haskell | 9 Nov 2021
ZIO Flow RC 1 release
1 project | news.ycombinator.com | 2 Dec 2022
asynchrony: asyncio Python framework for writing safe and fast concurrent code
1 project | reddit.com/r/coolgithubprojects | 30 Nov 2022
I wrote my own “proper” programming language
1 project | news.ycombinator.com | 29 Nov 2022
Falsehoods programmers believe about undefined behavior
1 project | reddit.com/r/C_Programming | 28 Nov 2022