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