Rhynedahll
(Rhynedahll)
November 22, 2015, 6:13pm
33
People freak out because they want to use the Connector for C++ (cause they know, UE4 is C++ so they think they have to use it) and then run around like chicken. Thank god the MariaDB C++ Connector is LGPL and compatible with MySQL
Regarding the plugin, i started to develop this as a fun project and am thinking about extending it and put it on the marketplace. Though, a possible downside could be that i developed it as an ODBC interface (this way it doesnt matter which database you plug in at the backend and i dont have to care about Connection Pooling, etc).
If people are still interested into it despite the fact that its ODBC, some of the features that are already working:
Plain SQL Query Execution (Select/Update/Insert)
Queries return the result as an Array of Array of custom structs (Array of Rows -> Array of Columns -> Custom Struct that contains the value and column name)
Query that automatically fills an UObject that is given to the Blueprint Function; It checks if the name of a property matches the name of a result column and fills it then (works also with Vector, Vector2D, Rotator)
Planned Features:
Persist a given UObject into a table (matching property names with column names), automatically deciding if insert or update is neccessary
Prepared Statements through Blueprints
MAYBE some kind of building sql statements through blueprint nodes (if you know i.e. hiberate query language you know what i mean)
Would you guys be interested in that?
Cheers,
Since I am only now studying DB programming, I have no idea what your explanation means.
However, if your plugin makes connecting a multiplayer game to a database to maintain and update things like player names, inventories, high scores, etc, in a painless way, then by all means proceed!