SRI / Mojo-Pg-4.27 / Changes 

4.27  2022-03-10
  - Fixed a race condition in Mojo::Pg::Migrations that could result in two processes trying to create the same
    migration.

4.26  2021-09-08
  - Fixed a bug in Mojo::Pg::PubSub would sometimes miss notifications. (akarelas)

4.25  2021-02-20
  - Moved SQL::Abstract::Pg into a separate distribution.

4.24  2021-01-27
  - Fixed Mojolicious 8.72 support.

4.23  2020-12-20
  - Updated examples to use signatures.
  - Improved Mojo::Pg::PubSub to handle unknown notifications more gracefully.

4.22  2020-11-06
  - Added from_dir method to Mojo::Pg::Migrations. (kiwiroy)
  - Improved Mojo::Pg::Database to handle connection errors more gracefully.

4.21  2020-10-25
  - Added reset method to Mojo::Pg.
  - Changed SQL style to use uppercase keywords.

4.20  2020-10-01
  - Fixed fork-safety feature to work with more than one fork.

4.19  2020-05-30
  - Improved .perltidyrc with more modern settings.
  - Fixed validation problem in blog example.

4.18  2020-01-30
  - Improved support for -json values to be a little more consistent.

4.17  2019-10-07
  - Reverted connection cache optimization from 4.14, because it caused problems with some connections closed by the
    PostgreSQL server.
  - Updated mojo_migrations table created by Mojo::Pg::Migrations to use a primary key.

4.16  2019-09-04
  - Updated DBD::Pg requirement to 3.7.4 due to certain JSON features not working with older versions.

4.15  2019-07-24
  - Improved compatibility with older versions of DBI.

4.14  2019-07-22
  - Improved connection cache to be more than an order of magnitude faster for blocking queries.
  - Fixed a bug in Mojo::Pg::PubSub where listen/unlisten did not work while reconnecting.

4.13  2019-01-20
  - Added support for multi-column joins to SQL::Abstract::Pg. (rsindlin)

4.12  2018-11-24
  - Added reconnect_interval attribute to Mojo::Pg::PubSub. (jberger)
  - Added db method to Mojo::Pg::PubSub. (jberger)
  - Fixed reconnect logic in Mojo::Pg::PubSub. (jberger)

4.11  2018-10-18
  - Improved various attributes to use new Mojolicious 8.03 features to avoid memory leaks.

4.10  2018-09-15
  - Updated project metadata.

4.09  2018-08-02
  - Added support for -json unary op to SQL::Abstract::Pg.
  - Added support for multi-column unique constraints in upserts to SQL::Abstract::Pg.
  - Added support for literal SQL with bind values in select fields to SQL::Abstract::Pg.

4.08  2018-01-29
  - Improved on_conflict option of insert and insert_p methods in Mojo::Pg::Database with a shortcut for simple conflict
    targets.

4.07  2018-01-28
  - Added support for "JOIN" to select and select_p methods in Mojo::Pg::Database.
  - Added support for field aliases to select and select_p methods in Mojo::Pg::Database.
  - Added support for having option to select and select_p methods in Mojo::Pg::Database.
  - Improved on_conflict option of insert and insert_p methods in Mojo::Pg::Database with shortcuts for
    "ON CONFLICT DO UPDATE SET" and "ON CONFLICT DO NOTHING".
  - Improved for option of select and select_p methods in Mojo::Pg::Database with a shortcut for "FOR UPDATE".

4.06  2018-01-27
  - Added support for on_conflict option to insert and insert_p methods in Mojo::Pg::Database.
  - Updated SQL::Abstract requirement to 1.84.
  - Improved error messages generated by SQL::Abstract::Pg to be compatible with SQL::Abstract.

4.05  2018-01-26
  - Added support for for, group_by, limit, offset and order_by options to select and select_p methods in
    Mojo::Pg::Database.
  - Added module SQL::Abstract::Pg.

4.04  2017-12-16
  - Added db attribute to Mojo::Pg::Results.
  - Added sql_for method to Mojo::Pg::Migrations.
  - Fixed a bug that could cause connections to be cached for reuse too early.

4.03  2017-11-04
  - Improved Mojo::Pg::Database to use Mojo::Promise.

4.02  2017-11-02
  - Added delete_p, insert_p, query_p, select_p and update_p methods to Mojo::Pg::Database.

4.01  2017-07-20
  - Decreased default max_connections from 5 to 1 in Mojo::Pg.

4.0  2017-07-06
  - Added support for sharing the database connection cache between multiple Mojo::Pg objects.
  - Added parent attribute to Mojo::Pg.
  - Fixed a bug where automatic migrations would leak database connections.

3.06  2017-06-01
  - Updated example application with tests.
  - Improved Mojo::Pg to be a little less noisy by deactivating PrintWarn by default.

3.05  2017-03-12
  - Improved from_string method in Mojo::Pg with search_path support.

3.04  2017-03-08
  - Fixed array reference handling in queries generated with SQL::Abstract.

3.03  2017-03-07
  - Added reset method to Mojo::Pg::PubSub.

3.02  2017-02-18
  - Fixed quoting bugs in queries generated with SQL::Abstract.

3.01  2017-02-12
  - Fixed bug in examples where migrations would not be handled correctly.

3.0  2017-02-11
  - Added support for generating queries with SQL::Abstract.
  - Added abstract attribute to Mojo::Pg.
  - Added delete, insert, select and update methods to Mojo::Pg::Database.

2.35  2017-01-11
  - Updated for Mojolicious 7.15.

2.34  2017-01-02
  - Removed with_temp_schema method from Mojo::Pg.

2.33  2017-01-01
  - Fixed a few fork-safety bugs in Mojo::Pg.

2.32  2017-01-01
  - Added with_temp_schema method to Mojo::Pg.

2.31  2016-10-09
  - Improved from_string method in Mojo::Pg to accept the "postgres://" scheme as well. (polettix)
  - Improved examples to use new Mojolicious 7.12 features.

2.30  2016-09-02
  - Improved query method in Mojo::Pg::Database to allow binding of specific DBD::Pg data types to placeholders.

2.29  2016-08-10
  - Added database_class attribute to Mojo::Pg.
  - Added results_class attribute to Mojo::Pg::Database.
  - Fixed a few fork-safety bugs and memory leaks in Mojo::Pg::PubSub.

2.28  2016-06-14
  - Updated for Mojolicious 6.65.

2.27  2016-05-21
  - Improved query method in Mojo::Pg::Database to include caller information in error messages.

2.26  2016-04-25
  - Improved expand performance slightly.

2.25  2016-03-26
  - Added support for encoding and decoding of JSON notifications.
  - Added json method to Mojo::Pg::PubSub.

2.24  2016-03-23
  - Fixed copyright notice.

2.23  2016-02-13
  - Improved tables method in Mojo::Pg::Database to list all tables and views that are visible to the current user and
    not internal.

2.22  2016-02-13
  - Fixed bug where views would be included in the list of table names.

2.21  2016-02-13
  - Added tables method to Mojo::Pg::Database.

2.20  2016-02-12
  - Fixed schema bugs in tests.

2.19  2016-02-12
  - Improved tests to use custom schemas.

2.18  2016-01-23
  - Added auto_migrate attribute to Mojo::Pg.
  - Updated example applications.

2.17  2016-01-03
  - Updated links to Mojolicious website.

2.16  2015-11-25
  - Added finish method to Mojo::Pg::Results.

2.15  2015-10-30
  - Improved Mojo::Pg::Migrations to detect if the currently active version is greater than the latest version.

2.14  2015-10-25
  - Improved unlisten method in Mojo::Pg::PubSub with support for removing all subscribers of a channel at once.

2.13  2015-10-23
  - Added search_path attribute to Mojo::Pg.

2.12  2015-10-05
  - Updated example applications.

2.11  2015-09-29
  - Improved notification performance slightly.

2.10  2015-09-16
  - Updated DBD::Pg requirement to 3.5.1 due to certain JSON features not working with older versions.

2.09  2015-08-29
  - Fixed Makefile.PL to be compliant with version 2 of the CPAN distribution metadata specification.

2.08  2015-08-14
  - Improved support for long-lived Mojo::Pg::Results objects. (Grinnz, sri)

2.07  2015-06-17
  - Fixed a few JSON encoding and decoding issues.

2.06  2015-06-07
  - Fixed bug in Mojo::Pg::Database where sequential non-blocking queries would not work correctly.

2.05  2015-04-06
  - Fixed bug in Mojo::Pg::Migrations where migrations would sometimes be executed in the wrong order.

2.04  2015-04-05
  - Fixed bug in Mojo::Pg::Migrations where the latest version could not always be determined correctly. (Hernan Lopes)

2.03  2015-04-02
  - Updated example applications.

2.02  2015-03-30
  - Improved fork-safety of Mojo::Pg::PubSub.

2.01  2015-03-25
  - Fixed bug where Perl would close the DBD::Pg file descriptor unexpectedly.

2.0  2015-03-25
  - Removed support for sequential non-blocking queries, because they are currently incompatible with DBD::Pg.
  - Removed max_statements attribute from Mojo::Pg.
  - Removed db attribute from Mojo::Pg::Results.
  - Removed backlog method from Mojo::Pg::Database.
  - Removed deprecated do method from Mojo::Pg::Database.
  - Improved performance by using prepare_cached from DBI to cache statement handles.

1.17  2015-03-20
  - Improved Mojo::Pg::Migrations to make no changes to the database when checking the currently active version.

1.16  2015-03-18
  - Added max_statements attribute to Mojo::Pg.
  - Added db attribute to Mojo::Pg::Results.
  - Improved performance for many different queries significantly with a statement handle cache.

1.15  2015-03-17
  - Improved portability of some tests.

1.14  2015-03-12
  - Fixed bug where non-blocking queries could get lost after the database connection got closed unexpectedly.

1.13  2015-03-11
  - Improved notify performance significantly.

1.12  2015-03-09
  - Fixed Mojo::Pg::Migrations to handle UTF-8 encoded files correctly.

1.11  2015-03-04
  - Removed experimental status from Mojo::Pg::PubSub.
  - Removed experimental status from pubsub attribute in Mojo::Pg.

1.10  2015-02-20
  - Updated for Mojolicious 5.81.

1.09  2015-02-15
  - Added EXPERIMENTAL module Mojo::Pg::PubSub.
  - Added EXPERIMENTAL pubsub attribute to Mojo::Pg.
  - Improved fork-safety by activating AutoInactiveDestroy by default.

1.08  2015-02-12
  - Deprecated Mojo::Pg::Database::do in favor of Mojo::Pg::Database::query.

1.07  2015-01-03
  - Added support for encoding and decoding of JSON values.
  - Added expand method to Mojo::Pg::Results.

1.06  2014-12-28
  - Added dollar_only method to Mojo::Pg::Database.

1.05  2014-12-27
  - Improved Mojo::Pg::Migrations to create a mojo_migrations table with stricter constraints.

1.04  2014-12-22
  - Improved all methods not to use question marks in queries.

1.03  2014-12-21
  - Fixed bug where Perl would close the DBD::Pg file descriptor after it had been used with the event loop.

1.02  2014-11-22
  - Improved performance for many different queries significantly by deactivating pg_server_prepare by default.

1.01  2014-11-20
  - Improved documentation.

1.0  2014-11-19
  - Removed experimental status from distribution.

0.11  2014-11-13
  - Added pid method to Mojo::Pg::Database.
  - Added close event to Mojo::Pg::Database.

0.10  2014-11-12
  - Removed dbh attribute from Mojo::Pg::Transaction.
  - Added db attribute to Mojo::Pg::Transaction.
  - Fixed bug where notifications did not get delivered immediately to the process that sent them.

0.09  2014-11-02
  - Updated Mojolicious requirement to 5.57.

0.08  2014-10-13
  - Changed default data source name in Mojo::Pg to allow more DBD::Pg environment variables to work correctly.
  - Improved Mojo::Pg to allow service names in connection strings.

0.07  2014-10-13
  - Removed commit and rollback methods from Mojo::Pg::Database.
  - Added Mojo::Pg::Transaction.
  - Added connection event to Mojo::Pg.

0.06  2014-10-12
  - Added notify method to Mojo::Pg::Database.

0.05  2014-10-11
  - Updated Mojolicious requirement to 5.49 to ensure migrations in the DATA section are not served as static files.

0.04  2014-10-10
  - Added support for migrations.
  - Added Mojo::Pg::Migrations.
  - Added migrations attribute to Mojo::Pg.

0.03  2014-10-06
  - Improved non-blocking queries to be able to introspect the statement handle.

0.02  2014-10-03
  - Added support for PostgreSQL connection strings.
  - Added from_string method to Mojo::Pg.

0.01  2014-10-03
  - First release.