SqliteRow doesn't implement Debug

Question

Using rust sqlx sqlx = { version = "0.8.6", features = ["sqlite", "runtime-tokio", "macros"] } . I am using a SQLite Db for my application. After making a db connection pool and performing a query , when i try to print the result of the query i am unable to do so.

Code :-

 let db_url = crate::utils::env::db_url();
 let pool = sqlx::sqlite::SqlitePoolOptions::new()
        .max_connections(5)
        .connect(&db_url)
        .await
        .expect("db connection error");

 let rows = sqlx::query(query_string)
    .bind(&id) 
    .fetch_all(&pool)
    .await
    .expect("db query error");

 println!("Query result - {:#?}", rows); //error is shown here

Error :-

SqliteRow` doesn't implement `Debug`
the trait `Debug` is not implemented for `SqliteRow`
the trait `Debug` is implemented for `Vec<T, A>

user2722968 · Accepted Answer · 2025-07-16 07:40:18Z

0

Short answer: As of version 0.8.6, SqliteRow simply does not implement Debug, and there is nothing one can do about that within 0.8.6.

It seems a std::fmt::Debug implementation found its way into sqlx very recently, but as of today that feature seems unreleased.

answered Jul 16 at 7:40

user2722968

17.3k5 gold badges58 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhith Shaji · Accepted Answer · 2025-07-16 09:02:00Z

0

This happens because SqliteRow does not implement Debug , so unable to display using println!() .
We need to extract the fields from each row manually and then print, this can be done using a for loop :

use sqlx::Row; //also add this

//....prevoius code---//
 let rows = sqlx::query(query_string)
    .bind(&id) 
    .fetch_all(&pool)
    .await
    .expect("db query error");

// loop through rows and print values
for row in rows {
    let name: String = row.get("name");
    let id: String = row.get("id");

    println!(
        "Name: {}, ID: {}",
        name, id
    );
}

edited Jul 16 at 9:02

answered Jul 16 at 7:37

Abhith Shaji

7648 silver badges21 bronze badges

Collectives™ on Stack Overflow

SqliteRow doesn't implement Debug

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related