[ViewVC] Annotation of: cvs/PApp-SQL/Changes

This is the change log for the perl extension PApp::SQL.

2.002 Mon Mar  4 07:24:49 CET 2019
        - support DBD::MAriaDB is sql_insertid.
        - use DBI's last_insert_id method as fallback, with
          all undef parameters.

2.001 Sat Oct  7 17:52:36 CEST 2017
        - protip: avoid postgres, it's an inefficient pile of garbage code.
        - work around DBD::Pg (and only DBD::Pg) unnecessarily modifying
          the first argument of bind_param, likely due to some misguided
          implementation of some unneccessary extensions requiring
          non-standard syntax for bind_param. bleah.
        - minor av_fetch optimisation.

2.0   Sat Jul 28 15:50:52 CEST 2012
        - work around some bugs in DBD drivers (SQLite...) instead of
          crashing.
        - use SvOKp to decide whether we should upgrade to utf-8.
        - since DBD::mysql keeps changing their number detection code
          and therefore keeps corrupting our data, call bind_param
          with "correctly" deduced types on first first execution
          of an sql statement.
        - cache prepare and all statement methods per stash, to avoid
          having to look up multiple methods per execution.
        - use a default lru cache size of 100 instead of 50.
        - switch to FNV-1a hash and actually _do_ hash more than the
          first character of the sql statement.
        - check the length of the sql string when deciding whether it is
          too long for caching, do not use the size of the allocated
          memory area, which is less useful.
        - use less mind-boggling but safer method to pass return values to perl.

1.05  Sun Jun 21 07:13:25 CEST 2009
        - check statement handles for active state, to avoid using
          a cached statement handle that is currently active
          (good for recursive invocations, and threads).
        - allow cache sizes of 0, do not crash.
        - reduce max cached statement length from 8k to 4k.

1.04  Sun Jun 21 02:27:46 CEST 2009
        - be more Coro/thread friendly by actually making a copy of the
          database handle inside sql_exec.
        - use croak for error reporting, not die.

1.03  Sat Jan 19 09:56:26 CET 2008
        - work around API changes in perl 5.10.

1.02  Fri Mar  3 15:11:23 CET 2006
        - fixed a bug with argument passing to connect_cached in checked_dbh.
        - sqlite sql_insertid support.
        - added Changes file.

1.0   Thu Sep  1 10:53:32 CEST 2005
        - avoid some cast warnings.
        - it has been extremely well-tested, so bump to 1.0.

0.143 Wed Jan 28 20:03:52 MET 2004
        - force bind-variables to utf8 before binding (for sql_u*)
          (Stefan Traby).

0.142 Thu Nov  7 02:57:30 CET 2002
        - work around what looks like a memory leak inside
          DBI when execute is called with tied hashelements.

0.141 Fri Aug  2 05:29:31 CEST 2002
        - only "small" (<8k size) statements are cached, larger ones
          are thrown away on the assumption that these won't likely be
          repeated.

0.14  Wed Jun 26 03:42:30 CEST 2002
        - the sql_*fetch* functions now make mortal copies of
          the values returned by DBI. This is slower but ensures
          correctness in spite of perl's own optimizations ;)

0.131 Wed Apr 10 21:56:56 CEST 2002
        - removed references to using $DBH in the callers package, which
          doesn't work.

0.13  Wed Feb 27 05:29:06 CET 2002
        - sql_u* functions were not forcing utf8 on their return values.

0.1241 Mon Dec 31 04:03:37 CET 2001
        - mysql_client_found_rows set by default on mysql-connects.

0.124 Sat Aug 11 03:02:45 CEST 2001
        - new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade
          to utf8.
        - added COPYING.

0.121 Mon Feb 12 16:56:21 CET 2001
        - set InactiveDestroy for all handles in reinitialize instead
          of closing them.

0.12  Mon Feb  5 13:42:20 CET 2001
        - seperated from the PApp package.
        - fixes for 5.005 compatibility.
        - renamed $database to $Database.

Changes done while this was a part of PApp include:
        
0.11 <Unreleased PApp version>
        - 5.005-ified SQL/SQL.xs.

0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints>
        - PApp::SQL now tries to reconnect twice.

0.08  Sun Jun 18 23:53:50 CEST 2000
        - fixed memory corruption bug in SQL.xs that happens
          because mod_perl BOOT:'s the same object twice :(
        - PApp::Env and PApp::SQL should be more resistent to restarts.
        - PApp::SQL::*fetch methods call finish on the statement handle,
          as does sql_exec in void context.

Even older, prehistoric versions of this module under other names
obviously had no Changes file (that's why it's called _pre_historic).


Revision:	1.30
Committed:	Mon Mar 4 06:25:32 2019 UTC (5 years, 2 months ago) by root
Branch:	MAIN
CVS Tags:	rel-2_002, HEAD
Changes since 1.29:	+6 -1 lines
Log Message:	2.002
#	User	Rev	Content
1	root	1.1	This is the change log for the perl extension PApp::SQL.
2
3	root	1.30	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	root	1.29	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	root	1.30	implementation of some unneccessary extensions requiring
13	root	1.29	non-standard syntax for bind_param. bleah.
14			- minor av_fetch optimisation.
15
16	root	1.28	2.0 Sat Jul 28 15:50:52 CEST 2012
17			- work around some bugs in DBD drivers (SQLite...) instead of
18			crashing.
19	root	1.26	- 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	root	1.27	- use less mind-boggling but safer method to pass return values to perl.
33	root	1.26
34	root	1.25	1.05 Sun Jun 21 07:13:25 CEST 2009
35	root	1.24	- 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	root	1.23	1.04 Sun Jun 21 02:27:46 CEST 2009
42	root	1.22	- be more Coro/thread friendly by actually making a copy of the
43	root	1.23	database handle inside sql_exec.
44	root	1.21	- use croak for error reporting, not die.
45
46	root	1.20	1.03 Sat Jan 19 09:56:26 CET 2008
47	root	1.19	- work around API changes in perl 5.10.
48
49	root	1.18	1.02 Fri Mar 3 15:11:23 CET 2006
50	elmex	1.17	- fixed a bug with argument passing to connect_cached in checked_dbh.
51	root	1.16	- sqlite sql_insertid support.
52	root	1.18	- added Changes file.
53	root	1.16
54	root	1.14	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	stefan	1.12	- force bind-variables to utf8 before binding (for sql_u*)
60	root	1.13	(Stefan Traby).
61	stefan	1.12
62	root	1.11	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	root	1.10	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	root	1.9	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	root	1.15	correctness in spite of perl's own optimizations ;)
75	root	1.9
76	root	1.8	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	root	1.7	0.13 Wed Feb 27 05:29:06 CET 2002
81			- sql_u* functions were not forcing utf8 on their return values.
82
83	root	1.6	0.1241 Mon Dec 31 04:03:37 CET 2001
84			- mysql_client_found_rows set by default on mysql-connects.
85
86	root	1.5	0.124 Sat Aug 11 03:02:45 CEST 2001
87	root	1.4	- new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade
88			to utf8.
89	root	1.5	- added COPYING.
90	root	1.4
91	root	1.3	0.121 Mon Feb 12 16:56:21 CET 2001
92	root	1.2	- set InactiveDestroy for all handles in reinitialize instead
93			of closing them.
94
95	root	1.1	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	root	1.3	- 5.005-ified SQL/SQL.xs.
104	root	1.1
105			0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints>
106	root	1.3	- PApp::SQL now tries to reconnect twice.
107	root	1.1
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	root	1.3	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	root	1.1
118