Re: AUGD: A Little SOS from Beijing...
Re: AUGD: A Little SOS from Beijing...
- Subject: Re: AUGD: A Little SOS from Beijing...
- From: Allen Emory <email@hidden>
- Date: Thu, 15 Feb 2007 21:28:38 -0500
If you are going to go the route of a web based member database you
might consider mySQL. The biggest advantage is that it is free. It also
works well with PHP (free and included on your mac already) a natural
for writing the web interface. The down side is that it is a lot of
work.
This is Triangle Macintosh Users Group keeps its records. Actually you
really don't need to build an interface at all, use phpMyAdmin. And if
you have it on a webserver everyone can access it (as long as they have
the password). Now you have decentralized database administration.
http://www.phpmyadmin.net/home_page/index.php
There are other mySQL based solutions. If you are using Mac OS X server
you already have mySQL installed. You just need something like
phpMyAdmin to admin the database. (well you don't really need that, you
can do it all through terminal, but do you want to? well, maybe :-D )
mySQL and phpMyAdmin can both be installed via DarwinPorts
http://darwinports.opendarwin.org/
oh, and yes MySQL supports Chinese character sets.
Allen Emory
Triangle Macintosh Users Group
http://www.tmug.org
Raleigh, Durham, Chapel Hill, NC USA
On Feb 14, 2007, at 9:57 PM, Greg Sharp wrote:
Hi David,
Have you considered doing things differently, namely is there any
reason why
you cannot web enable your membership database?
You could go out and buy Filemaker Server 8 Advanced which would give
you
total control with custom web publishing. Unfortunately being
thousands of
dollars this solution is beyond most groups means financially. However
since
version 4 the client version of Filemaker has supported instant web
publishing and only requires modifying one or two settings to
implement. You
can set user or group level access permissions on the database if
needed as
well.
This way you can have prospective members fill in their own membership
application on line (saves you a lot of work but can expose you to
security
issues if not done properly) or if you don't wish to make the database
public set it up so your approved partners ( implementing user/group
permissions in Filemaker) can log in and add new members details to the
database. Both of these alternatives will work from anywhere with an
internet connection.
Another added advantage is that you could set up other database's, for
example one for polls that could be integrated in such a way as to
verify
that a member exists in the members database (if the members database
was
publicly accessible) before being able to vote. You could even set it
up so
these visitors wanting to vote get redirected to a sign up page for new
memberships. There are heaps of different applications that could be
instigated this way.
--
All the best
Greg Sharp
President/Webmaster
email@hidden
Australian Mac Users Group (AUSMUG)
http://www.australian.macusersgroup.org
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Augd mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden