I have a Mac....and am seeing that there are no versions of Microsoft Access for Mac.
I've heard that MySQL is the best substitute. Is this true? Any other suggestions?
I've heard that MySQL is the best substitute. Is this true? Any other suggestions?
posted by:
|
New York City
|
-
Re: MS Access...?
Mon, November 27, 2006 - 1:54 PM1.) Access is a horrible DB unless you are only using Access itself... If youre trying to use it with web or another application youre better off with a solid DB like MS SQL, MySQL, etc..
2.) MySQL is not like access other than the act that its a database. there is no GUI built in. It dosent automate relationships with point and click and drag and shoot. That said MySQL is an excellent DB... so is PostgreSQL. The only thing i can think of off hand that exists in Macland that is comprable to Access is Filemaker - And i wouldnt use that either.
So bottom line. Use MySQL or PostgreSQL. You could also use SQLite but i dont mess with that. I know lots of people that use it for development though... -
-
Re: MS Access...?
Mon, November 27, 2006 - 3:19 PM"mySQL ... there is no GUI built in"
actually, there is a separate download that gives you a decent GUI for managing DBs, tables, accounts, and even dealing with data in tables. True, there is not drag-n-drop for realtionships, but there are PHP based tools that can help with that.
I agree that mySQL or Postgre are the way to go. I find that the walkthroughs for both are very helpful, so make sure you have it handy when you are installing and setting up db's. -
-
Re: MS Access...?
Mon, November 27, 2006 - 4:52 PM"actually, there is a separate download that gives you a decent GUI for managing DBs, tables, accounts, and even dealing with data in tables. True, there is not drag-n-drop for realtionships, but there are PHP based tools that can help with that. "
Yeah, me no likey the PHP tools though . I prefer apps. YourSQL and NaviCat are both pretty good. I prefer YourSQL but it has some issues and it seems development is all but at a halt. Course its free wheras NaviCat will set you back a few dollars. Navicat dosent have issues that ive found but the DB browsing isnt "paned" its reed which reuires far to mant new windows and doubleclicking and what not for me... but whatev.
-
-
