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