#json #diesel #jsonb

diesel_json

Json wrapper type for JsonB data handling in diesel

4 releases

0.2.1 Jul 5, 2023
0.2.0 Feb 4, 2023
0.1.1 Jan 18, 2021
0.1.0 Jan 17, 2021

#353 in Encoding

Download history 592/week @ 2023-12-06 518/week @ 2023-12-13 388/week @ 2023-12-20 351/week @ 2023-12-27 569/week @ 2024-01-03 611/week @ 2024-01-10 592/week @ 2024-01-17 585/week @ 2024-01-24 968/week @ 2024-01-31 568/week @ 2024-02-07 603/week @ 2024-02-14 657/week @ 2024-02-21 729/week @ 2024-02-28 615/week @ 2024-03-06 782/week @ 2024-03-13 549/week @ 2024-03-20

2,800 downloads per month
Used in 2 crates (via warg-server)

MIT license

9KB
107 lines

diesel_json

Provides a wrapper diesel_json::Json type that can be directly used to wrap serde serializable, deserializable structures and recognize them as queryable, insertable JsonB fields.

Getting started

Add diesel_json dependency to Cargo.toml.

  • Diesel 2.0 supported: diesel_json = "0.2"
  • Diesel 1.4 supported: diesel_json = "0.1"

Wrap data structures into diesel_json::Json type.

#[derive(Serialize, Deserialize, Debug)]
struct ComplexStruct {
  // ...
}

use diesel_json::Json;

#[derive(Serialize, Deserialize, Queryable, Insertable, AsChangeset, Identifiable)]
struct ExampleTable {
    // ...
    // Field that will be stored in Jsonb format
    jsonb_field: diesel_json::Json<ComplexStruct>,
    // Or simply as 
    jsonb_field2: Json<ComplexStruct>,
    // ...
}

Json type provides new function for object initialization, implements Deref, DerefMut, AsRef, AsMut and other traits that maps data access directly to underlying data.

See tests/postgresql.rs for example use.

Why should I use this library?

Without wrapper type for each unique type you store as JsonB field you would need to use serde_json::Value directly or implement your own implementation for following traits:

impl<T> FromSql<sql_types::JsonB, Pg> for Json<T> {}
impl<T> ToSql<sql_types::JsonB, Pg> for Json<T> {}

TODO:

  • Support not only JsonB, but also Json postgres type
  • Support more database drivers
    • PostgreSQL
    • MySql
    • SQLite
  • Improve testing of the library
    • Test insertion and retrieval of nullable/non-nullable JsonB postgresql fields.
    • Add support and test Json field insertion and retrieval
    • TODO(Expand): Add support for other database driver Json fields

Dependencies

~3.5MB
~72K SLoC