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

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

        - 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.

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.26
Committed:	Mon Feb 13 05:59:55 2012 UTC (12 years, 3 months ago) by root
Branch:	MAIN
Changes since 1.25:	+14 -0 lines
Log Message:	* empty log message *
#	User	Rev	Content
1	root	1.1	This is the change log for the perl extension PApp::SQL.
2
3	root	1.26	- 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	root	1.25	1.05 Sun Jun 21 07:13:25 CEST 2009
18	root	1.24	- 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	root	1.23	1.04 Sun Jun 21 02:27:46 CEST 2009
25	root	1.22	- be more Coro/thread friendly by actually making a copy of the
26	root	1.23	database handle inside sql_exec.
27	root	1.21	- use croak for error reporting, not die.
28
29	root	1.20	1.03 Sat Jan 19 09:56:26 CET 2008
30	root	1.19	- work around API changes in perl 5.10.
31
32	root	1.18	1.02 Fri Mar 3 15:11:23 CET 2006
33	elmex	1.17	- fixed a bug with argument passing to connect_cached in checked_dbh.
34	root	1.16	- sqlite sql_insertid support.
35	root	1.18	- added Changes file.
36	root	1.16
37	root	1.14	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	stefan	1.12	- force bind-variables to utf8 before binding (for sql_u*)
43	root	1.13	(Stefan Traby).
44	stefan	1.12
45	root	1.11	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	root	1.10	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	root	1.9	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	root	1.15	correctness in spite of perl's own optimizations ;)
58	root	1.9
59	root	1.8	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	root	1.7	0.13 Wed Feb 27 05:29:06 CET 2002
64			- sql_u* functions were not forcing utf8 on their return values.
65
66	root	1.6	0.1241 Mon Dec 31 04:03:37 CET 2001
67			- mysql_client_found_rows set by default on mysql-connects.
68
69	root	1.5	0.124 Sat Aug 11 03:02:45 CEST 2001
70	root	1.4	- new methods sql_uexec, sql_ufetch, sql_ufetchall that force/upgrade
71			to utf8.
72	root	1.5	- added COPYING.
73	root	1.4
74	root	1.3	0.121 Mon Feb 12 16:56:21 CET 2001
75	root	1.2	- set InactiveDestroy for all handles in reinitialize instead
76			of closing them.
77
78	root	1.1	0.12 Mon Feb 5 13:42:20 CET 2001
79			- seperated from the PApp package.
80			- fixes for 5.005 compatibility.
81			- renamed $database to $Database.
82
83			Changes done while this was a part of PApp include:
84
85			0.11 <Unreleased PApp version>
86	root	1.3	- 5.005-ified SQL/SQL.xs.
87	root	1.1
88			0.10 <Unreleased: missing license. Write to marco@toytest.com for complaints>
89	root	1.3	- PApp::SQL now tries to reconnect twice.
90	root	1.1
91			0.08 Sun Jun 18 23:53:50 CEST 2000
92			- fixed memory corruption bug in SQL.xs that happens
93			because mod_perl BOOT:'s the same object twice :(
94			- PApp::Env and PApp::SQL should be more resistent to restarts.
95			- PApp::SQL::*fetch methods call finish on the statement handle,
96			as does sql_exec in void context.
97
98	root	1.3	Even older, prehistoric versions of this module under other names
99			obviously had no Changes file (that's why it's called _pre_historic).
100	root	1.1
101