MacOS – What Mac apps are capable of managing SQL Server databases

Unless you’re planning on running an extremely heavy loaded FTP server (which the mini won’t be able to handle anyway) the built in FTP Server should be enough.

Pure-ftpd is a classic in the Unix world and I’m sure you can of course make that run under OS X, but it doesn’t have a “UI”, it’s all command line. (But very easy to configure anyway).

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.