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.