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/bubbledat...
Professional Workflows: https://nocodealliance.org/bubblewor...

Or, if you'd like JJ to conduct a technical audit of your Bubble application, you can book it here: https://nocodealliance.org/bubbleaudits

Petter's Resources:
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 2way 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