-
Notifications
You must be signed in to change notification settings - Fork 46
/
Changes
357 lines (256 loc) · 11.6 KB
/
Changes
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
4.28 2022-03-15
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.