SQLite not working on android

[stackedCG]

Hi Tauri devs, I ran on some issues on which SQLite plugin breaks the android version of the app, this is a head scratcher to me since it works on desktop but not on android, I am not sure if I miss something on the documentation.

Here is the error that show up everytime I run it, also I am sure that its the SQL that crashes the app since everytime I remove it, the android app works properly again.

screenshot

[FabianLars]

it's not exactly the same error but can you try this? #7413 (comment)

[stackedCG]

Also it now tells me, that my NDK was not set. Is the NDK that were mentioned in the prerequisites a different one?

https://prnt.sc/jlspwyk-JI8X

[stackedCG]

Hi @FabianLars, just want to pull up this thread again.

[FabianLars]

no it should be the same. did you check if $env:NDK_HOME still prints the correct path in that terminal?

[stackedCG]

Yes I think its correctly connected, but here is the exact directory: https://prnt.sc/5MCqPBC318DF

[stackedCG]

Hi @FabianLars, just want to follow up this thread.

[BlackTiger007]

Regarding your screenshot — I didn’t have exactly the same error, but I ran into similar issues with the SQLite integration on Android. Like @FabianLars already pointed out, I was able to fix it with this workaround:
➡️ You can check out my main.rs here: https://github.com/Seenivers/App/blob/android/src-tauri/src/main.rs

Additionally, I created a small PowerShell script for setting up the Android environment variables. I run it once before building to make sure all paths are correctly set and up to date. Might be helpful for you as well to rule out any path-related issues:

Important: You’ll need to adjust the paths in the script to match your own Android Studio installation and SDK directory structure.
Just replace the paths like D:\Android Studio\jbr and D:\Android_Studio_Sdk with the ones you’re using on your system.

# Setup Android Studio Environment Variables

[System.Environment]::SetEnvironmentVariable("JAVA_HOME", "D:\Android Studio\jbr", "User")
[System.Environment]::SetEnvironmentVariable("ANDROID_HOME", "D:\Android_Studio_Sdk", "User")

# Set the NDK version dynamically, selecting the latest NDK folder
$VERSION = Get-ChildItem -Path "D:\Android_Studio_Sdk\ndk" | 
Sort-Object LastWriteTime -Descending | 
Select-Object -First 1

# Set the NDK_HOME to the latest NDK folder
[System.Environment]::SetEnvironmentVariable("NDK_HOME", "D:\Android_Studio_Sdk\ndk\$($VERSION.Name)", "User")

# Set variables for the current PowerShell session
$env:JAVA_HOME = "D:\Android Studio\jbr"
$env:ANDROID_HOME = "D:\Android_Studio_Sdk"
$env:NDK_HOME = "D:\Android_Studio_Sdk\ndk\$($VERSION.Name)"

# Output the variables
Write-Output "JAVA_HOME: $env:JAVA_HOME"
Write-Output "ANDROID_HOME: $env:ANDROID_HOME"
Write-Output "VERSION: $VERSION"
Write-Output "NDK_HOME: $env:NDK_HOME"

# Test the variables
Test-Path $env:JAVA_HOME
Test-Path $env:ANDROID_HOME
Test-Path $env:NDK_HOME

I also had some trouble with the SQLite plugin on Android before, and in my case, it was because I hadn’t properly registered the migrations with the plugin at first.
Once I made sure to integrate and register the migrations cleanly, everything started working without crashes.

You can check out my migration setup here:
➡️ https://github.com/Seenivers/App/blob/android/src-tauri/src/migrations.rs
(Note: The repo isn’t fully up to date right now, but that’s where I had the exact same issues I was struggling with before.)

Maybe this helps as a reference if your issue turns out to be related!