postgres

Added

• Added support for jiff v0.2.
• Added support for bit-vec versions v0.7 and v0.8.

Changed

• Updated repository links to use rust-postgres organization.
• Upgraded to Rust 2021 edition.

Added

• Added support for direct TLS negotiation.
• Added support for cidr 0.3 via the with-cidr-0_3 feature.

Added

• Added support for jiff 0.1 via the with-jiff-01 feature.

Added

• Added {Client, Transaction, GenericClient}::query_typed.

Added

• Added support for the hostaddr config option to bypass DNS lookups.
• Added support for the load_balance_hosts config option to randomize connection ordering.
• The user config option now defaults to the executing process's user.

Added

• Added keepalives_interval and keepalives_retries config options.
• Added the tcp_user_timeout config option.
• Added RowIter::rows_affected.

Changed

• Passing an incorrect number of parameters to a query method now returns an error instead of panicking.

Added

• Added ToSql and FromSql implementations for [u8; N] via the array-impls feature.
• Added support for smol_str 0.1 via the with-smol_str-01 feature.
• Added ToSql::encode_format to support text encodings of parameters.

Added

• Added support for uuid 1.0 via the with-uuid-1 feature.

Added

• Added SimpleQueryRow::columns.
• Added support for eui48 1.0 via the with-eui48-1 feature.
• Added FromSql and ToSql implementations for arrays via the array-impls feature.
• Added support for time 0.3 via the with-time-0_3 feature.

Added

• Added support for geo-types 0.7 via with-geo-types-0_7 feature.
• Added Client::clear_type_cache.

Changed

• Upgraded to tokio-postgres 0.7.
• Methods taking iterators of ToSql values can now take both &dyn ToSql and T: ToSql values.

Added

• Added Client::is_valid which can be used to check that the connection is still alive with a timeout.

Fixed

• Restored the Send implementation for Client.

Changed

• Upgraded to tokio-postgres 0.6.

Added

• Added Config::notice_callback, which can be used to provide a custom callback for notices.

Fixed

• Fixed client shutdown to explicitly terminate the database session.

Fixed

• Fixed transactions to roll back immediately on drop.

Added

• Added support for geo-types 0.6.

Fixed

• Errors sent by the server will now be returned from Client methods rather than just being logged.

Added

• Added Transaction::savepoint, which can be used to create a savepoint with a custom name.
• Added Client::notifications, which returns an interface to the notifications sent by the server.

Added

• Added Debug implementations for Client, Row, and Column.
• Added time 0.2 support.

Added

• Added Client::build_transaction to allow configuration of various transaction options.
• Added Client::cancel_token, which returns a separate owned object that can be used to cancel queries.
• Added accessors for Config fields.
• Added a GenericClient trait implemented for Client and Transaction and covering shared functionality.

Changed

• Each Client now has its own non-threaded tokio Runtime rather than sharing a global threaded Runtime. This significantly improves performance by minimizing context switches and cross-thread synchronization.
• Client::copy_in now returns a writer rather than taking in a reader.
• Client::query_raw now returns a named type.
• Client::copy_in and Client::copy_out no longer take query parameters as PostgreSQL doesn't support them in COPY queries.

Removed

• Removed support for uuid 0.7.

Added

• Added Client::query_opt for queries that are expected to return zero or one rows.
• Added binary copy support in the binary_copy module.
• The fallible-iterator crate is now publicly reexported.

Changed

• Changed Config::executor to Config::spawner.

Added

• Added support for uuid 0.8.
• Added Transaction::query_one.

Changed

• Updated tokio-postgres to 0.5.0-alpha.1.

Fixed

• Documentation fixes

Changed

• Connection has been renamed to Client.

• The Client type is now a thin wrapper around the tokio-postgres nonblocking client. By default, this is handled transparently by spawning connections onto an internal tokio Runtime, but this can also be controlled explicitly.

• The ConnectParams type and IntoConnectParams trait have been replaced by a builder-style Config type.

  Before:

  let params = ConnectParams::builder()
      .user("postgres", None)
      .build(Host::Tcp("localhost".to_string()))
      .build();
  let conn = Connection::connect(params, &TlsMode::None)?;
  

  After:

  let client = Client::configure()
      .user("postgres")
      .host("localhost")
      .connect(NoTls)?;
  

• The TLS connection mode (e.g. prefer) is now part of the connection configuration instead of being passed in separately.

  Before:

  let conn = Connection::connect("postgres://postgres@localhost", &TlsMode::Prefer(connector))?;
  

  After:

  let client = Client::connect("postgres://postgres@localhost?sslmode=prefer", connector)?;
  

• Client and Transaction methods take &mut self rather than &self, and correct use of the active transaction is verified at compile time rather than runtime.

• Row no longer borrows any data.

• Statement is now a "token" which is passed into methods on Client and Transaction and does not borrow the client:

  Before:

  let statement = conn.prepare("SELECT * FROM foo WHERE bar = $1")?;
  let rows = statement.query(&[&1i32])?;
  

  After:

  let statement = client.prepare("SELECT * FROM foo WHERE bar = $1")?;
  let rows = client.query(&statement, &[1i32])?;
  

• Statement::lazy_query has been replaced with Transaction::bind, which returns a Portal type that can be used with Transaction::query_portal.

• Statement::copy_in and Statement::copy_out have been moved to Client and Transaction.

• Client::copy_out and Transaction::copy_out now return a Reader rather than consuming in a Writer.

• Connection::batch_execute and Transaction::batch_execute have been replaced with Client::simple_query and Transaction::simple_query.

• The Cargo features enabling ToSql and FromSql implementations for external crates are now versioned. For example, with-uuid is now with-uuid-0_7. This enables us to add support for new major versions of the crates in parallel without breaking backwards compatibility.

Added

• Connection string configuration now more fully mirrors libpq's syntax, and supports both URL-style and key-value style strings.
• FromSql implementations can now borrow from the data buffer. In particular, this means that you can deserialize values as &str. The FromSqlOwned trait can be used as a bound to restrict code to deserializing owned values.
• Added support for channel binding with SCRAM authentication.
• Added multi-host support in connection configuration.
• Added support for simple query requests returning row data.
• Added variants of query methods which return fallible iterators of values and avoid fully buffering the response in memory.

Removed

• The with-openssl and with-native-tls Cargo features have been removed. Use the tokio-postgres-openssl and tokio-postgres-native-tls crates instead.
• The with-rustc_serialize and with-time Cargo features have been removed. Use serde and SystemTime or chrono instead.
• The Transaction::set_commit and Transaction::set_rollback methods have been removed. The only way to commit a transaction is to explicitly consume it via Transaction::commit.
• The Rows type has been removed; methods now return Vec<Row> instead.
• Connection::prepare_cache has been removed, as Statement is now 'static and can be more easily cached externally.
• Some other slightly more obscure features have been removed in the initial release. If you depended on them, please file an issue and we can find the right design to add them back!