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 UTC
Author Public Key
npub1nc2rftn5z7tvwwz9unrmyuk80q4qpw5je7l33c3qsq8kf035z5aqn9ahkzSeen on
wss://relay.ditto.pubPublished at
2024-07-30 17:29:37 UTCEvent 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"
}