#postgresql #sqlx #serde #wrapper #serialization #serde-json #pg-row

sqlx-pgrow-serde

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

7 releases

0.2.0 Jul 29, 2023
0.1.6 May 25, 2023
0.1.2 Mar 6, 2023

#1295 in Encoding

Download history 5/week @ 2024-02-26 12/week @ 2024-03-18 18/week @ 2024-03-25 11/week @ 2024-04-01 1/week @ 2024-04-22 18/week @ 2024-05-06 13/week @ 2024-05-13 61/week @ 2024-05-20 27/week @ 2024-05-27

119 downloads per month

MIT license

15KB
226 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

~11–27MB
~426K SLoC