What Database programs/tools are included with OS X? Many years ago I believe Apple included a copy of Hypercard with it's OS.  That's before my time, and I have never used it.

But, I do have occasional requirements for very simple databases.  I am not talking full relational database systems necessarily, a flat file "cardview" system would be suitable for most of my needs.

My question is simply what tools does are provided that enable simple database style data files to be created and accessed.  Graphical would be preferred, (although I am fairly sure that no such thing exists) but command line tools may be fine also, and there are a vast range of Unix/Linux style tools included so it's not beyond the bounds of possibility that some are either suitable, or at least able to be co-opted with a bit of scripting to provide a minimal database app.

I am aware of (and indeed own) third party database software such as Bento, and I am not looking to replace it or acehive it's levels of customisation.  They key is that the tool must be pre-installed with Mac os X 10.7, and not require me to download anything extra.

I have experimented with creating a custom Address book datafile with custom fields and using the Address Book front end for entering data and searchign etc, but with limited success (mainly in that I cannot subsquently use my real address book easily).
Sadly, the database tools that ship with OS X Lion are special purpose tools and lack an interface building toolkit. Apple implemented Core Storage for developers and not end users to use and a similar path seems to be likely for iCloud in the next year. The address book is the only card like storage GUI and adapting it for purposes other than storing contacts is painful to say the least.

Let's look over the open source projects included with OS X v10.7.3 that ship and call out the candidate database and key-value store frameworks you could possibly bend to your wishes:


BerkelyDB
OpenLDAP
PostgreSQL
SQLite
WebKit
libsecurity_keychain


I'll leave the various programming languages off the list since that's more of a Stack Overflow answer, but none of these is ready to go with a simple card based graphical user interface. If I had to pick one tool to re-implement hypercard, I would start with WebKit's implementation of HTML 5's client side database storage and use Safari for layout / user interface. This would likely need javascript knowledge as well as HTML / CSS to pull off a workable solution.

In a similar way, you could take tk and one of the programming languages to build up your database and UI logic and hook into your favorite data store listed above. Also, don't overlook iCloud's key-value store since it could arguably be considered "shipping with Lion."

Your constraint of not needing to install additional software is limiting since Apple no longer ships a tool that both stores data and has any sort of usable UI. Even automator can store variables, but you'd be hard pressed to make something of it in practice.



Leaving the run only what is installed constraint opens the gates to many solutions. The best (as of today) card based studying app seems to be Mental Case, but it lacks the database aspect and simple programmability of Hypercard.  I haven't seen a single viable hypercard replacement that ships on the App Store, so perhaps some developer will provide exactly the tool needed to fill the gap left by Hypercard.