Beta Development Updates - Tauri Migration

[LuqP2]

I'm creating this discussion to keep track of major updates and changes during this transition period, since things are moving around quite a bit and it's getting messy to track everything through individual issues.

Current Status: Migrating to Tauri
I've started a significant architectural change by moving the entire backend from Electron to Tauri. This is happening in a private repository to avoid cluttering the main repo with experimental code and broken commits while I work things out.

Why the migration:
The IndexedDB caching system we were using had fundamental limitations that kept causing problems no matter how many patches I applied. Cache would get lost between sessions, indexing was slow and single-threaded, and the whole system felt fragile. Instead of keep applying band-aids, I decided to rebuild it properly.

What's changing:
The new setup uses SQLite for persistent caching and Rust for the backend. This brings some major improvements: indexing will be 4x to 16x faster thanks to parallel processing across all CPU cores, the app binary will be around 30x smaller (from 100-150MB down to 3-5MB), memory usage will drop significantly, and startup time will be much quicker. Most importantly, the cache will actually survive between sessions, so you won't need to reindex your entire library every time you open the app.
The frontend stays mostly the same, it's just the underlying plumbing that's being replaced.

Current progress:
Backend implementation is done and compiling. Right now I'm working through some path handling issues in the frontend integration. Once those are sorted out, I'll have a testable build ready.

What this means for testing:
When the Tauri version is ready for testing, you'll need to do a fresh install since the old Electron caches won't carry over. But after that initial setup, the experience should be much smoother and more reliable.

I'll update this discussion as things progress. If you have questions or want to know specifics about what's being worked on, feel free to ask here.

Thanks for your patience while I work through this transition.