| 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 | |
|
|
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. |
| 2 | |
68 | |
| 3 | 0.124 Sat Aug 11 03:02:45 CEST 2001 |
69 | 0.124 Sat Aug 11 03:02:45 CEST 2001 |
| 4 | - new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade |
70 | - new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade |
| 5 | to utf8. |
71 | to utf8. |
| 6 | - added COPYING. |
72 | - added COPYING. |
