Mastering Database Building in Bubble.io: Insider Tips from JJ Englert and Petter Amlie
4.9 هزار بار بازدید -
12 ماه پیش
-
In this video, JJ Englert
In this video, JJ Englert and Petter Amlie will teach you the basics of database building in Bubble.io.
JJ's Courses:
Professional Product: https://nocodealliance.org/profession...
Professional Databases: https://nocodealliance.org/bubble-dat...
Professional Workflows: https://nocodealliance.org/bubble-wor...
Or, if you'd like JJ to conduct a technical audit of your Bubble application, you can book it here: https://nocodealliance.org/bubble-audits
Petter's Resources:
Twitter: Twitter: AmlieSolutions
Database Book: https://www.amliesolutions.com/books/...
Timeline notes provided by @shankarprasad9611 -
03:00 - User Details & User Roles
* JJ’s preference for naming Option Sets
05:10 - Discussion on Satellite Datatypes (expanded user details)
* ease of setting up privacy rules
* Workload Units impact
* Performance impact
* Common Mistakes
13:00 - Satellite Datatypes - Thinking from User Story perspective (Petter) & structuring DB based on requirements ##
14:35 - What kind of data Bubble loads on page in reference to Satellite Datatypes?
15:10 - Having 2-way relationship on Satellite datatypes + benefits
16:20 - great points by JJ & Petter on DB structuring & User Experience ##
18:00 - QnA - How many fields to use on satellite datatype? Any limit preferences?
20:20 - Having a List of fields on User DB + impact in different scenarios ##
- Keep User datatype light
21:20 - Petter: try to hide unique IDs if you can
21:45 - QnA - “View” of datatype feature from Bubble(upcoming) + its impact on Satellite datatypes
23:30 - Restaurant Listings DB
Delivery Times - Option Set (if predefined)
JJ preference for naming yes/no field
26:00 - Great point by Petter on using App Text - if you are building for International Users ##
27:05 - Restaurant - List of Food Categories (BURGER, FAST FOOD) - Petter’s thought process ##
* datatype vs Option sets?
* Things to think about + Questions to ask yourself
* Will that list change over time?
* When to have it dynamic or static?
* Performance issues
* Flexibility over long term + Maintenance workload
* Issue with having this as Option Sets
31:30 - Restaurant - Reviews
* How to structure Review DB?
* Detailed explanation on using static fields instead of calculating avg review on each cell on every page load (WU intensive)
33:50 - Restaurant specific data
* Petter’s thought process on having a satellite data type
37:45 - JJ’s preference of deleting stuff
40:00 - User - Favorite Restaurants Feature ##
* “list of items” field - when to have it?
* QnA - Why store these in User DB instead of User_expanded DB?
44:00 - Food Categories on top filters
44:45 - Storing User address
* Why have it on User DB?
* Preference of formatting and storing the address?
* Geoaddress extract functionality
46:50 - Menu Item Addons
51:30 - Menu Reviews & Restaurant Reviews ##
* Interesting points mentioned by both Petter & JJ
* When to use lists and when not to?
56:40 - Updating the Review scores (frequency of updating these items)
* WUs impact
* BWF: Workaround mentioned by Petter using yes/no field on restaurants [58:20] ##
59:20 - QnA - Any specific reasons for using Lists? ##
01:01:35 - Cart Functionality
01:03:45 -JJ: Adding specific attributes that helps product sales funnels ##
01:06:35 - QnA
JJ's Courses:
Professional Product: https://nocodealliance.org/profession...
Professional Databases: https://nocodealliance.org/bubble-dat...
Professional Workflows: https://nocodealliance.org/bubble-wor...
Or, if you'd like JJ to conduct a technical audit of your Bubble application, you can book it here: https://nocodealliance.org/bubble-audits
Petter's Resources:
Twitter: Twitter: AmlieSolutions
Database Book: https://www.amliesolutions.com/books/...
Timeline notes provided by @shankarprasad9611 -
03:00 - User Details & User Roles
* JJ’s preference for naming Option Sets
05:10 - Discussion on Satellite Datatypes (expanded user details)
* ease of setting up privacy rules
* Workload Units impact
* Performance impact
* Common Mistakes
13:00 - Satellite Datatypes - Thinking from User Story perspective (Petter) & structuring DB based on requirements ##
14:35 - What kind of data Bubble loads on page in reference to Satellite Datatypes?
15:10 - Having 2-way relationship on Satellite datatypes + benefits
16:20 - great points by JJ & Petter on DB structuring & User Experience ##
18:00 - QnA - How many fields to use on satellite datatype? Any limit preferences?
20:20 - Having a List of fields on User DB + impact in different scenarios ##
- Keep User datatype light
21:20 - Petter: try to hide unique IDs if you can
21:45 - QnA - “View” of datatype feature from Bubble(upcoming) + its impact on Satellite datatypes
23:30 - Restaurant Listings DB
Delivery Times - Option Set (if predefined)
JJ preference for naming yes/no field
26:00 - Great point by Petter on using App Text - if you are building for International Users ##
27:05 - Restaurant - List of Food Categories (BURGER, FAST FOOD) - Petter’s thought process ##
* datatype vs Option sets?
* Things to think about + Questions to ask yourself
* Will that list change over time?
* When to have it dynamic or static?
* Performance issues
* Flexibility over long term + Maintenance workload
* Issue with having this as Option Sets
31:30 - Restaurant - Reviews
* How to structure Review DB?
* Detailed explanation on using static fields instead of calculating avg review on each cell on every page load (WU intensive)
33:50 - Restaurant specific data
* Petter’s thought process on having a satellite data type
37:45 - JJ’s preference of deleting stuff
40:00 - User - Favorite Restaurants Feature ##
* “list of items” field - when to have it?
* QnA - Why store these in User DB instead of User_expanded DB?
44:00 - Food Categories on top filters
44:45 - Storing User address
* Why have it on User DB?
* Preference of formatting and storing the address?
* Geoaddress extract functionality
46:50 - Menu Item Addons
51:30 - Menu Reviews & Restaurant Reviews ##
* Interesting points mentioned by both Petter & JJ
* When to use lists and when not to?
56:40 - Updating the Review scores (frequency of updating these items)
* WUs impact
* BWF: Workaround mentioned by Petter using yes/no field on restaurants [58:20] ##
59:20 - QnA - Any specific reasons for using Lists? ##
01:01:35 - Cart Functionality
01:03:45 -JJ: Adding specific attributes that helps product sales funnels ##
01:06:35 - QnA
12 ماه پیش
در تاریخ 1402/05/11 منتشر شده
است.
4,947
بـار بازدید شده