Best database software for Mac?

Discussion in 'Mac Applications and Mac App Store' started by webcity, Sep 16, 2011.

  1. macrumors member

    Joined:
    Sep 16, 2011
    Location:
    United Kingdom
    #1
    Can anyone recommend a good database app for Mac? I've had a go with Bento but don't really like it. What do you guys think?
     
  2. macrumors 6502

    thatisme

    Joined:
    Mar 23, 2010
    Location:
    United States
    #2
    Filemaker
     
  3. macrumors 6502a

    Joined:
    Jul 10, 2008
    Location:
    Orlando, Florida
    #3
    FileMaker
     
  4. macrumors 65816

    Joined:
    Mar 9, 2011
    Location:
    34°55′42″N 80°44′41″W (34.
    #4
    mySQL
     
  5. macrumors G4

    Joined:
    Jul 17, 2002
    Location:
    USA
    #5
    It would help if you clarified exactly what you want. Do you want a dedicated database application or do you want a database management system/development system (DBMS) so that you can develop your own applications? If you want the latter, then you should consider:
    1. FileMaker Pro. This cross-platform DBMS from an Apple subsidiary FileMaker, Inc. is the parent of Bento and is probably the easiest to program DBMS ever.
    2. 4D. This cross-platform product is one of the first full-featured DBMSes developed for the Mac. 4th Dimension was developed with the intent of being an Apple software product, but Apple passed on it due to pressure from potential competitors.
    If you want a dedicated application such as a database for your comic book collection or your enemies list, then you should search popular Mac software lists for our specific needs.
     
  6. macrumors member

    Joined:
    Jun 6, 2011
    #6
    Free Option

    If you don't want to dish out 500 for filemaker than you can get Neo Office for free.
     
  7. macrumors 6502a

    Joined:
    Feb 12, 2008
    #7
    Or you could try the cross-platform Panorama.
     
  8. thread starter macrumors member

    Joined:
    Sep 16, 2011
    Location:
    United Kingdom
    #8
    Basically, we want something we can use to store client information, etc and print out each record in a nicely designed/formatted page. The reason I didn't like Bento is that it just literally prints a 'screenprint' of the database form.
     
  9. Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #9
    Sounds like FileMaker is what you want then.
     
  10. macrumors 6502

    TonyK

    Joined:
    May 24, 2009
    #10
    If you, or anyone who works with/for you, has any programming experience, I would suggest MySQL and pair that with PHP to create a Intranet application.

    I've done FileMaker programming in another life (under OS 7 if that tells you how long ago that was) and while it is much improved, I would still not put it in the same ranks as FoxPro.

    MySQL allows you to do a lot of things and PHP has dedicated statements for working with MySQL. All you need then is to configure a internal web server and validate security so it is not visible to the outside world.

    This allows all work stations to use the same records for multiple purposes.
     
  11. macrumors G4

    Joined:
    Jul 17, 2002
    Location:
    USA
    #11
    Rather than a DBMS, it sounds like you want a contact manager with a few more features than Address Book. Bento has templates for this already. I gather that you believe that Bento's included contact manager templates are cast in stone. However, you or someone on your staff may create your own custom contact manager in Bento. No programming is required.
     
  12. macrumors newbie

    Joined:
    Oct 16, 2013
    Location:
    UK
    #12
    Best database for Mac

    There is no better database than Helix!

    Helix is a family of software development tools allowing the rapid development, deployment and management of applications for individuals and groups of users across both local and wide area networks.

    The core product is called Helix RADE (Rapid Application Development Environment). It is a powerful, visual tool for programming relational databases and generating applications that use those databases.

    The visual nature of Helix RADE makes creating complex solutions fast and intuitive.
     
  13. macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #13
    Yes, I agree with your logic. But a "real" database system is a huge conceptual leap for must users. Getting one's hed around the difference between a simple file manager lake Filemaker and a relational DBMS server like MySQL, PostgreSQL or Oracle. It really requires some one with a Computer science education.

    A good compromise is SQLite. Also SQLite is alrady installed on my Macand is used by Core Data.

    For most people SQLite is a better option then running a RDBMS Server. Later onece this company gets bigger and needs to share data across departments and nees a three tier, RDBMS backed web server they can move very easy to mySQL or even Oracle. BUt for really small scale stuff like this use what is already installed on the Mac.
     
  14. macrumors member

    Joined:
    Sep 8, 2013
    #14
    Filemaker could help you out.
     
  15. macrumors 6502

    JoeRito

    Joined:
    Apr 12, 2012
    Location:
    New England, USA
    #15
    FileMaker is a nice app, but it stinks at crunching data and manipulating large amount s of data from multiple tables or in using complex queries- just not FM's forte. Has no real query environment where you can easily add tables and modify joins. Need MS Access unfortunately...there really isn't a good Mac substitute yet.
     
  16. macrumors G4

    Joined:
    Jul 17, 2002
    Location:
    USA
    #16
    Enthusiasts are bringing Helix back! Wow!
     

Share This Page