Alpi
Joined 12 years ago
Karma
48
Submissions
16
Member since
Feb 26
Recent submissions
Comment · 2 days ago
Celebrating the 25th anniversary of the original Civilisation 3 - the community releases the new version of OpenCiv3. Now you can finally win the game :)
Comment · 1 year ago
Anybody has experience using rasdr4? What is it capable of?
Comment · 2 years ago
What’s up with Index in January 2023?
Comment · 3 years ago
For update actually does block concurrent SELECT FOR UPDATES, so the article is correct
Comment · 3 years ago
FOR UPDATE locks the row for other blocking transactions (including another select for update)
The weaker form that only locks updates and deletes is called FOR SHARE.
Transaction isolation levels do not make a difference here.
https://www.postgresql.org/docs/current/explicit-locking.htm...
So the article is correct that SELECT FOR UPDATE will ensure that another concurrent SELECT FOR UPDATE transaction never acquire the same row (it will block), though nothing prevents other non-blocking selects to query this row concurrently.
You can think of it as usual locks - only the threads that explicitly use the same lock have the mutual exclusion guarantees. If there’s another thread that does not acquire the lock and tries to access the critical section - it will be able to do so.
Comment · 3 years ago
Actually I can relate to those misconceptions as a person who enjoys popular science.
I like articles like this since they hopefully help me to fine tune my intuition.
Comment · 3 years ago
After using several bank clients in different countries I can confidently say that some banks just have bad UI, and other banks are just good enough.
I don't think human language is simpler than good simple interface, though it can shine as a guide or navigator.
Comment · 3 years ago
I love all the series about writing your own X in 100 lines of code.
It gives you the understanding of technology and removes a lot of unnecessary details.
The great examples of this are 'A from-scratch tour of Bitcoin in Python' https://karpathy.github.io/2021/06/21/blockchain/ and 'Let's build GPT: from scratch, in code, spelled out' https://youtu.be/kCc8FmEb1nY from Andrej Karpathy
I wonder if anybody tried to collect all such projects together and built his own 'Internet in just 100 lines of code'
Comment · 3 years ago
I'm Santa, not Satan!
Comment · 3 years ago
- Russian-Ukraine war loses its momentum on the eastern front, hot war continues.
- Azerbaijan is launching full-scale invasion to Nagorno-Karabakh, taking it over in a Blitzkrieg with the support of Turkey.
- Russia is forcing Armenia to join Russian Union State, massive protests in Yerevan.
- Pro-Russian government is replacing Belorus president who is forced to resign, massibe protests in Minsk.
- China is preparing for a full scale invasion to Taiwan in 2024.
- Crypto industry crumbles into dust under heavy regulation.
- Meta is stepping back from the Metaverse, moving this research to a separate entity. Meta stocks are all-time low.
- First AI-generated celebrities.
Comment · 3 years ago
Ok you got me, I feel nostalgic.
What strikes me most is that those people from 90th were putting their creativity into something only handful of people will ever see, they were effectively shouting to void.
I would love to be still able to discover low-ranging websites like this. I remember somebody shared some alternative search engine?
Comment · 3 years ago
Why?
Is he trying to make the company profitable by keeping the traffic within it?
But how many people will be freaked out instead?
Comment · 4 years ago
Oh I found a golden card from Magic the Gathering
Comment · 11 years ago
cmikec, how many operators do you have by now?
and how many customers?