Relational Database for Mac?
I have used macs all my life for music composition, recording, and MS Office and have always been happy. But now I am creating relational databases with forms, querys and tables and I am forced to use Access. I have used filemaker pro- but it is very limited and can not create complicated relationships. Although I also have a PC I would rather use a mac, is there Access for mac, if not how does it run through Virtual PC? How fast would my mac have to be to have it run well. Thinking of buying a Tibook would this handle it? Is Oracle or Sybase overkill or the only SQL choice I have? Thanks for any info
Comments
<strong>I have used macs all my life for music composition, recording, and MS Office and have always been happy. But now I am creating relational databases with forms, querys and tables and I am forced to use Access. I have used filemaker pro- but it is very limited and can not create complicated relationships. Although I also have a PC I would rather use a mac, is there Access for mac, if not how does it run through Virtual PC? How fast would my mac have to be to have it run well. Thinking of buying a Tibook would this handle it? Is Oracle or Sybase overkill or the only SQL choice I have? Thanks for any info</strong><hr></blockquote>
FileMaker is a very powerful program the only relationships that I can think of that it has problems with is many to many, but if you know how to program for FM you can easily get around this limitation.
Daniel
If you want Free SQL, go with mysql or postgres.
If you want commercial SQL, go with Oracle or Sybase.
If you want a database fast and easy, FileMaker.
Don't bother with VPC with Access. Access is really a bad database. Another MS crap product.
mysql is a joke for relational db's
its great for stuff where you need data quickly
but if you are designing schemas where data
integrity is paramount then the above 2 are
the best choices at the moment
oracle is still a dev release so i would
pick postgres
stay away from access...its NOT a rdbms
feel free to msg me if you need help with oracle
<strong>use oracle or postgressql
mysql is a joke for relational db's
its great for stuff where you need data quickly
but if you are designing schemas where data
integrity is paramount then the above 2 are
the best choices at the moment
oracle is still a dev release so i would
pick postgres
stay away from access...its NOT a rdbms
feel free to msg me if you need help with oracle</strong><hr></blockquote>
I disagree with your comments on MySQL. Just use InnoDB to get ACID and you will have a decent database. This guy doesn't want to build a fortune 100 company around the thing, so Oracle is certainly overkill (better spend that $$$ on RAID-1 :cool: ). Postgres is more difficult to use and has less support, so I think he should go for MySQL if he does wants to go the SQL route.
Personally I think he should give Filemaker another chance. Daniel, are there any books or other resources that Zappa can use to learn Filemaker programming?
[ 10-24-2002: Message edited by: wfzelle ]</p>
<strong>
I disagree with your comments on MySQL. Just use InnoDB to get ACID and you will have a decent database. This guy doesn't want to build a fortune 100 company around the thing, so Oracle is certainly overkill .
[ 10-24-2002: Message edited by: wfzelle ]</strong><hr></blockquote>
fair enough....i wasnt thinking of innoddb
i think innodb still doesnt do nested queries..
i may be wrong on that one.
the reason i suggested oracle is...despite a steep learning curve once you "get" sql every other db is a piece of cake and i was under the
impression he was looking to learn
btw oracle is free as long its not deployed in
production so its a great tool to learn on....
Main DB <-> Manager DB <-> Data DB
... to get your many-to-many relationships. It's not the prettiest way, but I've done it successfully.
Relational or not relational?
Why not: Is Access good enough for the job?
It look like you have some experience with access allready. And Access is a wonderful tool when it comes to setting up tables, forms and reports.
So do you need to use anything else then. Why not try Access on Mac in Virtual PC. Have not tested it but I'm quite sure it will work fine.
The benefits:
You can use a tool you allready know.
Which mean you will create whatever you want faster.
If you find out laiter that you want to change, then do it laiter.
I'm a PC user now. But are to buy a apple computer soon with Virtual PC installed.
Now I'm using mySql and PHP4 in a web-project. MySql and PHP4 is a really great combination. But if you are not allready familiar with MySql, PHP or any other databases... why should you change into something else if Access works fine for you????
If any questions... please ask.
Best luck with your project
An advantage of FileMaker and 4D is, that they are cross-platform Mac/Windows (which Access isn't).
Good luck.