Database design and implementation

RakNet ([login to view URL]) has a lobby system used for games. The lobby system allows users to socialize with each other performing actions such as creating clans, making friends, or sending messages to each other. The lobby system is intended to support up to several million simultaneous users. The database backend should support concurrent connections, and be performance optimized using techniques such as replication. The database implementation must be designed with these needs in mind. Tasks of the implementer: 1. Review the this document to gain an understanding of the purpose of the system as a whole, asking questions to clarify requirements. 2. Review each function to understand its intent, input parameters, output parameters, and effect on the database. Discuss with me elements that are incomplete or poorly thought out to ensure that the final implementation is high quality, efficient, and provides all necessary input and output data. 3. Design and implement the database that will provide an efficient and stable backend to the functions, with appropriate constraints and standard best practices 4. Implement each function ## Deliverables Brief: Using the latest officially stable version of PostgreSQL or MySQL, implement the functions described in this document. -------------------- Overview -------------------- RakNet ([login to view URL]) has a lobby system used for games. The lobby system allows users to socialize with each other performing actions such as creating clans, making friends, or sending messages to each other. The lobby system is intended to support up to several million simultaneous users. The database backend should support concurrent connections, and be performance optimized using techniques such as replication. The database implementation must be designed with these needs in mind. Tasks of the implementer: 1. Review the this document to gain an understanding of the purpose of the system as a whole, asking questions to clarify requirements. 2. Review each function to understand its intent, input parameters, output parameters, and effect on the database. Discuss with me elements that are incomplete or poorly thought out to ensure that the final implementation is high quality, efficient, and provides all necessary input and output data. 3. Design and implement the database that will provide an efficient and stable backend to the functions, with appropriate constraints and standard best practices 4. Implement each function While I have put forward a best effort to fully document each function, due to the large number of functions I expect questions to arise. Please ask questions rather than assume if at all in doubt. The sooner asked, the less time spent going down the wrong code path. The project should be submitted before the deadline so if there are bugs they can be fixed in time. In the past I have extended additional time to the coder to fix bugs due to last-minute submissions. I feel this is unfair and no longer plan to do so. Specify in your bid when you would be able to start, were the bid to be accepted. Bids which do not specify a start date will not be accepted. *** See attachment for function list and specific requirements *** *** Deliverables are due throughout the project ***