What do you do when you need a database engine for your game development and you are using the AGKSharp Toolkit???
For AppGameKit developers there appears to be support for the use of SQLite with a plugin... I found the following link for AppGameKit developers who may require storing their data in database system...
https://forum.thegamecreators.com/thread/219939
Whether you are an AppGameKit developer or an AGKSharp developer, at some point, if you develop a complex game system, you are going to require a database engine of some type. The SQLite Database Engine is an extremely powerful, embedded database system. However, working as I have with typed database engines for many years, I much prefer the typed aspects of such databases over that of SQLite.
If you are working with the AGKSharp Toolkit or plan to do so and will need the use of a database engine, you have two very powerful options at your disposal, if like me, you prefer to work with a typed database engine. Such options would be MySQL for large scale games that would be multi-player or Firebird, which can handle both large scale operations with the server edition as well as individual desktop games with the embedded version. However, getting access to these database engines require one of two options, an ORM framework, which in business development has become a rather popular option, or direct ADO access in the Microsoft .NET world.
As I have been a user of the Microsoft Visual Studio development environment since its commercial release in 2001, this is my preferred technology for development.
For Python and Java users, who can also take advantage of using the AppGameKit Engine with these development languages there are a variety of database options for the same databases just mentioned. However, not being such a developer, I am not familiar with the connection\access techniques from these languages, with the exception of Java's JDBC database access technology.
Nonetheless, if you are planning on using Visual Studio, than I can provide such developers with two ADO Data Access Layers, both of which are freely available and Open Source, for both the MySQL and Firebird database engines. They both come with complete source code and documentation as to how each can be used with many examples. In addition, a complete test-client is provided, which the code can be used for your own purposes.
You may download either of these ADO Data Access Layers from the following link on my own site...
https://blackfalconsoftware.com/software/
Since the .NET Framework has been updated several times since these components were released, you can easily recompile the solutions\projects to the framework version of your preference. In addition, you may also want to include the latest .NET Connector software available from either the Firebird or MySQL web sites...
Firebird...
https://firebirdsql.org/
MySQL...
https://www.mysql.com/
If you have any questions regarding either of these components, please feel free to leave them on this thread...
Steve Naidamast
Sr. Software Engineer