#sqlx #serde #newtype

sqlx-pgrow-serde

serde-compatible newtype wrapper for sqlx::postgres::PgRow

6 releases

0.1.6 May 25, 2023
0.1.5 May 25, 2023
0.1.2 Mar 6, 2023

#766 in Database interfaces

Download history 51/week @ 2023-03-03 13/week @ 2023-03-10 10/week @ 2023-03-24 12/week @ 2023-03-31 9/week @ 2023-04-07 25/week @ 2023-04-14 74/week @ 2023-04-21 37/week @ 2023-04-28 35/week @ 2023-05-05 32/week @ 2023-05-12 75/week @ 2023-05-19 74/week @ 2023-05-26 56/week @ 2023-06-02

250 downloads per month

MIT license

14KB
228 lines

sqlx-pgrow-serde

Check lib.rs for tests, which should give you a clear idea how to use the crate.

async fn main() {
    let row: PgRow = conn.fetch_one("select 3.3").await.unwrap();
    // option 1 - use function calls
    let headers: Vec<String> = read_headers(&row);
    let row: Vec<serde_json::Value> = read_row(&row);
    // option 2 - serializes as a header -> value map
    let row = SerMapPgRow::from(row);
    let row: serde_json::Value = serde_json::to_value(&row).unwrap();
    // option 3 - serializes as a serde_json::Array
    let row = SerVecPgRow::from(row);
    let row: serde_json::Value = serde_json::to_value(&row).unwrap();
}

Look at the SerMapPgRow and SerVecPgRow structs if you want to use #[serialize_with(...)] on your structs.

Dependencies

~9–45MB
~809K SLoC