Does anybody have any thoughts on something that scales better than a database lock?
We've got leagues which have a maximum number of entries. So we lock them while adding an entry to not exceed the limit.
But when there's lots of people trying to enter them, it's not an efficient approach. But what else would you do 🤔
#django #python
markwalker /
npub1nc…9ahkz
2024-07-30 17:29:37
Author Public Key
npub1nc2rftn5z7tvwwz9unrmyuk80q4qpw5je7l33c3qsq8kf035z5aqn9ahkzPublished at
2024-07-30 17:29:37Event JSON
{
"id": "df5e07e92f6725865f03db465cf92d364d66c302d2bdb0fe0031b086456c8a73",
"pubkey": "9e1434ae741796c73845e4c7b272c7782a00ba92cfbf18e220800f64be34153a",
"created_at": 1722360577,
"kind": 1,
"tags": [
[
"t",
"django"
],
[
"t",
"python"
],
[
"proxy",
"https://fosstodon.org/users/markwalker/statuses/112876622793613467",
"activitypub"
]
],
"content": "Does anybody have any thoughts on something that scales better than a database lock?\n\nWe've got leagues which have a maximum number of entries. So we lock them while adding an entry to not exceed the limit.\n\nBut when there's lots of people trying to enter them, it's not an efficient approach. But what else would you do 🤔 \n\n#django #python",
"sig": "830517e7e553e8cf3a65db3fb63b58c4728e29f9d649b94c9348c3f190f893a941fcdbbe27ee60660d8347ef0b689e9c6283580bf2ec262be225080e143193c3"
}