Views vs. Tables and other questions

[kellyboy]

Hi, I have NO experience with databases and want to sign up for a free trial and then join caspio, but the application I want to build is rather complex so I'm wondering if someone can help me here. First, can someone explain the differences between tables and views, and when/if I should use one instead of the other? Is it mandatory to use a view when you could just use a table to get the same information? Next, is the learning curve to master caspio bridge long or difficult? Thank you very much in advance for your help and input!

[davep]

To be effective in Caspio you need to be \"tech-savvy\" and be comfortable with standard office applications.

Tables are buckets of data. They define the type of data that can be stored in the buckets. Views are just pictures of the data. They show you a part of the data that is comming from a bucket or data that is combined from different buckets. You cannot have a view unless you have tables.

[JolliBeng]

Hi kellyboy,

Tables are the backbone of your Caspio apps. They hold all of your data and are the starting point for creating DataPages. While Views are created from one or more tables. You can use a view to filter the data of a table and/or include a subset of its base table.

You need to make sure that the tables are well-architected accordingly to the needs of your application. The first step in creating a web-based application is to build a normalized table. You can refer to the links below :

Introduction to Table and Table Design  
Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

Views:
https://howto.caspio.com/tables-and-views/what-are-views/

 

-JolliBeng

[AnchovyXL]

Hi,

I highly suggest that you  attend Caspio Live Trainings. There you can learn the basics of Caspio Bridge and some information about databases. You may select a training session here: https://www.caspio.com/training/

In addition to the answers above, tables are the objects that will store the data you collected while a view is like a virtual table. Views are basically a result of a Select and Join statements and are created by combining two connected/related tables.

When to use a table and view? You can use tables when you are collecting and updating data thru forms while you can use views to show the data that you collected in your reports and/or filter your users through authentications. 

There are vast other uses for both of these objects you may want to search the internet for more information.

Hope this helps.

Thank you!