1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
|
$Id: HISTORY,v 1.10 2004/10/07 03:35:11 wwg Exp $
Marcelo C. de Freitas
marcelo@kow.com.br
Warren W. Gay VE3WWG
ve3wwg@cogeco.ca
APQ REVISION HISTORY:
=====================
APQ 3.1
- Build system revisited
APQ 3.0
- Project maintainer is Marcelo C. de Freitas now.
- Modular design, which allows compilation of independent parts.
- Code clean up.
- APQ_Boolean is now always treated as INTEGER ( 0 = FALSE, 1 = TRUE )
- FreeTDS compatibility
- A more generic ct_lib support (works for SQL Server and should for Sybase too)
- Error messages has been organized.
APQ 2.2
- Added Sybase support.
- Exceptions provide informative messages
- Documented Set_Port for UNIX (local) connections
- Begin_Work, Commit_Work, Rollback_Work now implicitly
call Clear on the Query_Type object, before and after.
- Set_DB_Name when called when connected, now
changes the currently used database.
- Instance and Set_Instance primitives for databases like
Sybase, that choose parameter sets.
- Case policy support for universal SQL code.
- Value function returning string now always trims
trailing blanks.
- Sybase Support Introduces:
- Cursor support is now included in APQ for databases
capable of supporting it in the client library (Sybase)
- PostgresSQL changes:
- Defaults to Set_Port(C,5432)
- MySQL changes:
- Now raises Use_Error if database selection fails
(used to raise Failed).
- Bug fix for Reset of connection.
- Fixed MySQL support of BIT type
- Accomodated MySQL date format change
APQ 2.1
- This was the win32 port. A number of changes
were made to the build scripts to make this
possible.
- Now under UNIX/Linux and Win32, it is no
longer to specify linker library arguments,
such as -lapq -lpq etc. This is now handled
by the GNAT pragma Linker_Options() directive.
- win32_test.adb program was added. This also
happens to work fine under UNIX/Linux, but
was created as a simple test for win32.
APQ 2.0
- This was an extensive release and included many
changes. The primary change was to include the
support for the MySQL database in addition to
PostgreSQL. Now APQ is structured so that one or
the other, or both may be supported depending
upon the user's own situation. For example, it
is now possible to build APQ for MySQL only
support.
- Generic database support is now available.
Through careful use of the APQ top level package
and functions, it is now possible to write
database code that does not care which database
engine is being used. See the chapter "Generic
Database Programming" in the APQ manual for more
about this.
- Many other smaller changes were made that are
documented in the manual. One major change was
the renaming of types from PG_Boolean to
APQ_Boolean (for example). Also PG_Oid has now
been renamed Row_ID_Type. Package APQ.PostgreSQL
still maintains subtype definitions of the
original type names, but the application
designer is encouraged to change to the new
names as soon as practical. The support for the
PG_ names will be dropped in a future release.
APQ 1.93
- Changed the package hierarchy to place all
PostgreSQL packages under the new top level
package APQ. This is to pave the way for
future support of other databases, such as
MySQL.
APQ 1.92
- Fixed bug for floating point and fixed point types
(was rounding the value to the nearest integer,
due to the fact that the Ada.Text_IO.Float_IO.Put
call was receiving the argument Aft => 0).
Omitting the Aft parameter causes the value to be
formatted as required for the SQL floating/fixed
point type. The bug was reported by Charles Darcy
<charlie@mullum.com.au>.
APQ 1.91
--------
- Connect now issues a SET DATESTYLE TO ISO command
automatically to assure override of the PGDATESTYLE
environment variable, that may choose a different
format. APQ applications must however use ISO
date formats in order for the APQ date support
to function correctly.
- ADA_INCLUDE_PATH=. ADA_OBJECTS_PATH=. is now
in the make file prior to gnatmake to cause the
build to ignore any possible prior installed
version of APQ.
- Added ./win32 subdirectory, to allow building APQ
in a win32 environment.
APQ 1.9
-------
- Fixes a compile error that occurs with the newer
versions of gcc like gcc (GCC) 3.1.1, and probably
> gnat 3.12 versions of GNAT. The problem occurs
when Ada.Text_IO.Integer_IO is instantiated within
functions/procedures with the same name (like INTIO),
provoking duplicate symbol errors in the assembler.
A work-around has been provided by giving the
instantiations unique names.
APQ 1.8
-------
- Added info functions Host_Name, Port, User,
Password, and Options for database connections.
- Added a new Connect primitive to allow cloning
an existing connection.
APQ 1.7
-------
- Added Open_DB_Trace and Close_DB_Trace procedures
4 levels of trace :
- Trace_None
- Trace_libpq (libpq trace information only)
- Trace_APQ (SQL query trace information only)
- Trace_Full (both Trace_libpq and Trace_APQ)
- Trace_APQ output can be fed to psql as straight
SQL for testing purposes
APQ 1.6
-------
- Added Set_Rollback_On_Finalize control primitive to
the Connection_Type object.
- Added Will_Rollback_On_Finalize query primitive to
the Connection_Type object.
- Expanded troubleshooting chapter about transactions
when programs terminate.
APQ 1.5
-------
- Fixed Append_Date, Append_Time, and Append_Timestamp
to put surrounding quotes (') around the value.
- Added troubleshooting info about failed time values.
APQ 1.4
-------
- Added Generic_Command_Oid for strong type use of PG_Oid
- Added Generic_Blob_Open for strong type use of PG_Oid
- Added Generic_Blob_Oid for strong type use of PG_Oid
- Added Generic_Blob_Unlink for strong type use of PG_Oid
- Added Generic_Blob_Import for strong type use of PG_Oid
- Added Generic_Blob_Export for strong type use of PG_Oid
APQ 1.3
-------
- Removed two debugging Put_Line calls that should not have
been part of the final release.
- Added a few pragma Inline statements to the spec.
APQ 1.2
-------
- Buffered I/O for blobs giving a major performance boost
- Blob_Flush procedure added
- End_of_Blob function added
- Fixed error recovery in Blob_Create
- Manual enhancements, including expanded troubleshooting section.
$Source: /cvsroot/apq/apq/HISTORY,v $
|
