This pull request completes the migration of the project’s database infrastructure to Room 3, enabling full Kotlin Multiplatform (KMP) support for Android, Desktop, and iOS. It also documents and archives two major code extraction tracks: moving DatabaseManager and RadioInterfaceService logic into commonMain for true multiplatform parity. Key changes include updating dependencies and build logic, refactoring tests, and adding detailed documentation and implementation plans for these architectural improvements.

Room 3 Migration and KMP Database Modernization

• Updated all Room-related imports and usages from androidx.room to androidx.room3 throughout the codebase, including test files, to support Room 3 and KMP features. [1] [2] [3] [4] [5]
• Refined Gradle build logic in AndroidRoomConventionPlugin.kt to use the new Room 3 plugin and best practices, ensuring compatibility with multiplatform targets.
• Added new dependencies (androidx.datastore.preferences, okio) to core/database/build.gradle.kts for multiplatform file and preferences management.

Documentation and Track Archiving

• Added comprehensive documentation for the "Extract DatabaseManager to KMP" and "Extract RadioInterfaceService to KMP" tracks, including specifications, implementation plans, metadata, and context. These documents outline the requirements, phases, and acceptance criteria for moving critical logic into commonMain and achieving platform parity. [1] [2] [3] [4] [5] [6] [7] [8]
• Created and documented a new track for the Room 3 migration, detailing the migration plan, specification, and metadata for future reference. [1] [2] [3] [4]

Project and Tech Stack Updates

• Updated project and tech stack documentation to reflect the adoption of Room 3 KMP and the bundled SQLite driver, clarifying the new architecture and supported platforms. [1] [2] [3]

Summary of Most Important Changes

Room 3 Migration (KMP Support)

• Migrated all Room dependencies, imports, and usages to Room 3 (androidx.room3), enabling multiplatform database support and consistent behavior across Android, Desktop, and iOS. [1] [2] [3] [4] [5]
• Updated Gradle build logic and dependencies for Room 3 and multiplatform file/datastore management. [1] [2]

Track Documentation and Architecture Improvements

• Added detailed documentation and plans for extracting DatabaseManager and RadioInterfaceService logic to commonMain, ensuring feature parity and unified architecture across all targets. [1] [2] [3] [4] [5] [6] [7] [8]
• Documented the Room 3 migration process, including specification, plan, and metadata for future maintainability. [1] [2] [3] [4]

Project Documentation

• Updated architecture and tech stack docs to reflect the move to Room 3 KMP and the use of the bundled SQLite driver, clarifying the multiplatform approach. [1] [2] [3]