Just a comment as so many ask for a "real" mac db. I used Panorama for years and loved it. Flat file, sort of. It's all in RAM so everything it does is lightning fast. Programming language to learn, yes. But then, filemaker always had programing language to do anything complex. I always got frustrated between the left and right brain approach. Right brain is all the pretty stuff, the intuitive stuff. Simple. The left brain is all the code, the logic and frankly, this is not how my brain works. Panorama let me create all sorts of "pretty" forms with a code that I got used to using. You can use arrays to alter results within a formula on the fly. You don't have to define a variable before you use it, and more. Others can use it far better than I can because it has a really seriously powerful code that also run Peal, Ruby, just about anything. Yea, Applescript too. I discovered it years ago when I was trying to learn 4D (to no avail unfortunately). The presenter explained how she used Panorama when she had to migrate a very large and broken 4D database to a newer version but first she had to take and the exported data and rearrange it for the import into the new 4D db. Cool tool.
I left it behind when I finally realized that at this time in my life, a database is simply overkill. I believe Panama has a new version now that is strictly subscription and I just wont do that. Still, with the RAM speed and its out of the box tricks, if you have to clean up a few thousand records, swapping last and first name or what have you, Panorama is one heck of an overlooked database toolkit.