I'm looking for a hosted database solution that allows you to define both the back-end (tables, views, relationships) as well as the front-end (forms, reports, ...).
Both the number of tables as well as the record count is pretty low: about 15 tables and less than 10.000 records in total (for all tables).
The focus is on data presentation: the data itself will hardly change, so I don't mind doing that in the back-end. But I need the presentation layer to be flexible enough to handle things such as:
- crosstabs (pivot tables)
- conditional formatting
- A fully hosted solution
- No coding, other than some minor JS, HTML or CSS hacking
- Mature database back-end (i.e. not trying to hide this from the designer)
- Import data (e.g. from CSV) and bulk updates
- Customizable front-end
- Extensive charting features
- Notification features (send out mail if certain criteria are met)
- Good customer support
Bonus points for:
- An API in order to integrate with other web platforms
I have an extensive RDBMS background (Oracle, SQL Server) as well as programming (Java, Python, ...) but I don't have the time nor the resources to set this up myself.
I've already tried the following vendors:
Each of them failed for one or more reasons. The best back-end and customizable front-end was Caspio, but they have very poor charting features. Also, as you write small components (called datapages), you still need to create the glue between them (i.e. the actual application) and host that somewhere. Caspio could've made the cut, but they asked a four-figure amount for setting up 3 database triggers, which I found rather preposterous.
QuickBase was easy to set-up, but has a very backward way of dealing with table relationships. Also, charting abilities are still lacking in some areas and the notification functionality is crippled.
TrackVia tries too hard to shield the user from the back-end, and I had nothing but issues while testing out Knack, so that trial came to an early end.