Hi,
If you require a highly simplified or specialised user interface for a
specific purpose or for a certain group of users then another
possibility is to write a separate web application that shares the
same database as SG, i.e. it uses the tables created by SG. You can
use SG for admin tasks and to provide the database structure. Your own
web application can then be kept very simple and typically needs far
less code than a stand-alone application. An example scenario is for
in-house staff to use SG while your simplified web interface is used
by the public or customers. While not "officially" supported, I have
found this approach to be very effective and it can greatly reduce the
amount of work involved in creating web application.
You may also be able to do some or all of the above using the PmWiki
facility in SG but I have not tried this (I have not taken the time to
understand Smarty Templates).
You can also use the SG database in OpenOffice. It is not too
difficult to connect OpenOffice (and, probably, other office suites)
to the same SQL server assuming you have easy network access to the
server. In OpenOffice you can then do mail merge from the contacts
list, generate reports and so on.
I might have strayed slightly off topic but hopefully these comments
will help someone. When I get time I must write some howtos.
Regards,
Paul.