Jump to content
  • 0

Views vs. Tables and other questions


kellyboy
 Share

Question

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!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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!

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...