What local databases have you worked with?

• SQLite: A basic local database in Android. Suitable for small data volumes and simple queries.
• Room: Provides an abstraction layer over SQLite, simplifying database work using annotations and DAO (Data Access Objects). Reduces boilerplate code and improves readability.
• Realm: A mobile database optimized for working with objects. It offers high performance but requires using its own data types.
• ObjectBox: Another object-oriented database focused on high performance and ease of use. Works with regular Kotlin/Java objects without the need to inherit from special classes.

The choice depends on the project: Room is preferred for standard tasks with integration with Architecture Components, Realm and ObjectBox are good when maximum performance and direct object handling are required.