1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358
|
4.28 2025-08-29
- Fixed DBD:Pg bug with a workaround (https://github.com/bucardo/dbdpg/issues/105). (TFBW)
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.
|