Database Applications For Mac



  1. Database Program For Their Mac
  2. Database Applications For Mac Catalina

File Maker Pro

FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. Similar to Access, FileMaker stores your database logic and all the data in a single file. It also has some support for scripting, and offers options for publishing databases on the web.

However, it's also necessary to note that FileMaker is very different from Access. There is a strict distinction between application logic and the underlying tables in Access. In FileMaker, logic and data are more closely linked. The underlying tables are more or less hidden from the user, and not as easily accessible via SQL as in Access.

Find and compare top Database Management software on Capterra, with our free and interactive tool. Quickly browse through hundreds of Database Management tools and systems and narrow down your top choices. Filter by popular features, pricing options, number of users, and read reviews from real users and find a tool that fits your needs. Records is a full-featured and powerful personal database app for the Mac. Efficiently collect and organize any kind of information, from your movies to your customer invoices in this easy-to-use database creation and management tool. Tweet Share Embed.

Open source database application builder

Bento

Database Program For Their Mac

Bento was the entry level database application from the makers of Filemaker. Unfortunately it has been discontinued in July 2013 and is no longer available for purchase.

Open Office / Libre Office

Database applications for mac catalina

Open Office and Libre office include a database application that tries to mimic Microsoft Access. It is difficult to use and misses many important features, such as simple import/export tools.

SQLite (using Base)

SQLite is not a full database application like Access. There are no forms or reports in SQLite, there's only your data and a simple, fast SQL engine. SQLite is used by many applications under the hood as an internal format and therefore most interesting to application developers.

A command line utility for SQLite 3 is included with every Mac, aptly named sqlite3. Most people will however prefer working with a graphical application like the excellent Base from Menial (available on the Mac App Store). Base offers a simple interface for viewing tables (with support for images) and creating custom SQL queries.

Apple Numbers and Microsoft Excel

Database

Numbers and Excel are spreadsheet applications and thus not a replacement for Microsoft Access. However, they have good support for working with tables. If your database consists of only few tables and no forms, these apps might just do the trick. You can at least sort and filter your tables.

Converting Access Databases to Apple Numbers with MDB Viewer
Converting Access Databases to Microsoft Excel with MDB Viewer

Microsoft Access in Parallels / VMWare

If none of the above are suitable, you can always ressort to actually running Microsoft Access on your Mac using virtualisation software like Parallels Desktop or VMWare Fusion.

Database Applications For Mac Catalina

Ninox Database 2.5.8

Ninox is an easy to use database app for Mac & iOS. Create custom business apps for you and your team. Organize everything, improve your workflow and become more productive.

Ninox empowers you to build custom apps without a single line of code. Our platform is used by individuals, startups, agencies, small businesses and enterprises in a wide range of industries.
Unlimited use cases: CRM, events, invoicing, inventory, real estates and many more.

  • Tables — With Ninox you manage your data in tables that you can browse, filter, sort and group.
  • Data fields — Ninox offers a variety of data fields, including text, numbers, Yes / No, list, date, time, picture and web address.
  • Relations — Link tables to each other to represent complex situations.
  • Forms — For neat enter data, make simple drag-and-drop forms.
  • Find — The fast full-text search is the very center of Ninox, so you immediately jump to the desired information.
  • Calculations — As in a spreadsheet to make calculations about individual records, or even entire tables linked tables.
  • Calendar — All entries with date reference are clearly displayed in the calendar.
  • Diagrams — Point to a button the current state.
  • Export — Of course, you can also export your data to further process them with Excel.
  • Roles and rights — Control exactly who can see or change the data.

What’s New:

Version 2.5.8

Database Applications For Mac
  • Kanban, GANTT, gallery, fullscreen form view: 4 new ways to visualize your data.
  • Kanban charts: Pick a grouping column and let Ninox render your data as Kanban swim lanes.
  • GANTT charts: Ninox will automatically render GANTT bars from the first two date fields in the table view.
  • Cards view: Let Ninox show your records as nicely rendered cards on a gallery.
  • Form view: Displays the form full screen.
  • Styled headlines and free text elements
  • Tooltips: Help your users with optional tooltips.
  • Schema protection: Password-protect your templates from modification.
  • Global fucntion definitions: Define reusable functions in the global context.
  • Trigger on open: Define actions that will be executed when the database is opened.

Screenshots