1,606 karma · joined April 8, 2010
Portability. A C library can be trivially linked with any other language. But one will be hard pressed using a python library form Ruby, for example.
Plus you can have 10 servers for load sharing and users can hit any server at random and still expect the site to work perfectly.
The test driven development way
:echom test_null_list()
And it works. Just checked.
Well, it at least called itself "Earth's Biggest Bookstore" at that time.
I wonder how it's like working there now a days.
> November 17, 2019 19:33 UTC > [Resolved] We have resolved the issue that was affecting production certificate issuance. Service is restored.
Not necessarily. You lock the row for an instant update to a field, for example called "status" into "running" and then disconnect from the database within milliseconds. Finish your job taking as much time as you want. And then connect again to change the row's status to "finished".
This is how it's always designed, as I have seen. The locking problem is for querying rows where status="waiting" and then instantly change it.
It's not to "keep the record locked, and DB connection up, until I finish my batch job". That would be a bad design.
The notification system comes with a cost. You can't scale up the number of connection to a PG database instance.
Therefore you need to go pooling.
And for SKIP LOCKED, I just checked and mysql/maria do have it.
You have to restart without trying to get a boost using popular figure's name or photo.