use Mojo::Pg::Che;

my $pg = Mojo::Pg::Che->connect("dbname=test;", "postgres", 'pg-pwd', \%attrs, max_connections=>10);
# or
my $pg = Mojo::Pg::Che->new
  ->dsn("DBI:Pg:dbname=test;")
  ->username("postgres")
  ->password('pg--pw')
  ->options(\%attrs)
  ->connect();

# or as URL
my $pg = Mojo::Pg::Che->new('postgresq://postgres@/test');
# or
my $pg = Mojo::Pg::Che->new(dsn=>"dbname=test;", username=>"postgres", password=>'pg-pwd', options=>\%attrs, max_connections=>10);

# from parent Mojo::Pg only
my $pg2 = Mojo::Pg::Che->new($che->pg);

# Bloking query
my $result = $pg->query('select ...', undef, @bind);

# Cached query
my $result = $pg->query('select ...', {Cached => 1, ...}, @bind);

# prepare sth
my $sth = $pg->prepare('select ...');

# Non-blocking query for async sth
$pg->query($sth, undef, @bind, sub {my ($db, $err, $result) = @_; ...});
Mojo::IOLoop->start unless Mojo::IOLoop->is_running;

# Mojo::Pg style
my $now = $pg->db->query('select now() as now')->hash->{now};
$pg->db->query('select pg_sleep(?::int), now() as now', undef, 2, $cb);

# DBI style
my $now = $pg->selectrow_hashref('select now() as now')->{now};
my $now = $pg->db->selectrow_hashref('select now() as now')->{now};

my $now = $pg->selectrow_array('select now() as now');

eval {
  my $tx = $pg->begin;
  $tx->query('insert into foo (name) values (?)', 'bar');
  $tx->do('insert into foo (name) values (?)', 'baz');
  $tx->commit;
};
die $@ if $@;

my $db = $pg->db;
$db->begin;
$db->do('insert into foo (name) values (?)', 'bazzzz');
$db->rollback;
$db->begin;
$db->query('insert into foo (name) values (?)', 'barrr');
$db->commit;

my @results;
my $cb = sub {
  my ($db, $err, $results) = @_;
  die $err if $err;
  push @results, $results;
};
$pg->query('select ?::date as d, pg_sleep(?::int)', undef, ("2016-06-$_", 1), $cb)
  for 17..23;
Mojo::IOLoop->start unless Mojo::IOLoop->is_running;
like($_->hash->{d}, qr/2016-06-\d+/, 'correct async query')
  for @results;

my $pg = Mojo::Pg::Che->new
  ->dsn("DBI:Pg:dbname=test;")
  ->username("postgres")
  ->password('pg--pw')
  ->options(\%attrs)
  ->connect();

# URL
my $pg = Mojo::Pg::Che->new('postgresq://postgres@/test');
# parent Mojo::Pg only
my $pg2 = Mojo::Pg::Che->new($pg->pg);
# or
my $pg = Mojo::Pg::Che->new(dsn=>"dbname=test;", username=>"postgres", password=>'pg-pwd', options=>\%attrs, max_connections=>10);

my $pg = Mojo::Pg::Che->connect("dbname=test;", "postgres", 'pg-pwd', \%attrs, max_connections=>10);