File: README

package info (click to toggle)
apq 3.2.0-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 1,904 kB
  • ctags: 369
  • sloc: ada: 2,794; ansic: 2,053; sh: 1,277; makefile: 192
file content (184 lines) | stat: -rw-r--r-- 6,450 bytes parent folder | download | duplicates (2)
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
$Id: README,v 1.19 2004/10/07 03:35:27 wwg Exp $



===========================================================================
=                             APQ Version 3.0                             =
===========================================================================
=                      The APQ Ada95 Database Library                     = 
=                                                                         =
=  This package has the commmon part for all the APQ drivers available.   =
=  In order to connect to a database, you'll have to download and install =
= one of the database bindings being:                                     =
=        * MySQL :: apq-mysql package                                     =
=        * PostgreSQL :: apq-postgresql package                           =
=        * Ms. SQL Server/Sybase :: apq-ct_lib package                    =
=        * Sybase (more specialized) :: apq-sybase                        =
=                                                                         =
= Authors:                                                                =
=   Warren W. Gay VE3WWG <ve3wwg@cogeco.ca>                               =
=                http://home.cogeco.ca/~ve3wwg                            =
=   Marcelo C. de Freitas <marcelo@kow.com.br>                            =
===========================================================================
                 

Why use APQ over other products?


APQ Features:
-------------

  - It is a thick binding, making it natural for Ada programmers.
  - It is very simple to use, making programming easy.
  - Can be used with strong Ada types.
  - Generic procedure and function support for strong types.
  - Supports multiple database engines generically
  - MySQL supported as of APQ-2.0
  - Sybase supported as of APQ-2.2
  - Database neutral code is possible (portable)

  - Full BLOB support (for PostgreSQL)
  - Blob I/O is performed through Ada95 stream I/O.
  - High performance blob I/O through buffered stream I/O
  - Optionally blob I/O can be unbuffered.

  - Native binding (no ODBC muss or fuss!)
  - Full support for NULL values.
  - Additional support for DATE, TIME and TIMESTAMP data types.
  - Some support for TIMEZONE types (PostgreSQL)
  - Supports bit string types (PostgreSQL)
  - Leaves the SQL in human readable form

  - 4 levels of tracing for application debugging
    - Trace_None  (no tracing)
    - Trace_DB    (C library trace information only)
    - Trace_APQ   (SQL query trace information only)
    - Trace_Full  (both Trace_DB and Trace_APQ)
  - Trace_APQ output can be fed as SQL text for testing

  - Non restritive license :
    - MGPL (GNAT Modified GNU Public License)

  - Extensive manual, with examples for nearly every function.
    - notice while the manual hasn't been update for a while, it's
    still a great source of information.
  - Manual includes a chapter on generic database programming.

  - Experimental support of the Decimal_Type package (using
    decimal routines used internally by the PostgreSQL database
    engine).
  - Under active development and use

Design Goals:
-------------

The main design goals for the APQ binding development were:

  - simple to use
  - easy to read
  - reliable
  - database vendor neutral (generic database programming)
  - at the user's option, strongly typed
  - strong blob support
  - No C language interfaces or types
  - good documentation

It is the authors' belief that these goals have been suitably met,
although the package is still undergoing active research. Excluding blob
support, there are only 2 tagged object types that the programmer must
become familiar with. These objects include Finalization and  nicely
clean up after themselves. Blob support adds one more tagged object that
the programmer can interact with.

  1. The Connection_Type object for database connections
  2. The Query_Type object for SQL interactions with server
  3. The Blob_Type type for Blob I/O and operations

Having few objects reduces the learning curve substantially. A large
number of functions and procedures are overloaded -- reusing the same
name. This also reduces the learning curve, since the remaining
differences are only in the involved data types. Much complexity
is hidden within the state driven objects.

The APQ binding allows the Ada95 programmer to interface with blobs
using stream I/O. This preserves the Ada advantage for strong type
checking while making it simple for the programmer to perform I/O. As of
APQ 1.2, the blob I/O is buffered, giving the stream I/O for blobs a
major performance boost. No longer will the programmer need to search
for performance work-arounds for blob operations.

Version 2.2 of APQ brings Sybase into the fold of supported
databases. This is particularly useful now that Sybase has
generously made their ASE-12.5x Express edition of their
server available to developers for free.

Version 3.0 provides full compatibility with the FreeTDS library, 
thus providing Microsoft SQL Server support in adition to the
already existing Sybase support.

Trial Programs:
---------------

In the 3.0 the old trial programs has been removed from the distribution.

However, there are some examples in the "samples" folder for testing
some of the features (but not all of them).

If you'd like to help, providing such tests would be agreat place to
start.


Platforms:
----------

These are the platforms where we've been sucessful in compilling and using APQ so far:

OS:
	Linux Kernel 2.6
	Windows 2k, 2k3, XP and Vista
Compiler:
	GNAT 3.14p
	GNAT GCC 4.2 and 4.3

Database Servers:
	PostgreSQL 7.3.5
	MySQL 4.0.14 and 5.0.76
	Sybase ASE 12.52
	Microsoft SQL Server 2005

While not yet tested on all platforms, this package will likely
port well for must UNIX platforms, including:

 - FreeBSD		(untested)
 - NetBSD 		(untested)
 - OpenBSD		(untested)
 - HP-UX 10.2 or higher (untested)
 - Sun Solaris 		(untested)


Win32 Builds:
-------------

Win32 builds are now possible. See the pdf document
named win32.pdf for instructions on how to build APQ
from sources.


Feedback:
---------

Please feedback suggestion and bugs to the project homepage:
	http://framework.kow.com.br

When reporing bugs please provide also:
	. Database server with version
	. OS with version
	. Ada compiler with version


Thank-you for downloading and using APQ.


See file HISTORY for revision history

- End -