Write an interaction interface with SQLite base for a game for Unity
Budget: $10 – $30 USD
Need to create classes which are implementing the functionality of data recovery requests from the database.
Classes should implement the strategy pattern (the developer needs to describe what the strategy to implement) because the received data will be combined into different user data types.
For example "select * from words" should be written to type Words : IQueryable
There is no need to write requests, it will be on our side, but it is necessary to provide a place of storage of such requests in a structured format. Ideally, query files should be located in any specified folder and distributed to ".sql" format files, and the module itself had an initialized interface to access these files (resourses or settings, depending on how it is implemented by best practices)
The solution must match open-closed principle.
The database is based on SQLite, we suggest using the Mono.Data.Sqlite library to implement the interaction, but if there is another option which is better for objective reasons, you can use it.
Classes should implement the strategy pattern (the developer needs to describe what the strategy to implement) because the received data will be combined into different user data types.
For example "select * from words" should be written to type Words : IQueryable
There is no need to write requests, it will be on our side, but it is necessary to provide a place of storage of such requests in a structured format. Ideally, query files should be located in any specified folder and distributed to ".sql" format files, and the module itself had an initialized interface to access these files (resourses or settings, depending on how it is implemented by best practices)
The solution must match open-closed principle.
The database is based on SQLite, we suggest using the Mono.Data.Sqlite library to implement the interaction, but if there is another option which is better for objective reasons, you can use it.