Struct diesel::pg::types::sql_types::Jsonb

pub struct Jsonb;

The jsonb SQL type. This type can only be used with feature = "serde_json"

jsonb offers several advantages over regular JSON:

There are two JSON data types: json and jsonb. They accept almost identical sets of values as input. The major practical difference is one of efficiency. The json data type stores an exact copy of the input text, which processing functions must reparse on each execution; while jsonb data is stored in a decomposed binary format that makes it slightly slower to input due to added conversion overhead, but significantly faster to process, since no reparsing is needed. jsonb also supports indexing, which can be a significant advantage.

...In general, most applications should prefer to store JSON data as jsonb, unless there are quite specialized needs, such as legacy assumptions about ordering of object keys.

ToSql impls

• serde_json::Value

FromSql impls

• serde_json

Examples

extern crate serde_json;
#[derive(Queryable)]
struct Contact {
    id: i32,
    name: String,
    address: serde_json::Value,
}

#[derive(Insertable)]
#[table_name="contacts"]
struct NewContact {
    name: String,
    address: serde_json::Value,
}

table! {
    contacts {
        id -> Integer,
        name -> VarChar,
        address -> Jsonb,
    }
}

let santas_address: serde_json::Value = serde_json::from_str(r#"{
    "street": "Article Circle Expressway 1",
    "city": "North Pole",
    "postcode": "99705",
    "state": "Alaska"
}"#).unwrap();
let new_contact = NewContact {
    name: "Claus".into(),
    address: santas_address.clone()
};
let inserted_contact = insert(&new_contact).into(contacts)
    .get_result::<Contact>(&connection).unwrap();
assert_eq!(santas_address, inserted_contact.address);

Trait Implementations

impl QueryId for Jsonb

type QueryId = Self

fn has_static_query_id() -> bool

fn query_id() -> Option<TypeId>

impl NotNull for Jsonb

impl SingleValue for Jsonb

impl Debug for Jsonb

fn fmt(&self, __arg_0: &mut Formatter) -> Result

Formats the value using the given formatter.

impl Clone for Jsonb

fn clone(&self) -> Jsonb

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for Jsonb

impl Default for Jsonb

fn default() -> Jsonb

Returns the "default value" for a type.