IssueTracker

Is there any hope that this will be looked at any time soon?
I find it pretty disappointing that there is no way to debug queries. I am using Room in an application with foreign key relationships, and these are failing silently and for some mysterious reason, and I have no way to debug my queries other than manually adding a bunch of LogCat logs.
Thank you for considering this.

Hello

Room database looks very promising and interesting, But I am still on initial stage of learning it and I am facing the problem of not being able to see log outputs of the database.
While implementing / learning debugging should be enabled.

It would be extremely helpful if we can have debugging logs for Room database implementation.

Thanks and regards
Abhiroop Nandi Ray

sorry, we are not agianst this feature but it is just not a high priority right now.
You can technically implement this outside room by providing your logging support sqlite open helper.

you can also consider sending a CL ? :)
https://android.googlesource.com/platform/frameworks/support/+/androidx-master-dev

I have been able to achieve it via a very hackie way
Please refer to
https://stackoverflow.com/questions/46172417/android-room-database-dao-debug-log/53693849#53693849 
or
https://gist.github.com/aasaandinesh/6e4cf206bd1bb56966954cabc42128dd

Will try to do it in a proper way

You can log Room's Sqlite queries on emulator, see: https://stackoverflow.com/a/54963655/1233652

This is needed for asserting query execution and increasing the speed of adoption of the framework. Please prioritize higher as simple as it is.

Please, it would be very helpful for developers to be able to debug room operations in an easy way.

Please, it would be very helpful for a more complicated erd, prioritize higher as soon as possible.

Project: platform/frameworks/support
Branch: androidx-master-dev

commit ab6d205c0217a0ed5c170bf6ceadb20422947699
Author: Elif Bilgin <elifbilgin@google.com>
Date:   Tue Nov 17 13:50:26 2020

    Implementing functionality for a general callback function for SQLite queries. If possible, bind arguments are provided to the callback in addition to the SQLite query statement. This callback may be used for logging executed queries, in which case it is recommended to use an immediate executor.
   
    This CL will be followed up by a CL resolving b/174478034.
   
    Test: Tests have been added QueryInterceptorTest.kt
   
    Relnote: Add query callback feature to Room.
   
    Bug: 74877608
    Change-Id: Iaa513e39115f0c9c68359774fa70e1d3dd022c39

A       room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/QueryInterceptorTest.kt
M       room/runtime/api/current.txt
M       room/runtime/api/public_plus_experimental_current.txt
M       room/runtime/api/restricted_current.txt
A       room/runtime/src/main/java/androidx/room/QueryInterceptorDatabase.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorOpenHelper.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorOpenHelperFactory.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorStatement.java
M       room/runtime/src/main/java/androidx/room/RoomDatabase.java

https://android-review.googlesource.com/1502194

Any updates on this?
It's very, very difficult and time-consuming to debug Room errors in big projects.

sorry we don't have anything here yet :/. it will be post-IO :(.

This fix will be available in 2.0.0 beta 2.

Fix went in early enough to get into 2.0.0-beta01, so marking released

https://drive.google.com/file/d/1xO0oED___xqD2hHoMkW_MLKTQ60UsEWUVA/view?usp=drive_web (Screenshot_20180615-010729.png)

https://drive.google.com/file/d/1s-JWOQQRGgL3nSWOSobgd3KgZCsJAvoj7g/view?usp=drive_web (Screenshot_2018-07-17-17-37-19.png)

The file links in #16 have restricted access. Are you still seeing the issue and are trying to show us through those screenshots?