Creating a Database on Mac Pro

Question

Level 1

6 points

Creating a Database on Mac Pro

I'm sorry if this is in the wrong place, but... I don't know where to put it.

I have been searching and searching but I can't seem to find a simple answer... It almost seems like the answer is 'no'.

Is there a program I can use to make a simple, queryable database using a MacBook?

I don't want to use windows on my Mac, I prefer to not use Excel, and I understand that Mac cannot use Access.

I am a beginner, but I know what tables I need, and what queries I want to do. I will make the database while learning.

Is there any reliable program out there? (iDatabase is not an option. Too limited)

Thank you in advance.

MacBook Pro 13″, macOS 13.1

Posted on Jan 8, 2023 4:50 PM

Reply

Answer 1

ghr165

Level 4

1,324 points

Jan 8, 2023 5:25 PM in response to SixCoins

I have used DB Browser for SQLite for many years.

Reply

Answer 2

etresoft

Level 9

50,220 points

Jan 8, 2023 5:22 PM in response to SixCoins

SixCoins wrote:

I am a beginner

Building a database is not really a task for a beginner. You can use sqlite3 from the command line to build a database and query from it, but that's nothing like Access. The closest Access equivalent would be FileMakerPro.

Reply

Answer 3

Jan 8, 2023 5:36 PM in response to SixCoins

There are various databases available, including the built-in SQLite (sqlite3), and add-ons including PostgreSQL, MariaDB, Base, and Claris FileMaker Pro. There are various other good choices, too.

SQLite is very flexible, and quote capable. See the above-referenced DB Browser as a front-end for this.

MariaDB parallels the Oracle MySQL database package. Sequel Pro can be a handy front-end for those.

FileMaker Pro is probably the closest to what you are seeking, and a very good and flexible database:

… https://www.claris.com/filemaker/pro/

Analogous to the Microsoft Office package, the LibreOffice package includes the Base database:

… https://www.libreoffice.org/discover/base/

PostgreSQL is seriously capable, as well.

Other options can be the MAMP and XAMPP packages, which include a database, php, and a web server as an installable unit.

Most (all?) of the above are SQL databases. FileMaker Pro also has ODBC and JDBC access, as do some others.

I’ve used most of these, as well as Claris Bento (R.I.P.), and some other choices.

Reply

Creating a Database on Mac Pro

Similar questions