#postgresql #timezone #tz #chrono #chrono-tz

chrono-tz-postgres

Typed timezones in Rust and PostgreSQL

5 releases

0.8.1 Dec 2, 2022
0.1.3 Nov 8, 2022
0.1.2 Nov 3, 2022
0.1.1 Nov 1, 2022
0.1.0 Nov 1, 2022

#383 in Date and time

MIT license

140KB
3K SLoC

Rust 2.5K SLoC SQL 598 SLoC

chrono-tz-postgres

crates.io Released API docs msrv 1.60

A timezone type that can be converted to and from a custom Postgres type. This allows you to use typed timezones in PostgreSQL.

The custom Postgres enum tz is equivalent to the Rust enum chrono_tz::Tz. It can be found here.

The version number mirrors chrono-tz.

chrono-tz-postgres in action

use chrono_tz::Tz;
use chrono_tz_postgres::TzPg;
use postgres::{Client, NoTls};

fn main() -> Result<(), Box<dyn std::error::Error>> {
    // We can convert between Tz and TzPg
    let tz = Tz::Arctic__Longyearbyen;
    let tzpg = TzPg::from(tz);
    let tz: Tz = tzpg.into();
    println!("{}", tz);

    // Tz can be serialized, unlike TzPg
    serde_json::to_string(&tz)?;

    // but TzPg can interface with Postgres
    let mut client = Client::connect("host=localhost user=postgres", NoTls)?;

    // timezone the column name, whose type is `tz`
    // `tz` is a custom Postgres type
    let row = client.query_one("SELECT timezone FROM foo LIMIT 1", &[])?;
    let tz: TzPg = row.get(0);

    // Convert back to Tz to do more
    let tz: Tz = tz.into();
    println!("{}", tz);

    Ok(())
}

Dependencies

~4.5–6MB
~131K SLoC