Cannot find SQLite native functions on WebGL (Unity 2020.3.42f1)

jet-zhao commented 1 week ago

I can make a WebGL build successfully. But when it start running, it reports the error showed below:

The "libgilzoide-sqlite-net.bc" file under Plugins/lib/webgl/ has been checked default for WebGL platform. I don't know how to fix this issue. Could you help? Thanks a lot.

gilzoide commented 5 days ago

Hey @jet-zhao, thanks for the report! I haven't seen this error while testing, weird stuff.

When I run nm Plugins/lib/webgl/libgilzoide-sqlite-net.bc | grep sqlite3_, I can find all symbols that your error message say are missing, like "sqlite3_libversion_number", "sqlite3_open_v2", "sqlite3_prepare_v2" and so forth.

The "libgilzoide-sqlite-net.bc" file under Plugins/lib/webgl/ has been checked default for WebGL platform

Yes, that's the native plugin for the WebGL platform. I've tested web builds here on Unity 2022.3 and have no problems. Which version of Unity are you using? Although I don't think that the version of Unity is the real issue here... But maybe it is? I know that since 2021.2, static libraries (.a files) are recommended over LLVM bitcode (.bc files).

jet-zhao commented 4 days ago

Hey @jet-zhao, thanks for the report! I haven't seen this error while testing, weird stuff.

When I run nm Plugins/lib/webgl/libgilzoide-sqlite-net.bc | grep sqlite3_, I can find all symbols that your error message say are missing, like "sqlite3_libversion_number", "sqlite3_open_v2", "sqlite3_prepare_v2" and so forth.

The "libgilzoide-sqlite-net.bc" file under Plugins/lib/webgl/ has been checked default for WebGL platform

Yes, that's the native plugin for the WebGL platform. I've tested web builds here on Unity 2022.3 and have no problems. Which version of Unity are you using? Although I don't think that the version of Unity is the real issue here... But maybe it is? I know that since 2021.2, static libraries (.a files) are recommended over LLVM bitcode (.bc files).

Hi, thanks for your reply. I found the reason. By default, the three files lied in Plugins/sqlite-amalgamation/ are not selected for any platforms. Check the right platform and the issue is fixed.

gilzoide commented 4 days ago

the three files lied in Plugins/sqlite-amalgamation/ are not selected for any platforms

Actually, they are selected but only for the Apple platforms iOS/tvOS/visionOS. It works if you mark them for WebGL, but one cannot specify compile flags on Unity directly for them in the import settings, like it is possible on Apple platforms. That's why I prebuilt it in a .bc file instead, to be able to use a custom build of SQLite with extensions such as FTS5 and RTree enabled.

What Unity should be doing is linking your build to the libgilzoide-sqlite-net.bc file, which contains all native code for SQLite.

Say, what version of Unity are you using?

tealcwu commented 2 days ago

Hi gilzoide,

When I build and run WebGL build, it reports disk IO exception as below: "SQLiteException: disk I/O error at SQLite.SQLite3.Prepare2 (System.IntPtr db, System.String query) [0x00000] in <00000000000000000000000000000000>:0 "

I'm not sure if it's the similar issue with jet reported. I just testing WebGL with the demo in the readme to show player info in texts. But it failes now.

The Unity version I'm using is 2022.1.20f1. And I have selected the 3 files in Plugins/sqlite-amalgamation for WebGL platform.

Would you kind to give me some tips on this problem? Thanks!

tealcwu commented 2 days ago

jet-zhao commented 2 days ago

the three files lied in Plugins/sqlite-amalgamation/ are not selected for any platforms

Actually, they are selected but only for the Apple platforms iOS/tvOS/visionOS. It works if you mark them for WebGL, but one cannot specify compile flags on Unity directly for them in the import settings, like it is possible on Apple platforms. That's why I prebuilt it in a .bc file instead, to be able to use a custom build of SQLite with extensions such as FTS5 and RTree enabled.

What Unity should be doing is linking your build to the libgilzoide-sqlite-net.bc file, which contains all native code for SQLite.

Say, what version of Unity are you using?

Hey, it's 2020.3.42f1

gilzoide commented 15 hours ago

Hey @tealcwu. Would you mind creating a new issue for your problem? Even though they are both "runtime issues", they are not the same problem. I'll rename this issue to make it more specific.

tealcwu commented 15 hours ago

@gilzoide hi gil, just created issue#26.

gilzoide commented 15 hours ago

Hey, it's 2020.3.42f1

Ok, thanks for the info. I didn't test Unity 2020, only 2021.3+

I had some problems regarding emscripten version when trying to prebuild native plugins, it's quite likely that the problem is emscripten version incompatibility: I built this one with emscripten 2 provided by Unity 2021 and it cannot link in Unity 2020, which uses emscripten 1.38 (link from Unity docs). Now, when you mark sqlite3.c for building in Unity 2020, it works because emscripten can link it properly with your code. If this is the case, I'd expect some error log to occur during your build 🤔 Or maybe it uses different symbol naming, idk.

I'll try building with emscripten 1.X and will be back.

gilzoide commented 15 hours ago

Hey @jet-zhao , I was able to compile libgilzoide-sqlite-net.bc using Emscripten 1.40.1, it will likely link correctly in Unity 2020.3 now. Could you please test the version in branch support-emscripten-1 and see if it works for you?

gilzoide / unity-sqlite-net

Cannot find SQLite native functions on WebGL (Unity 2020.3.42f1) #25