Building a Database-Driven Virtual Game: Combining PostgreSQL and SQLite for Dynamic Game State Management DATA
chelik, melek (2024)
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2024101526462
https://urn.fi/URN:NBN:fi:amk-2024101526462
Tiivistelmä
The purpose of this thesis was to use PostgreSQL and SQLite to create a database-based game. The challenges of storing data persistently and handling real-time state changes in virtual games were demonstrated by this study. Additionally, a hybrid database solution utilizing both PostgreSQL and SQLite was suggested as a solution. An enhanced version of the database is called PostgreSQL. SQLite is successful because of its server and processing capabilities combined with a lightweight architecture.
An extensive database schema was created to enhance the game state to accomplish this goal. The schema design employed normalization techniques to guarantee data integrity and sustain the performance level. To guarantee continuous data flow and consistency between PostgreSQL and SQLite, a Notation Mechanism was put in place. Technical system integration is achieved by indexing query configuration and high connection simplicity.
The PostgreSQL and SQLite databases were created during the implementation phase. To handle real-time state changes, game state management was 3 created and integrated with the game engine. Subsequently, a synchronization module was put into place to guarantee smooth data synchronization between the client and server. Processes for troubleshooting and testing were developed to ensure system stability.
Performance tests and analyses were conducted to assess the system's efficiency, made possible by the hybrid database. When compared to a single database, considerable gains in reaction times and throughput were therefore seen. The system performed admirably and proved that it was appropriate for dynamic gaming scenarios. Data consistency and integrity were maintained throughout the testing stages, and the synchronization mechanism's effectiveness was demonstrated.
The primary conclusions demonstrated how well the hybrid strategy ad dressed the management issues in dynamic gaming scenarios and provided a workable solution for virtual games. In addition to improving speed, PostgreSQL and SQLite integration offers data security and integrity. By identifying a simple and useful method for managing game states in real time, this research provides solutions to the data management sector.
Consequently, the hybrid database system that this thesis proposes as a solution provides a reliable means of managing dynamic games. The effective outcomes of the hybrid database solution in boosting the performance and scalability of virtual games are revealed by the merging of PostgreSQL and SQLite. The synchronization mechanism will be the subject of future 4 research. It can also be refined and directed towards investigating a few other uses.
An extensive database schema was created to enhance the game state to accomplish this goal. The schema design employed normalization techniques to guarantee data integrity and sustain the performance level. To guarantee continuous data flow and consistency between PostgreSQL and SQLite, a Notation Mechanism was put in place. Technical system integration is achieved by indexing query configuration and high connection simplicity.
The PostgreSQL and SQLite databases were created during the implementation phase. To handle real-time state changes, game state management was 3 created and integrated with the game engine. Subsequently, a synchronization module was put into place to guarantee smooth data synchronization between the client and server. Processes for troubleshooting and testing were developed to ensure system stability.
Performance tests and analyses were conducted to assess the system's efficiency, made possible by the hybrid database. When compared to a single database, considerable gains in reaction times and throughput were therefore seen. The system performed admirably and proved that it was appropriate for dynamic gaming scenarios. Data consistency and integrity were maintained throughout the testing stages, and the synchronization mechanism's effectiveness was demonstrated.
The primary conclusions demonstrated how well the hybrid strategy ad dressed the management issues in dynamic gaming scenarios and provided a workable solution for virtual games. In addition to improving speed, PostgreSQL and SQLite integration offers data security and integrity. By identifying a simple and useful method for managing game states in real time, this research provides solutions to the data management sector.
Consequently, the hybrid database system that this thesis proposes as a solution provides a reliable means of managing dynamic games. The effective outcomes of the hybrid database solution in boosting the performance and scalability of virtual games are revealed by the merging of PostgreSQL and SQLite. The synchronization mechanism will be the subject of future 4 research. It can also be refined and directed towards investigating a few other uses.