Best Way to Set Up and Query a Simple Database on Mac

Since you already know how to use a spreadsheet, it would be simplest just to use one. There is a reason why spreadsheets are so frequently used as "databases" when the data is basically a "flat file". They are simple and many people already know how to use them.

Problems occur when the number of "records" or "rows" gets to be too big. How much are you generating in one day? The second problem is that queries can become hard to do unless they are simple queries.

I think these two problems are the most common reason why people are forced out of the spreadsheet solution. I would probably next move to SQLite. But if a spreadsheet "works" for your needs, I would just use one.

2 Likes