Is there an APP that will run on a late 2020 MacBook Pro M1 to provide a database environment? I am a power user in MSAccess, MSSQL and Teradata. Retired and want similar functionality. I see a few Database client tools but will need to store the dat on the MACbook.
[Re-Titled by Moderator]
MacBook Pro 13″, macOS 15.3
Claris FilemakerPro is the only fully featured, out of the box database product on Mac platforms, and it's not cheap - a single license is $625. There are cloud versions too but they are only by annual subscription.
For something similar to MSAccess on Macs, look into LibreOffice. It's free, has a good reputation and includes LibreOffice Base which is designed as an alternative to Access. Base includes a built-in HSQL database engine and can use MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. It also has support for JDBC and ODBC drivers.
I second MAMP or MAMP Pro if you want a simplier GUI or the ability to easily switch between multiple versions or environments.
Another solution would be to pay for an inexpensive virtual server in the cloud. There are many choices out there with many having free product tiers with resources restrictions: https://www.linode.com/pricing/
Another solution would be to use virtualization to install a second operating system (or two) on your Mac: https://mac.getutm.app/. You could have a Windows VM for MS Access and a Fedora installation for MySQL, and others.
And one final solution is to buy a cheap PC, install what you need, and put it under the desk somewhere and then use the Microsoft Remote Desktop client to connect to it from your Mac when needed. I do this daily by having a Windows PC in the server room at work (for mostly MS Access), and connecting to it from my MacBook Air as needed.
meant ot be MDFlight wrote:
Is there an APP that will run on a late 2020 MacBook Pro M1 to provide a database environment? I am a power user in MSAccess, MSSQL and Teradata. Retired and want similar functionality. I see a few Database client tools but will need to store the dat on the MACbook.
[Re-Titled by Moderator]
MAMP is meant to be easy to use if it suits your needs
Filemaker is known but expensive for what I need to do. I am retire and want to use familiar tools to manage small opportunities.
I will look into LibreOffice to see if it will offer what I need.
Thank you for your input.
I just downloaded MAMP to see what it will do, I had thought of finding a used PC and letting it run ust for this purpose.
Thank you for your response.
How can I run a database environment on a MacBook Pro M1 for MSAccess, MSSQL and Teradata?
