Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Filemaker VS Micorsoft Access

Filemaker VS Micorsoft Access
Thread Tools
maCCer
Dedicated MacNNer
Join Date: Aug 2004
Status: Offline
Reply With Quote
Jul 11, 2005, 03:25 AM
 
i have new to filemaker, just downloaded the trial version and play with it for a while.
so what is the difference between those 2 database applications?
Can i use Java (JDBC)or other program to connect and interact with the database which made by filemaker?
what is the advantage and disadvantage of using filemaker instead of Access?
BTW, we can not use microsoft's Access on Mac right?
thx in advance.
There were once four people named Everybody, Somebody, Nobody and Anybody. Somebody had to do a job, but Nobody wanted to do it. Nobody could see that Anybody could do it, and Somebody got angry about that because it was Everybody's job. Nobody ended up doing it, and it so happened that Everybody blamed Somebody when Nobody did what Anybody could have done.
     
larkost
Mac Elite
Join Date: Oct 1999
Location: San Jose, Ca
Status: Offline
Reply With Quote
Jul 11, 2005, 06:48 PM
 
The big advantages of FileMaker?

Fully cross platform.
Web enable with a few clicks (for many clients you need the web server version).
Much easier for a beginner to setup.
Much, much easier to create searches... you basically get them for free.
Better importing and exporting (for example a folder full of images).
Once you get the idea down it is easier to write quick scripts.
FileMaker projects tend to look visually better than Access projects.

Disadvantages:

It is not really a SQL frontend. You can make it act like one in certain cases, but you are really pushing things.
It is not Microsoft... this is a big deal for many companies... not Microsoft = scary.
It takes some getting used to, and SQL programmers get frustrated that it is not SQL-like.


PS... You can use JDBC... but thinking that way is not a good idea. You will simply shoot yourself in the foot that way. If you need that, then look at WebObjects, and especially the Direct-To-Java-Client part.
     
maCCer  (op)
Dedicated MacNNer
Join Date: Aug 2004
Status: Offline
Reply With Quote
Jul 11, 2005, 10:41 PM
 
Originally Posted by larkost
The big advantages of FileMaker?

Fully cross platform.
Web enable with a few clicks (for many clients you need the web server version).
Much easier for a beginner to setup.
Much, much easier to create searches... you basically get them for free.
Better importing and exporting (for example a folder full of images).
Once you get the idea down it is easier to write quick scripts.
FileMaker projects tend to look visually better than Access projects.

Disadvantages:

It is not really a SQL frontend. You can make it act like one in certain cases, but you are really pushing things.
It is not Microsoft... this is a big deal for many companies... not Microsoft = scary.
It takes some getting used to, and SQL programmers get frustrated that it is not SQL-like.


PS... You can use JDBC... but thinking that way is not a good idea. You will simply shoot yourself in the foot that way. If you need that, then look at WebObjects, and especially the Direct-To-Java-Client part.
webObject is tooo expensive for me, can not afford that.
So what databse do we use if i just write a simple java application, which need to use databse?
Is mysql good for that purpose?Any good admin tool for mysql for mac?
thx in advance
There were once four people named Everybody, Somebody, Nobody and Anybody. Somebody had to do a job, but Nobody wanted to do it. Nobody could see that Anybody could do it, and Somebody got angry about that because it was Everybody's job. Nobody ended up doing it, and it so happened that Everybody blamed Somebody when Nobody did what Anybody could have done.
     
bmedina
Mac Elite
Join Date: Jan 2000
Location: Seattle, WA, King
Status: Offline
Reply With Quote
Jul 12, 2005, 02:11 AM
 
Isn't WebObjects free now?
     
maCCer  (op)
Dedicated MacNNer
Join Date: Aug 2004
Status: Offline
Reply With Quote
Jul 12, 2005, 06:10 AM
 
Originally Posted by bmedina
Isn't WebObjects free now?
However someone in the forum has confirmed that current WO just got a develop license which is not the actual license, it that true?
There were once four people named Everybody, Somebody, Nobody and Anybody. Somebody had to do a job, but Nobody wanted to do it. Nobody could see that Anybody could do it, and Somebody got angry about that because it was Everybody's job. Nobody ended up doing it, and it so happened that Everybody blamed Somebody when Nobody did what Anybody could have done.
     
Amorya
Mac Elite
Join Date: Mar 2001
Location: England
Status: Offline
Reply With Quote
Jul 12, 2005, 10:22 AM
 
WebObjects:

Free to develop on OSX client.
Free to deploy on OSX server.
To deploy elsewhere, you seem to need to buy OSX server, take the deployment license out of it, and enter that into your build settings.
What the nerd community most often fail to realize is that all features aren't equal. A well implemented and well integrated feature in a convenient interface is worth way more than the same feature implemented crappy, or accessed through a annoying interface.
     
Angus_D
Addicted to MacNN
Join Date: Mar 2000
Location: London, UK
Status: Offline
Reply With Quote
Jul 12, 2005, 12:46 PM
 
Originally Posted by Amorya
To deploy elsewhere, you seem to need to buy OSX server, take the deployment license out of it, and enter that into your build settings.
Deployment to other platforms is no longer supported. While Apple won't go out of their way to break it, it's certainly something to bear in mind.
     
Millennium
Clinically Insane
Join Date: Nov 1999
Status: Offline
Reply With Quote
Jul 12, 2005, 12:55 PM
 
Originally Posted by bmedina
Isn't WebObjects free now?
Only the developer license is free; with that, you can only view things you develop on 5 machines. To get the full product, you have to purchase OSX Server.
You are in Soviet Russia. It is dark. Grue is likely to be eaten by YOU!
     
Sarc
Mac Elite
Join Date: Sep 2001
Location: Chile
Status: Offline
Reply With Quote
Jul 12, 2005, 03:51 PM
 
Didn't FileMaker go SQL on version 7 ?
:: frankenstein / lcd-less TiBook / 1GHz / radeon 9000 64MB / 1GB RAM / w/ext. 250GB fw drive / noname usb bluetooth dongle / d-link usb 2.0 pcmcia card / X.5.8
:: unibody macbook pro / 2.4 Ghz C2D / 6GB RAM / dell 2407wfp - X.6.3
     
tooki
Admin Emeritus
Join Date: Oct 1999
Location: Zurich, Switzerland
Status: Offline
Reply With Quote
Jul 12, 2005, 05:33 PM
 
No.

tooki
     
Amorya
Mac Elite
Join Date: Mar 2001
Location: England
Status: Offline
Reply With Quote
Jul 12, 2005, 08:57 PM
 
Originally Posted by Angus_D
Deployment to other platforms is no longer supported. While Apple won't go out of their way to break it, it's certainly something to bear in mind.
Oh yeah - forgot that. I was running 5.2 on Linux (unsupported even then) anyhow, so I lose track of these details
What the nerd community most often fail to realize is that all features aren't equal. A well implemented and well integrated feature in a convenient interface is worth way more than the same feature implemented crappy, or accessed through a annoying interface.
     
   
Thread Tools
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 08:58 PM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,