03-18-2014, 01:41 AM
I'm still considering ways to add real SQL DB connectivity to MCServer without affecting the compilation setup burden. In the mini-research I have done, probably the best possible course of action would be to make MCServer depend on ODBC, then use the LuaSQL.ODBC library for the Lua bindings.
Could we pull this one off? There's a few points to consider:
- How easy is it to set up the development environment to have access to ODBC?
- How easy is it to set up LuaSQL.ODBC library to compile into MCS?
- Is ODBC supported on all platforms that MCS can compile on? (I'm looking at you, Android)
- Is ODBC enough to handle all the DB needs that the plugins may have?
- ...?
From what I've seen on my Windows boxes, ODBC support libraries / headers come installed directly with MSVC / Windows SDKs; there's no extra cost here. On *nix there's UnixODBC which should be available on most platforms using a simple pkg-mgr call. I've seen several online versions of FindODBC.cmake file that search for the ODBC libs / headers, so this should be possible pretty easily. Thoughts?
Could we pull this one off? There's a few points to consider:
- How easy is it to set up the development environment to have access to ODBC?
- How easy is it to set up LuaSQL.ODBC library to compile into MCS?
- Is ODBC supported on all platforms that MCS can compile on? (I'm looking at you, Android)
- Is ODBC enough to handle all the DB needs that the plugins may have?
- ...?
From what I've seen on my Windows boxes, ODBC support libraries / headers come installed directly with MSVC / Windows SDKs; there's no extra cost here. On *nix there's UnixODBC which should be available on most platforms using a simple pkg-mgr call. I've seen several online versions of FindODBC.cmake file that search for the ODBC libs / headers, so this should be possible pretty easily. Thoughts?