1 |
This is the change log for the perl extension PApp::SQL. |
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 |
92 |
- set InactiveDestroy for all handles in reinitialize instead |
93 |
of closing them. |
94 |
|
95 |
0.12 Mon Feb 5 13:42:20 CET 2001 |
96 |
- seperated from the PApp package. |
97 |
- fixes for 5.005 compatibility. |
98 |
- renamed $database to $Database. |
99 |
|
100 |
Changes done while this was a part of PApp include: |
101 |
|
102 |
0.11 <Unreleased PApp version> |
103 |
- 5.005-ified SQL/SQL.xs. |
104 |
|
105 |
0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints> |
106 |
- PApp::SQL now tries to reconnect twice. |
107 |
|
108 |
0.08 Sun Jun 18 23:53:50 CEST 2000 |
109 |
- fixed memory corruption bug in SQL.xs that happens |
110 |
because mod_perl BOOT:'s the same object twice :( |
111 |
- PApp::Env and PApp::SQL should be more resistent to restarts. |
112 |
- PApp::SQL::*fetch methods call finish on the statement handle, |
113 |
as does sql_exec in void context. |
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). |
117 |
|
118 |
|