Database driven games

Setting up SQLite in Unity

//A little more involved than I thought

SQL Lite in the game engine

Games like Indy Pro ’22 are heavily database driven. That is why many developers of sports management simulations opt out of using game engines for their development and instead stick with windows forms applications. This allows them to package their database with the game as a separate file in things like MS Access, etc. However, SQLite provides us with all the tools we need, can be used cross platform and can be used directly in the engine. However, it takes a little work to set up.

Step 1

The first thing that has to be done is to get the SQLite files into the engine in the first place. This is probably the most difficult part of the process as you need to hunt the correct files. This walkthrough is using the files I needed but you may need others.

• In your assets folder create a folder called plugins.
• Go to SQLite Download Page and download your appropriate binaries. For my project I need the precompiled binaries' for windows 64 bit. Currently sqlite-dll-win64-x64–3360000.zip
• This zip file will contain a DLL file and a DEF file copy those into your newly created Plugins folder.
• Now we need to hunt down another file…