Caspio's platform is well designed and provides pretty much everything you need to quickly create database-centric apps. If you are not an SQL whiz they got you covered with powerful click & drag elements that allow to build pretty complex SQL commands. We have never had a problem with deployment on our sites and it provides fast DB access. Just be sure to normalize your database! The ability to embed JS and HTML within HTML BLOCKS has been a tremendous benefit for us as well. With these options there really is very little you can't accomplish within your datapages. Review collected by and hosted on G2.com.
Caspio's trigger and task development environment can be challenging when you begin to develop beyond basic DB tasks. We have found that variables are not your friend in this environment as they tend to really "bog" down the performance of development. Caspio places limits on how many cascading "triggers" can occur within each script and this has caused us some headaches in working around this limitation. An update to the task and trigger environment last year improved performance tremendously but subsequently, there are quirks now in the interaction of the canvas. For instance - after working within the trigger or task canvas for a while a shadowy blur will begin to cover areas that you have worked on. While this does not prevent you from continuing it is very distracting. Regarding the overall management of your assets, you cannot create folders for any of your assets except for datapages. It would be beneficial to be able to organize all of your assets into folders as larger apps will encompass dozens of tables, views, localizations, styles, etc. You also cannot create dynamic global variables. They have to be static only. This means you cannot set a variable in one trigger and access it from another. This could be a limitation of SaaS development but for us, old school developers, it has been frustrating. Review collected by and hosted on G2.com.
