forked from mojolicious/mojo-pg
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChanges
339 lines (253 loc) · 10 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
4.13 2018-11-25
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.