Just to update everyone: I'm currently working on making one big SQL library. It will have ODBC, SQLite, and MySQL all bundled together to work pretty much the same way. Each section will be contained in $IF blocks and you would toggle the appropriate library version by defining a specific precompiler variable. This would mean you would only be able to use one at a time which, realistically, should be all you need anyways. ODBC was super easy to code for as it is all WinAPI. SQLite was easy, but documentation was still lacking. MySQL is the most difficult one since everything comes down as arrays and memory blocks and the documentation is seriously lacking. You won't be able to bind parameters at release. I'll have to make up some functions to allow that so we can have binary data stored in databases. Right now, only basic text is allowed. This should be enough for the average person. Each library should be using prepared statements rather than direct execution as well. I'm currently very busy with work and purchasing a house but I hope to complete this and hope to provide a video showing how to set up your own MySQL server and connect via ODBC or the libmysql DLL.
