| 1 |
This is the change log for the perl extension PApp::SQL. |
| 2 |
|
| 3 |
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 |
2.0 Sat Jul 28 15:50:52 CEST 2012 |
| 12 |
- work around some bugs in DBD drivers (SQLite...) instead of |
| 13 |
crashing. |
| 14 |
- 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 |
- use less mind-boggling but safer method to pass return values to perl. |
| 28 |
|
| 29 |
1.05 Sun Jun 21 07:13:25 CEST 2009 |
| 30 |
- 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 |
1.04 Sun Jun 21 02:27:46 CEST 2009 |
| 37 |
- be more Coro/thread friendly by actually making a copy of the |
| 38 |
database handle inside sql_exec. |
| 39 |
- use croak for error reporting, not die. |
| 40 |
|
| 41 |
1.03 Sat Jan 19 09:56:26 CET 2008 |
| 42 |
- work around API changes in perl 5.10. |
| 43 |
|
| 44 |
1.02 Fri Mar 3 15:11:23 CET 2006 |
| 45 |
- fixed a bug with argument passing to connect_cached in checked_dbh. |
| 46 |
- sqlite sql_insertid support. |
| 47 |
- added Changes file. |
| 48 |
|
| 49 |
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 |
- force bind-variables to utf8 before binding (for sql_u*) |
| 55 |
(Stefan Traby). |
| 56 |
|
| 57 |
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 |
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 |
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 |
correctness in spite of perl's own optimizations ;) |
| 70 |
|
| 71 |
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 |
0.13 Wed Feb 27 05:29:06 CET 2002 |
| 76 |
- sql_u* functions were not forcing utf8 on their return values. |
| 77 |
|
| 78 |
0.1241 Mon Dec 31 04:03:37 CET 2001 |
| 79 |
- mysql_client_found_rows set by default on mysql-connects. |
| 80 |
|
| 81 |
0.124 Sat Aug 11 03:02:45 CEST 2001 |
| 82 |
- new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade |
| 83 |
to utf8. |
| 84 |
- added COPYING. |
| 85 |
|
| 86 |
0.121 Mon Feb 12 16:56:21 CET 2001 |
| 87 |
- set InactiveDestroy for all handles in reinitialize instead |
| 88 |
of closing them. |
| 89 |
|
| 90 |
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 |
- 5.005-ified SQL/SQL.xs. |
| 99 |
|
| 100 |
0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints> |
| 101 |
- PApp::SQL now tries to reconnect twice. |
| 102 |
|
| 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 |
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 |
|
| 113 |
|
