1 | This is the change log for the perl extension PApp::SQL. |
1 | This is the change log for the perl extension PApp::SQL. |
2 | |
2 | |
|
|
3 | 2.002 Mon Mar 4 07:24:49 CET 2019 |
|
|
4 | - support DBD::MAriaDB is sql_insertid. |
|
|
5 | - use DBI's last_insert_id method as fallback, with |
|
|
6 | all undef parameters. |
|
|
7 | |
|
|
8 | 2.001 Sat Oct 7 17:52:36 CEST 2017 |
|
|
9 | - protip: avoid postgres, it's an inefficient pile of garbage code. |
|
|
10 | - work around DBD::Pg (and only DBD::Pg) unnecessarily modifying |
|
|
11 | the first argument of bind_param, likely due to some misguided |
|
|
12 | implementation of some unneccessary extensions requiring |
|
|
13 | non-standard syntax for bind_param. bleah. |
|
|
14 | - minor av_fetch optimisation. |
|
|
15 | |
|
|
16 | 2.0 Sat Jul 28 15:50:52 CEST 2012 |
|
|
17 | - work around some bugs in DBD drivers (SQLite...) instead of |
|
|
18 | crashing. |
|
|
19 | - use SvOKp to decide whether we should upgrade to utf-8. |
|
|
20 | - since DBD::mysql keeps changing their number detection code |
|
|
21 | and therefore keeps corrupting our data, call bind_param |
|
|
22 | with "correctly" deduced types on first first execution |
|
|
23 | of an sql statement. |
|
|
24 | - cache prepare and all statement methods per stash, to avoid |
|
|
25 | having to look up multiple methods per execution. |
|
|
26 | - use a default lru cache size of 100 instead of 50. |
|
|
27 | - switch to FNV-1a hash and actually _do_ hash more than the |
|
|
28 | first character of the sql statement. |
|
|
29 | - check the length of the sql string when deciding whether it is |
|
|
30 | too long for caching, do not use the size of the allocated |
|
|
31 | memory area, which is less useful. |
|
|
32 | - use less mind-boggling but safer method to pass return values to perl. |
|
|
33 | |
|
|
34 | 1.05 Sun Jun 21 07:13:25 CEST 2009 |
|
|
35 | - check statement handles for active state, to avoid using |
|
|
36 | a cached statement handle that is currently active |
|
|
37 | (good for recursive invocations, and threads). |
|
|
38 | - allow cache sizes of 0, do not crash. |
|
|
39 | - reduce max cached statement length from 8k to 4k. |
|
|
40 | |
|
|
41 | 1.04 Sun Jun 21 02:27:46 CEST 2009 |
|
|
42 | - be more Coro/thread friendly by actually making a copy of the |
|
|
43 | database handle inside sql_exec. |
|
|
44 | - use croak for error reporting, not die. |
|
|
45 | |
|
|
46 | 1.03 Sat Jan 19 09:56:26 CET 2008 |
|
|
47 | - work around API changes in perl 5.10. |
|
|
48 | |
|
|
49 | 1.02 Fri Mar 3 15:11:23 CET 2006 |
|
|
50 | - fixed a bug with argument passing to connect_cached in checked_dbh. |
|
|
51 | - sqlite sql_insertid support. |
|
|
52 | - added Changes file. |
|
|
53 | |
|
|
54 | 1.0 Thu Sep 1 10:53:32 CEST 2005 |
|
|
55 | - avoid some cast warnings. |
|
|
56 | - it has been extremely well-tested, so bump to 1.0. |
|
|
57 | |
|
|
58 | 0.143 Wed Jan 28 20:03:52 MET 2004 |
|
|
59 | - force bind-variables to utf8 before binding (for sql_u*) |
|
|
60 | (Stefan Traby). |
|
|
61 | |
|
|
62 | 0.142 Thu Nov 7 02:57:30 CET 2002 |
|
|
63 | - work around what looks like a memory leak inside |
|
|
64 | DBI when execute is called with tied hashelements. |
|
|
65 | |
|
|
66 | 0.141 Fri Aug 2 05:29:31 CEST 2002 |
|
|
67 | - only "small" (<8k size) statements are cached, larger ones |
|
|
68 | are thrown away on the assumption that these won't likely be |
|
|
69 | repeated. |
|
|
70 | |
|
|
71 | 0.14 Wed Jun 26 03:42:30 CEST 2002 |
|
|
72 | - the sql_*fetch* functions now make mortal copies of |
|
|
73 | the values returned by DBI. This is slower but ensures |
|
|
74 | correctness in spite of perl's own optimizations ;) |
|
|
75 | |
|
|
76 | 0.131 Wed Apr 10 21:56:56 CEST 2002 |
|
|
77 | - removed references to using $DBH in the callers package, which |
|
|
78 | doesn't work. |
|
|
79 | |
|
|
80 | 0.13 Wed Feb 27 05:29:06 CET 2002 |
|
|
81 | - sql_u* functions were not forcing utf8 on their return values. |
|
|
82 | |
|
|
83 | 0.1241 Mon Dec 31 04:03:37 CET 2001 |
|
|
84 | - mysql_client_found_rows set by default on mysql-connects. |
|
|
85 | |
|
|
86 | 0.124 Sat Aug 11 03:02:45 CEST 2001 |
|
|
87 | - new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade |
|
|
88 | to utf8. |
|
|
89 | - added COPYING. |
|
|
90 | |
|
|
91 | 0.121 Mon Feb 12 16:56:21 CET 2001 |
3 | - set InactiveDestroy for all handles in reinitialize instead |
92 | - set InactiveDestroy for all handles in reinitialize instead |
4 | of closing them. |
93 | of closing them. |
5 | |
94 | |
6 | 0.12 Mon Feb 5 13:42:20 CET 2001 |
95 | 0.12 Mon Feb 5 13:42:20 CET 2001 |
7 | - seperated from the PApp package. |
96 | - seperated from the PApp package. |
… | |
… | |
9 | - renamed $database to $Database. |
98 | - renamed $database to $Database. |
10 | |
99 | |
11 | Changes done while this was a part of PApp include: |
100 | Changes done while this was a part of PApp include: |
12 | |
101 | |
13 | 0.11 <Unreleased PApp version> |
102 | 0.11 <Unreleased PApp version> |
14 | - 5.5-ified SQL/SQL.xs. |
103 | - 5.005-ified SQL/SQL.xs. |
15 | |
104 | |
16 | 0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints> |
105 | 0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints> |
17 | - PApp::SQL now tries to reconnect two times. |
106 | - PApp::SQL now tries to reconnect twice. |
18 | |
107 | |
19 | 0.08 Sun Jun 18 23:53:50 CEST 2000 |
108 | 0.08 Sun Jun 18 23:53:50 CEST 2000 |
20 | - fixed memory corruption bug in SQL.xs that happens |
109 | - fixed memory corruption bug in SQL.xs that happens |
21 | because mod_perl BOOT:'s the same object twice :( |
110 | because mod_perl BOOT:'s the same object twice :( |
22 | - PApp::Env and PApp::SQL should be more resistent to restarts. |
111 | - PApp::Env and PApp::SQL should be more resistent to restarts. |
23 | - PApp::SQL::*fetch methods call finish on the statement handle, |
112 | - PApp::SQL::*fetch methods call finish on the statement handle, |
24 | as does sql_exec in void context. |
113 | as does sql_exec in void context. |
25 | |
114 | |
|
|
115 | Even older, prehistoric versions of this module under other names |
|
|
116 | obviously had no Changes file (that's why it's called _pre_historic). |
26 | |
117 | |
27 | |
118 | |