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

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

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