I've got a somewhat unusual use case that I'd appr...
# getting-started
d
I've got a somewhat unusual use case that I'd appreciate any input on. I've got an Android app storing data in SQLite using Android's Room persistence library, but for troubleshooting purposes, I have a system to export the database file so that I can look at it on my desktop and do analysis on the contents. Room is an Android-specific thing, so I can't reuse any of the Room data modelling for a pure JVM program running on the desktop. Ideally I'd really just like to run some basic SQL queries on the database without modifying it. Really just the type-safe equivalent of firing up the sqlite client and running some queries. Can I do that without too much effort if I use an ORM-focused library like SQLDelight or Ktorm, or would I have to model everything in the ORM to make that work? (There are also some migrations between versions, mostly in tables I'm not interested in, and I'd prefer to not have to create those if I can avoid it)