This is the first time I use SQLite in Unity3d as a configuration table file, of course, SQLite has excellent read and write performance.
If the project is stable, I will keep using it.
Android Platform:
1, download libsqlite3.so to assets-plugins-android below
2, find Mono.Data.Sqlite.dll in the Unity directory, so you can read the database file on Android real machine
Pc-mac-ios Platform:
1, find the Mono.data.sqlite.dll,sqlite3.dll two DLL files in the Unity directory
Main:
Mono.Data.Sqlite.dll
Sqlite3.dll
Must match the mono version you are currently developing
The principle of using SQLite on Android is:
Use Mono.Data.Sqlite.dll as a link to use Sqlite functionality in C #,
Then libsqlite3.so for Sqlite3 C-compiled NDK files that can be read in Android phones loaded
The Android system comes with the SQLite feature, which can be used to communicate with Android SRC directly through C # to achieve data storage.
If it is unity64, use the 64-bit sqlite3.dll, if it is 32 unity, use the 32-bit Sqlite3.dll
Specific to the official download of Sqlite3:
Http://www.sqlite.org/download.html
Unity3d read Sqlite3 database on various platforms