On 03/06/2005, at 9:15 AM, Rod wrote:
Hi All!
I have a question for the database people on the list. I am at the
start of constructing a database for my Dad's business. At this
stage it will have two separate functions (repairs and test
figures), but I am also looking at using it to streamline quoting
(therefore will need a parts and client list). At least 3 people
will need access to the database, on a multi platform network (we
have 1 Mac, 1 Pc, 1 Mac OSX Server, and either a Mac or PC). I
intend to keep the data on the server and use a client program on
the other machines.
I figure I can accomplish this quiet easily with a Filemaker/
Filemaker Server combo, but price is a consideration ($0 would make
the boss very happy!). There are two solutions I am considering:
a) Using Webobjects, so all I need on the client machines are a web
browser
b) Using REALBasic to create a front end for an SQL database.
Being a multi platform language, REALBasic might be a good
solution, as I can also tailor the interface to what we need
Anybody here had experience with either solution? Are they
difficult to implement? Can anybody point me to a good resource
for SQL (especially on the Mac), as I'm a bit 'green' when it comes
to SQL.
Any help would be greatly appreciated!
Have you installed Tiger's development tools? SQL Lite comes already
installed, and there are some very slick tools for building a
database front end very quickly. Cross-platform might be an issue,
but the docs might have some answers for that as well. At least it's
a start, and you will probably learn enough about SQL to take you on
to other tools if necessary.
--
Peter Hinchliffe Apwin Computer Services
FileMaker Pro Solutions Developer
Perth, Western Australia
Phone (618) 9332 6482 Fax (618) 9332 0913
--------------------------------------------------------------------
Mac because I prefer it -- Windows because I have to.
