|
1 | | -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML3.2//EN"> |
| 1 | +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML4.0 Transitional//EN"> |
2 | 2 | <HTML> |
3 | 3 | <HEAD> |
4 | | -<TITLE>PgAccess - a Tcl/Tk PostgreSQL interface</TITLE> |
5 | 4 | <METAHTTP-EQUIV="Content-Type"CONTENT="text/html; charset=iso-8859-1"> |
6 | | -<METANAME="GENERATOR"CONTENT="Mozilla/3.04Gold (X11; I; Linux 2.0.33 i586) [Netscape]"> |
| 5 | +<METANAME="GENERATOR"CONTENT="Mozilla/4.07 [en] (X11; I; Linux 2.0.36 i586) [Netscape]"> |
| 6 | +<TITLE>PgAccess - a Tcl/Tk PostgreSQL interface</TITLE> |
7 | 7 | </HEAD> |
8 | 8 | <BODYBGCOLOR="#FFFFFF"> |
9 | 9 |
|
10 | | -<H1>PgAccess - a free database management tool for<AHREF="http://www.postgreSQL.org">PostgreSQL</A></H1> |
11 | | - |
12 | | -<P> |
13 | | -<HR></P> |
14 | | - |
15 | | -<LI><AHREF="pgaccess-0.91.tar.gz">Download the last version of PgAccess |
16 | | -(press shift and click this link)</A>.</LI> |
17 | | - |
18 | | -<CENTER><P>Latest version of PgAccess is 0.91 , 1 November 1998 !<BR> |
19 | | -<BR> |
20 | | - <B><FONTCOLOR="#FF0000">NEW * NEW * NEW *</FONT></B><B><FONTCOLOR="#FF0000"> |
21 | | -NEW *</FONT></B> ==== ><B><FONTSIZE=+1>QUERY PARAMETERS</FONT></B> |
22 | | -(see section Queries below)<BR> |
23 | | -<BR> |
24 | | -Precompiled libpgtcl and libpq binaries for i386 are<AHREF="ftp://ftp.flex.ro/pub/pgaccess">here |
25 | | -</A>!!!<BR> |
26 | | - </P></CENTER> |
27 | | - |
28 | | -<CENTER><TABLEBORDER=3CELLSPACING=0CELLPADDING=0WIDTH="100%"BGCOLOR="#FFB6C1"> |
29 | | -<TR> |
30 | | -<TD> |
31 | | -<CENTER><P><B><FONTSIZE=+2>PgAccess can now design<AHREF="forms.html">Forms</A></FONT></B>, |
32 | | -<B><FONTSIZE=+2><AHREF="pga-rad.html">Reports and Scripts</A></FONT></B> |
33 | | -</P></CENTER> |
34 | | -</TD> |
35 | | -</TR> |
36 | | -</TABLE></CENTER> |
37 | | - |
38 | | -<H3><FONTCOLOR="#000080">Installation problems</FONT></H3> |
| 10 | +<H1> |
| 11 | +PgAccess - a free database management tool for<AHREF="http://www.postgreSQL.org">PostgreSQL</A></H1> |
| 12 | + |
| 13 | +<HR> |
| 14 | +<LI> |
| 15 | +Download the last version of PgAccess<AHREF="pgaccess-0.93.tar.gz">(press |
| 16 | +shift and click this link) (tar.gz file)</A> or <AHREF="pgaccess.zip">this |
| 17 | +one (zip file for Windows)</A></LI> |
| 18 | + |
| 19 | +<CENTER> |
| 20 | +<P><BR>Latest stable version of PgAccess is 0.93 , released 10 December |
| 21 | +1998 ! |
| 22 | +<P><FONTSIZE=+2><B><FONTCOLOR="#FF0000">NEW *</FONT></B><B><FONTCOLOR="#FF0000">NEW |
| 23 | +*</FONT></B></FONT><B><FONTCOLOR="#FF0000"> </FONT><FONTCOLOR="#000000"><FONTSIZE=+1> |
| 24 | +==></FONT><FONTSIZE=+2>Microsoft Windows compatible version</FONT></FONT></B> |
| 25 | +<P> <B><FONTCOLOR="#FF0000">NEW *</FONT></B> ====><B>PostgreSQL |
| 26 | +user management, multiple table views</B>,.<B>Query parameters</B> (see |
| 27 | +section Queries below) |
| 28 | +<P>Precompiled libpgtcl and libpq binaries and dll's for i386 are<AHREF="ftp://ftp.flex.ro/pub/pgaccess">here |
| 29 | +</A>!!!</CENTER> |
| 30 | + |
| 31 | +<BR> |
| 32 | +<H3> |
| 33 | +<FONTCOLOR="#000080">Installation problems</FONT></H3> |
39 | 34 |
|
40 | 35 | <UL> |
41 | | -<LI>Some problems related with locale special characters could be solved |
42 | | -by this<AHREF="specialchars.html">simple patch</A></LI> |
| 36 | +<LI> |
| 37 | +Some problems related with locale special characters could be solved by |
| 38 | +this<AHREF="specialchars.html">simple patch</A></LI> |
43 | 39 |
|
44 | | -<LI>I think that there were some problems loading libpgtcl library. I invite |
| 40 | +<LI> |
| 41 | +I think that there were some problems loading libpgtcl library. I invite |
45 | 42 | you to read a<AHREF="index.html#libpgtcl">special section concerning |
46 | 43 | libpgtcl</A></LI> |
47 | 44 |
|
48 | | -<LI>For Silicon Graphics Indigo computers, Irix operating system, there |
49 | | -is a<AHREF="irix.html">HOWTO make PgAccess to work</A></LI> |
| 45 | +<LI> |
| 46 | +For Silicon Graphics Indigo computers, Irix operating system, there is |
| 47 | +a<AHREF="irix.html">HOWTO make PgAccess to work</A></LI> |
50 | 48 | </UL> |
51 | 49 |
|
52 | | -<H3><FONTCOLOR="#191970">What does PgAccess now!</FONT></H3> |
53 | | - |
54 | | -<P>Here are some screenshots from PgAccess windows :<AHREF="pic-pga-1.gif">Main |
| 50 | +<H3> |
| 51 | +<FONTCOLOR="#191970">What does PgAccess now!</FONT></H3> |
| 52 | +Here are some screenshots from PgAccess windows :<AHREF="pic-pga-1.gif">Main |
55 | 53 | window</A>,<AHREF="pic-pga-2.gif">table builder</A>,<AHREF="pic-pga-4.gif">table(query) |
56 | | -view</A>,<AHREF="pic-pga-3.gif">visual query builder</A>.</P> |
57 | | - |
58 | | -<P><B>Tables</B><BR> |
59 | | -- opening tables for viewing, max. 200 records (changed by preferences |
60 | | -menu)<BR> |
61 | | -- column resizing, dragging the vertical grid line (better in table space |
62 | | -rather than in the table header)<BR> |
63 | | -- text wrap in cells - layout saved for every table<BR> |
64 | | -- import/export to external files (SDF,CSV)<BR> |
65 | | -- filter capabilities (enter filter like (price>3.14)<BR> |
66 | | -- sort order capabilities (enter manually the sort field(s))<BR> |
67 | | -- editing in place<BR> |
68 | | -- improved table generator assistant<BR> |
69 | | -- improved field editing<BR> |
70 | | -<B>Queries</B><BR> |
71 | | -- define , edit and stores "user defined queries"<BR> |
72 | | -- store queries as views<BR> |
73 | | -- execution of queries with optional user input parameters ( select * from |
74 | | -invoices where year=[parameter "Year of selection"] )<BR> |
75 | | -- viewing of select type queries result<BR> |
76 | | -- query deleting and renaming<BR> |
77 | | -- visual query builder with drag & drop capabilities. For any of you |
78 | | -who had installed the Tcl/Tk plugin for Netscape Navigator, you can see |
79 | | -it at work<AHREF="qbtclet.html">clicking here</A><BR> |
80 | | -<B>Sequences</B><BR> |
81 | | -- defines sequences, delete them and inspect them<BR> |
82 | | -<B>Functions</B><BR> |
83 | | -- define, inspect and delete functions in SQL language<BR> |
84 | | -<B>Reports</B><BR> |
85 | | -- design and display simple reports from tables<BR> |
86 | | -- fields and labels, font changing, style and size<BR> |
87 | | -- saves and loads report description from database<BR> |
88 | | -- show report previews, sample postscript output file<BR> |
89 | | -<B>Forms</B><BR> |
90 | | -- open user defined forms<BR> |
91 | | -- form design module available<BR> |
92 | | -- query widget available, controls bound to query results<BR> |
93 | | --<AHREF="forms.html">click here</A> for a description of forms and how |
94 | | -they can be used<BR> |
95 | | -<B>Scripts</B><BR> |
96 | | -- define, modify and call user defined scripts<BR> |
97 | | -Here is<AHREF="pga-rad.html">a special section concerning forms and scripts</A> |
98 | | -.</P> |
99 | | - |
100 | | -<P>On the TO-DO list!<BR> |
101 | | -- table design (add new fields, renaming, etc.)</P> |
102 | | - |
| 54 | +view</A>,<AHREF="pic-pga-3.gif">visual query builder</A>. |
| 55 | +<P><B>Tables</B> |
| 56 | +<BR>- opening multiple tables for viewing, max. n records (changed by preferences |
| 57 | +menu) |
| 58 | +<BR>- column resizing, dragging the vertical grid line (better in table |
| 59 | +space rather than in the table header) |
| 60 | +<BR>- text wrap in cells - layout saved for every table |
| 61 | +<BR>- import/export to external files (SDF,CSV) |
| 62 | +<BR>- filter capabilities (enter filter like (price>3.14) |
| 63 | +<BR>- sort order capabilities (enter manually the sort field(s)) |
| 64 | +<BR>- editing in place |
| 65 | +<BR>- improved table generator assistant |
| 66 | +<BR>- improved field editing |
| 67 | +<BR><B>Queries</B> |
| 68 | +<BR>- define , edit and stores "user defined queries" |
| 69 | +<BR>- store queries as views |
| 70 | +<BR>- execution of queries with optional user input parameters ( select |
| 71 | +* from invoices where year=[parameter "Year of selection"] ) |
| 72 | +<BR>- viewing of select type queries result |
| 73 | +<BR>- query deleting and renaming |
| 74 | +<BR>- visual query builder with drag & drop capabilities. For any of |
| 75 | +you who had installed the Tcl/Tk plugin for Netscape Navigator, you can |
| 76 | +see it at work<AHREF="qbtclet.html">clicking here</A> |
| 77 | +<BR><B>Sequences</B> |
| 78 | +<BR>- defines sequences, delete them and inspect them |
| 79 | +<BR><B>Functions</B> |
| 80 | +<BR>- define, inspect and delete functions in SQL language |
| 81 | +<BR><B>Reports</B> |
| 82 | +<BR>- design and display simple reports from tables |
| 83 | +<BR>- fields and labels, font changing, style and size |
| 84 | +<BR>- saves and loads report description from database |
| 85 | +<BR>- show report previews, sample postscript output file |
| 86 | +<BR><B>Forms</B> |
| 87 | +<BR>- open user defined forms |
| 88 | +<BR>- form design module available |
| 89 | +<BR>- query widget available, controls bound to query results |
| 90 | +<BR>-<AHREF="forms.html">click here</A> for a description of forms and |
| 91 | +how they can be used |
| 92 | +<BR><B>Scripts</B> |
| 93 | +<BR>- define, modify and call user defined scripts |
| 94 | +<BR><B>Users</B> |
| 95 | +<BR>- define and modify user parameters |
| 96 | +<P>Here is<AHREF="pga-rad.html">a special section concerning forms and |
| 97 | +scripts</A> . |
103 | 98 | <P>This program is protected by the following<AHREF="copyright.html">copyright</A> |
104 | | -</P> |
105 | | - |
106 | 99 | <P>If you have any comment, suggestion for improvements, please feel free |
107 | | -to e-mail to :<AHREF="mailto:teo@flex.ro">teo@flex.ro </A></P> |
108 | | - |
| 100 | +to e-mail to :<AHREF="mailto:teo@flex.ro">teo@flex.ro</A> |
109 | 101 | <P><B><FONTCOLOR="#FF1493"><FONTSIZE=+2>Mailing list for PgAccess</FONT></FONT></B><AHREF="maillist.html">Here |
110 | | -you will find how to subscribe to this mailing list</A>.</P> |
111 | | - |
| 102 | +you will find how to subscribe to this mailing list</A>. |
112 | 103 | <P> |
113 | | -<HR></P> |
114 | | - |
115 | | -<H1>More information about libpgtcl - downloads</H1> |
116 | | - |
117 | | -<P> Also, you will need the PostgreSQL to Tcl interface |
| 104 | +<HR> |
| 105 | +<H1> |
| 106 | +More information about libpgtcl - downloads</H1> |
| 107 | + Also, you will need the PostgreSQL to Tcl interface |
118 | 108 | library, lined as a Tcl/Tk 'load'-able module. It is called libpgtcl and |
119 | 109 | the source is located in the PostgreSQL directory /src/interfaces/libpgtcl. |
120 | 110 | Specifically, you will need a libpgtcl library that is 'load'-able from |
121 | 111 | Tcl/Tk. This is technically different from |
122 | 112 | an ordinary PostgreSQL loadable object file, because libpgtcl is a collection |
123 | | -of object files. Under Linux, this is called libpgtcl.so.<BR> |
124 | | - You can download<B><AHREF="lib-pg63-redhat42.tar.gz">from |
125 | | -here</A></B> libpgtcl.so and libpq.so compiled for PostgreSQL 6.3 |
126 | | -version running on a Linux RedHat 4.2 i386 systems. Just copy libpgtcl.so |
127 | | -and libpq.so into your system library directory (/usr/lib or /lib) and |
128 | | -go for it.</P> |
129 | | - |
| 113 | +of object files. Under Linux, this is called libpgtcl.so. |
130 | 114 | <P> One of the solutions is to remove from the |
131 | 115 | source the line containing<B>load libpgtcl.so</B>and to load pgaccess.tcl |
132 | 116 | not with wish, but with pgwish (or wishpg) that wish that was linked with |
133 | | -libpgtcl library! I do not recommend this one.</P> |
134 | | - |
135 | | -<P> If you have installed RedHat 5.0, you should |
| 117 | +libpgtcl library! I do not recommend this one. |
| 118 | +<P> If you have installed RedHat 5.x, you should |
136 | 119 | get the last distribution kit of PostgreSQL and compile it from scratch. |
137 | | -RedHat 5.0 is using some new versions of libraries and you have to compile |
| 120 | +RedHat 5.x is using some new versions of libraries and you have to compile |
138 | 121 | and install again at least<B>libpq</B>and<B><TT>libpgtcl</TT></B>libraries. |
139 | | -</P> |
140 | | - |
141 | | -<P>However, the application should work without problems!</P> |
142 | | - |
| 122 | +<P> PostgreSQL 6.4 release has a minor bug. I does not |
| 123 | +includ by default the crypt lib when compiling libpgtcl. So, you will need |
| 124 | +to manually add a -lcrypt to SHLIB line in Makefile in src/interfaces/libpgtcl |
| 125 | +and then make clean and make again. The new libpgtcl.so library is properly |
| 126 | +configured to run pgaccess. |
| 127 | +<BR> |
143 | 128 | </BODY> |
144 | 129 | </HTML> |