Looking for a good general-purpose database
I've been hunting high and low for a decent general-purpose database app (something along the lines of a very slimmed-down MS Access). I see a number of promising options hiding in the App Store, but it's difficult to tell if any would meet all of my specific needs, or if there are any that I'm overlooking entirely. I played around with TapForms Lite, and it didn't seem to hit all the marks, though it seemed quite nice in its own rite.
Here's essentially what I need:
In other words, I want the Database app that's built into the HP 200LX, but for the iPad and iPhone! I've been limping along with Numbers, but it's a rather crude "database", even if it does provide the syncing and printing that I like. I can at least put multiple tabs in a file to categorize records, but there's no filtering whatsoever, and it's rather sluggish and clumsy to deal with a schema that has a lot of columns. Multi-column sorting is also rather painful.
- General-purpose database, allowing creation of different tables/forms with various types of fields. Text, numeric, date, time, drop-downs, check boxes, radio buttons, etc.
- It doesn't need to be a relational database - a single table/form per database file would be acceptable. But if it is relational, that's cool too.
- Ability to create and save views, i.e. very specific subsets of the data with different filtering, sorting, layout, etc. I would need to be able to fetch, for example, all records where a specific date field is empty or greater than the current date, or records that have any one of a certain set of values in a particular field, and also specify the sorting of the results. A database with a single search function that searches every field at once isn't specific enough. I need something more on par with the filtering that can be done with an SQL query.
- Some kind of export functionality to create standard files (CSV, Excel, sqlite, whatever). Importing would be nice too.
- AirPrint support would be highly desirable.
- I'd like some kind of convenient syncing, whether it be via iCloud, or a direct sync over a wireless LAN. I mostly use Windows, but I don't particularly need to access the databases outside of iOS on any regular basis.
So, what would be worth taking a look at?