I am working on a registration form for users.
Users can sign up to attend some sport events and are automatically
assigned a starting number depending on the users type.
There are several types of users and all have a specific range of
starting numbers.
0001 - 0050: not automatically assigend
0051 - 0600: type 1
0601 - 0650: type 2
1000 - 1300: type 3
…
What would be the best practice, to assign these values to a user and
increment the right counter?
Storing these values in a database table might be a little tricky.
I also could save the configuration in a yaml file, load it from there
and write it back. But what about multiple reads and writes at the
same time. Can this be handled by a message queue, which ensures that
the file (or database table) is sequentially accessed?
Thanks for any comment!