|Online Database Comparator from|
|Feature Area||Airtable||Knack||Zoho Creator||Ninox||Tadabase|
|User Interface (general)||Beautiful – BUT you are working in a Spreadsheet like UI which is both the design and end user environment. This means that there is risk of users changing things they shouldn’t.|
In my experience, the Spreadsheet UI design leads inexperienced users to approach their databases like they would a spreadsheet and this can lead to some poor database designs.
Recent additions of Personal and Locked views help a little here.
|Builder: The Builder is where you create your Objects (tables) and then the pages, reports (cross tabs, charts, maps etc) which the user sees.|
End User: The end user gets a relatively modern, responsive UI which is well ‘locked down’. Particular strengths are the ability to produce pages with multiple tables and other ‘views’ which enable a rich user experience.
|Like Knack, the UI is separate for developers and users with the paradigm based around Forms (creating a form also creates the Table behind). Like Knack, the developer can build rich UIs including the ability to trigger emails and other events and workflows.|
My only issue is the cumbersome way Sub-forms are handled.
|Ninox takes a different approach in that the design view and live view cohabit (like Airtable). The difference is that you need to be an Admin user to access any design tools. For the end user, the result is a very pleasing interface to use with apps mainly working with panels which slide in and out.|
Tabular, Grid, Kanban, Chart, Form and Gantt views can be created.
|Tadabase is very similar to Knack in the sense that the UI is seperated into the designer and live apps.|
The builder is where you create the tables and pages, set up security and what are known as Layouts. The latter is interesting because they anable you to create multiple user interfaces to suit different types of users needs.
Live apps can be very attractive and modern looking as as they are seperate from the designer, there is no risk of people breaking the app whilst using it.
|Security||Very limited at the moment. Users can be given Creator, Editor, Commenter or Read only access but once they have access to a ‘base’ then they can see ANY of the data within it. In the light of GDPR and similar data protection laws this could lead to significant compliance issues. Also, no EU servers.||Very comprehensive features allow builders to quickly provide multiple levels of access to data through a UI which responds to the settings for the logged in user. This includes both feature level access and row (data) level control.||Very comprehensive features allow builders to quickly provide multiple levels of access to data through a UI which responds to the settings for the logged in user. This includes both feature level access and row (data) level control.||Once again, comprehensive control is available to determine what users (individually or by group) can see, edit, create or delete. Like Knack and Zoho Creator, views can be filtered by logged in users.||Security features are strong here, with multiple user Roles - and you can direct a user to a specific 'Layout' when they sign in based on their Role.|
The system maintains Login Logs whenever a user logs into the live app which can include quite a bit of informaiton including browser details, locations etc.
It is possible to build a SaaS service with Tadabase - including the ability to charge subscriptions to users.
|Media Handling Etc||Airtable has great features for handling documents, images etc. Multiple files can be uploaded to the same Attachment field. This makes it ideal for teams dealing with media content such as design agencies, marketing departments etc.||A more traditional approach here allows you to add file upload and image fields to the database. Usefully, you can specify sizes for thumbnails for each image which can then be used for displaying images at sensible sizes in tables etc.||Again, the features here are similar to Knack in that you can choose the size to display images etc.||Ninox has the usual capability to create file fields and images will be displayed on the edit / detail screens. |
Additionally, there is a generic attachments tab (along with a comments tab) for each table.
|Like Knack, you can create File, Image and Signature fields to the system. Additionally, Image thumbnails can be created (although at the time of writing this seems to be not working).|
However, I am constantly surprised by what can be achieved without code.
|The Deluge language is very efficient (in terms of the amount of code needed) when manipulating data and enables creator to provide a relatively steady learning curve from beginner to expert.||Ninox's NX language is very powerful and integrated into the system in a way that makes it particularly easy to learn (with a beginner mode). The language is used for everything from formula fields to complex processes manipulating multiple records.|
This means that user's slowly gain knowledge and experience with a relatively gentle learning curve.
|Tadabase's aim is to be able to produce most business logic using there No-Code features but you can also use Zapier and (very soon) Integromat for this.|
The built in record rules, action links etc seem to have more flexibilty at launch than the equivalent Knack features.
|‘Database’ features||Essentially a relational database at heart, Airtable is pretty visual in how data works. However, linking rules between tables can be broken (it’s possible even to break a one-to-many rule). This is especially likely as the UI imposes no real control over how data is entered.|
The result is incorrectly linked records and orphan child records (no cascade deletes are possible).
No relational (SQL like) queries are available – related data is gathered through Lookup and Rollup fields.
|With Knack you have a relational database which is presented to the user in a structured UI. So as long as the UI is built sensibly all should be well. However, it’s still not possible to define cascade deletes in relationships and so databases can become scattered with orphaned records.|
Again, no relational (SQL like) queries are available.
|With the exception of my comment about Sub-forms, Creator offers similar features to Knack with the very important addition of the ability to handle deletion of child records through the Deluge language. I hate having meaningless records in my databases!|
Again, no relational (SQL like) queries are available.
|The best of the bunch in this department, Ninox's relational feature include a 'Composition' option which makes a table a subtable of another and implements cascade deletes properly. You can create attractive interfaces with subtables and views.|
Once again, this is not an SQL database.
|Like most of the other systems reviewed here, Tadabase does not have cascade delete features or SQL like queries. The platform does have the abiltity to view a Table Connection Graph and detailed information about all the connections in the database.|
|In Use (for end users)||Airtable is great for simple solutions and those where all the users are familiar with the ‘design’ of the base (their name for database). However, the lack of control over what people can see and do leads to a host of problems.|
Again, recent additions of Personal and Locked views help a little here.
|The end user’s UI is pretty modern looking, and you can control it further with CSS and embed it in other web pages to really make the UI attractive.||Similar to Knack, the end result is a good clean looking app.|
‘Pages’ feature allows the creation of attractive dashboards etc. I come back to my comments about Sub Forms though - the implementation makes it very difficult to build decent parent / child forms.
|End users can have a really nice looking UI with Ninox which can include Icons and images to make it more attractive. Sliders for yes / no fields, embedded charts, commenting, different view types (Kanban, Gantt etc), etc.||Tadabase is capable of producing the most modern and frindly user interface of all platforms lited here so far. You can build pages with Kanban views, Charts, Cards (useful for dashboards), timelines, calendars etc.|
As already mentioned, there is the ability to create seperate UIs for different users.
|Mobile||There are mobile apps for Airtable but not all features are available – but it does provide access to data on the move. Unfortunately, even using a browser on a tablet limits the UI to it’s mobile feature set.||The latest Knack ‘Standard Theme’ is relatively responsive and provides most features in a mobile browser.||Zoho Creator has extensive features for making mobile / desktop apps and is by far the strongest here in this area.|
Offline access available from Premium plan up.
|There are native apps for iPhone, iPad and Android devices (and Mac) which allow for off line use of cloud databases - or indeed standalone databases on the device. This is an exceptional story for mobile use.||The system is already fairly 'responsive' but you have the additional capability to control what happens on different types of device (for example hide elements when on a phone or reduce the size).|
|Reports / Charts etc||In a Pro account you get Airtable’s Blocks feature which provides a whole host of features for charts, cross tabs, maps etc. Without this, though, you are limited to creating views (Grid, Calendar, Gallery and Kanban) which can be filtered and grouped (with subtotalling).||Quite comprehensive charts, cross tabs, maps etc are available. End users can be given the option to add / change filtering etc.||Very similar to the features available in Knack.||Ninox has strong charting, pivot table, kanban and gantt chart features. Charts can be added to forms to make dashboards etc.|
Additionally, there is a comprehensive PDF report generator with which you can easily build invoices and other reports - both for individul records or multiple records.
|Charting is fairly basic at the moment (Tadabase was only made generally available a few days ago) but I expect this to improve rapidly. There are also features in development (visible if you select to see Alpha Features) to produce PDF reports from your data. This isn't really operational yet but it's good to see progress in this direction.|
|External Users||External (not logged in) users are limited to viewing a shared base or view read only or entering data through Airtable forms. (i.e. no editing of data).||You can build pages within Knack which are either password protected or not – unprotected pages can be used by anyone. This means that you can easily have public facing, editable pages.|
Of more interest, perhaps, is that it’s easy to create self-registration feature which give people access to certain areas of your solution.
|External Users catered for via “Customer Portal” which is quite an expensive option.||There are no features for external (non logged in) users within Ninox and you would need to create forms in other tools like Cognito forms / Zapier to capture data (say from your website.||On all but the basic plan, you have Unlimited users and these can be internal or external - you can also produce unsecured pages which anyone can access.|
As already mentioned, it's simple to build a suitable UI for each type of user.
|Social Elements||Special data fields for “Collaborators” (users) which provide alert etc. Commenting feature for all records which allow @mentions etc.||None provided – up to builder to implement within solutions.||Chat features available – but not integrated with data in the application.||The closest Ninox comes to this is the ability for users to comment on records in the database. Comments are stamped with the user as well as date / time.||None provided – up to builder to implement within solutions.|
|Integrations||Zapier and Integromat integrations are available and Airtable also has direct integration with Slack.||Both Zapier and Integromat integrations are available||Zapier integration is available as is Zoho Flow||Both Zapier and Integromat integrations are available||Direct integration with SMTP Email and Twillio for SMS availbable - Zapier and Integromat comming very soon.|
Direct SMTP is very important as it means message sent from Tadabase are unlikely to be Junked as with others (without using 3rd party tool)
|Pricing / Licence model||Priced per user:|
Plus - $12 per user per month
Pro - $24 per user per month
Free tier limited to 1200 records in a base.
Can quickly get expensive with multiple users. Pro plan recommended.
|Price based on Features / Capacity:|
Starter: $39 a month
Pro: $79 a month
Other plans are available offering more storage and records etc. Pro plan recommended.
|Priced per user:|
Basic: $15 per user per month
Premium: $30 per user per month
|Priced per User:|
Cloud: $8.33 per month billed annually
Mac: $34.99 one time purchase
iPad: $16.99 one time purchase
|Price based on Features / Capacity:|
Basic: $24 per month (25 user limit)
Plus: $74 per month (no user limit)
Pro: $149 per month
Premium: $299 per month
Additional Apps, Records and Storage can be added if needed.
|Summary||Airtable is a great choice for more ad-hoc solutions for small teams. It provides a very visual user experience making good use of colours etc. When the complexity, number of users or security requirements climb then the lack of control over what a user can see and do becomes an issue.||Knack enables you to build solid, secure solutions with no coding. They look decent out of the box and can be improved by embedding into a nice webpage. I would particularly recommend Knack if you need to have external users accessing your app. Your are also able to create e-commerce solutions and collect payments through PayPal or Stripe.|
|Building solutions with Creator gives you a continuous learning curve from their simple workflows and email alerts through to the full power of a data-oriented language (Deluge). This makes Creator ideal if you need complex logic in your app – or you are already invested in the Zoho suite. The downside is still the Sub Form issue which is more important than it sounds.||This is a great product which, like Creator, is able to provide solutions with complex logic needs - while still being easy to use for beginners and experts alike. Support is exceptional with Ninox offering several weekly webinars which all users can attend to ask questions from their peers and company representatives as well as individual one to one sessions.||It's great to see a new entrant into this space - especially one which seems to have so much promise. You really can create a great looking app for your users. Even at this early stage it's clear that Tadabase should be on your list of pottential solutions.|
Like Knack (and for the same reason) this is a great choice if you have lots of infrequent users - or need to build a client portal or other public facing feature.
|Find Out More||Airtable Information||Knack Details||More about Creator||Learn about Ninox||Tadabase site|