How to Setup Your Custom Database in Bubble.io (2022)

Поділитися
Вставка
  • Опубліковано 27 лис 2024

КОМЕНТАРІ • 98

  • @Genzai1821
    @Genzai1821 8 місяців тому +1

    Entire UA-cam i like ur content the way u teach is really understands me but i need from end to end website that may be startup like include design,database & workflows ,Apis no content is there like this i wish u came up this it is really helpful to everyone to build their startups with your single video if anyone reads like this to see the creator and respond for this.

    • @BuildingWithBubble
      @BuildingWithBubble  8 місяців тому +1

      Most of the videos on my channel explain the end-to-end process of rebuilding popular apps for startups to replicate 👍

  • @AW-pm7tr
    @AW-pm7tr 2 роки тому +1

    Guy is a legend. I’m powering through my app.

  • @agentesdoreino3928
    @agentesdoreino3928 2 роки тому +2

    Thanks for replying, I have learned a lot from you. Please, record these videos about database structure, we are looking forward to it here in Brazil.

  • @vincent_hall
    @vincent_hall 9 місяців тому

    Thanks for the help, Dude.
    Clear instructions and good thinking.

  • @2strokeorchoke496
    @2strokeorchoke496 Рік тому

    Good video, your data structure makes sense after seeing you build it on the home page. Thanks for the upload.

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому +1

      I remember how confusing it was to initially get my head around databases in Bubble, so I'm glad this could help!

    • @2strokeorchoke496
      @2strokeorchoke496 Рік тому

      @@BuildingWithBubble It has, experience and using bubble is something that seems to be necessary to create something from scratch. I'm starting with some of your other videos on creating a few apps to understand all key concepts to do what is necessary. Have any experience with bulk Qr code creation?

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому

      @@2strokeorchoke496 Awesome to hear. And when it comes to creating multiple QR codes at once, I'd do some research around creating backend workflows & recursive workflows in Bubble.
      Basically, you'll still build a workflow to create a QR code, but then this workflow can repeat itself as many times as you'd like.
      Hope this helps point you in the right direction.

  • @nikhiljain8679
    @nikhiljain8679 Рік тому

    Thanks ,man this video was very useful. Finally I learned how to interlink diffrent datatypes in a proper way

  • @thereforetalent
    @thereforetalent 3 місяці тому

    I'm here in 2024, this was really useful - thank you!

  • @bussenswe
    @bussenswe 2 роки тому +3

    Your videos are great 👍 they tackle the more tricky parts in a straight forward way.
    Question: if I have two user types (Student and Teacher) how would you go about structuring that?
    I'm thinking a general User Type with a usertype Field. Then create separate User-Student and User-Teacher Types for the specific datapoints for each user type.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +1

      Glad this could help!
      And yes, that'd be the best way I'd approach this. You're already all over it 👏

  • @StephenGPope
    @StephenGPope Рік тому

    wouldn't you also want to break out the Followers and Following fields in the User? those could get quite large --- User-follower and User-follow ?

  • @Axehell6394
    @Axehell6394 2 роки тому +1

    Thanks for this tutorial. One question though: why do you use a different approach to organise 'Users' and 'Followers' compared to 'Posts' and 'Content-Posts' ? Why didn't you create a 'Follower' Data type that would host the fields for 'follower' and 'following' instead of adding a list field on 'User' ?
    Thanks for your feedback,.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Hey, great question. In theory, you could create a data type for 'followers'.
      The main reason I'd separated the 'post-content' was because this data (often free-text or images) is unstructured, meaning it can quickly become cumbersome to load.
      The followers data field on the other hand, is just adding a list of user IDs together, so this wouldn't take as long to index and load each time we want to display this data.
      Hope this helps!

  • @agentesdoreino3928
    @agentesdoreino3928 2 роки тому

    In this example you create an additional table (post-content) linked to the Post table for the image fields, my doubt is the following, when you did the display through the repeating group, the fact that you used the do a search for twice (in the repeating group and in the image) doing two searches inside the repeating group can't make the display slower?
    Your videos are great, thanks for sharing your knowledge.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Great question Rodrigo! Like everything in Bubble, the speed will depend on the context of your application. I'm thinking about releasing a few additional tutorials on database structure to cater for certain nuances.
      As an alternative to performing the search twice, you could directly create a relationship to your main data type to your satellite data type e.g. Under your Post data type, creating a field that links to the Post Content Data type. If you were to do this, I'd just try to ensure that you keep the amount of data you're storing under your Post Content fields to a minimum.
      Hope this helps.

  • @orcanmehmet
    @orcanmehmet Рік тому

    you are awesome I really hope to see more videos especially about data configuration and relation among parent groups, workflow etc

  • @Amara_plays_MM2-w3o
    @Amara_plays_MM2-w3o Рік тому

    Question, I have two Data Types:
    1. Writer
    2. Books
    On my Writer Data type, I have the following fields:
    1. Name - Field Type (text)
    On my Books Data type, I have the following fields:
    1. Book-Name - Field Type (text)
    2. Author - Feld Type (Writer)
    Is it possible to auto populate the "Author" field in my Books Data Type, when I populate the "Name" field in the Writer Data Type?

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому

      Yes, this is definitely possible. You'll just need to create a workflow with a few steps in it:
      Step 1: Run a workflow to 'create a thing'. That thing should be a writer
      Step 2: Add another step in that workflow to create another thing. This time, you'll want to create a new book
      When you store the data for the 'author' field, you can referene the 'result of step 1 in your workflow' which is your author
      This will automatically connect an author to a book
      Hope this helps!

    • @Amara_plays_MM2-w3o
      @Amara_plays_MM2-w3o Рік тому

      I tried this and it is working! However, what if the Writer already exist? When I tried the flow above it created a new entry for Writer again (duplicate) name.
      Is it possible to create a conditon where if the writer does not exist, create writer and the book. If the writer already exist, create only the book.

  • @abstractplanet6018
    @abstractplanet6018 2 роки тому +1

    Great video. I am wondering if an article with your suggested database structure for various types of app would work, perhaps via a paid-for link to a substack article or similar?

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      There's definitely no one-size-fits-all when it comes to building databases. I like the idea!

  • @rahulrijal2191
    @rahulrijal2191 2 роки тому +1

    Thank u for making such informative videos, I was wondering if there was a way to extract data from an uploaded image such as receipts.
    Thank u for ur response in advance

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Glad it could help!
      And I'd recommend checking the Bubble plugin library to see if there's any tools that will handle OCR (optical character recognition) or text recognition for you. This would allow you to parse text data from an image like a receipt.
      Hope this helps point you in the right direction!

    • @rahulrijal2191
      @rahulrijal2191 2 роки тому +1

      @@BuildingWithBubble thank u for ur help....ur time and ur reply

  • @fizakhatri6505
    @fizakhatri6505 Рік тому

    hey! Thank you for this video. Love your teaching skills and channel. I have learned so many things from your channel thank you for your efforts. I have question that when i create a repeating for linking database ( as following your this tutorial) (i followed each steps of this video creating data types to live demo part of this tutorial ) but when i hit the preview button, images are not showing in my repeating group, why?

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому +1

      Great to hear the content is helpful!
      And within each repeating group cell, are you only displaying images, or do you have some additional elements that are showing as well?
      I'm under the impression this might be related to a default privacy setting Bubble ads to your database. I cover this in more detail at 9:36 of this tutorial: ua-cam.com/video/sTdJ1SZYIgs/v-deo.html
      Hope this helps!

  • @MisCopilotos
    @MisCopilotos Рік тому

    Great video! Question: if you have different files and you want to give the user the possibility of organizing those files in different folders. Would you create the "folders" data fields in the same data type of the files or in a new data type referencing the files' data type?
    Thanks!

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому +1

      Great question. I'd personally just create a connection directly between both the folders and files data type.
      Under your 'files' data type, you could reference which folder it should be stored within.
      Hope this helps!

    • @MisCopilotos
      @MisCopilotos Рік тому

      Thanks@@BuildingWithBubble. I'll do that.

  • @kaushalp9128
    @kaushalp9128 2 роки тому +1

    Hi sir,
    Solve the problem for Add to cart
    how to increase and decrease the number of items in cart icon in the bubble.iio

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Sure thing, I'd be happy to add this to my list of tutorials 👌

  • @LoneLeagle
    @LoneLeagle 2 роки тому +1

    Keep the clone & database videos coming, bro. I'm about to start learning the SQL programming language, so copying your database designs on clones of popular apps with PostgreSQL & MySQL will be good practice for me. I might 1st try to see if it's possible to clone the bubble SQL databases with the Firebase no SQL database too.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +2

      Will do 😎
      I found SQL relatively straightforward to learn after using Bubble. The process of performing a search through your database for a repeating group data source mimics the same experience as writing SQL queries.

    • @LoneLeagle
      @LoneLeagle 2 роки тому +1

      @@BuildingWithBubble It seems like the actual code is easy, so the hard part might be the design part, which is no different from a visual SQL database like bubble, so I should learn the code part within days.

  • @brunoamaral3091
    @brunoamaral3091 2 роки тому

    Hi, great video. I work in a factory and want to have a website to manage my production data, quantity produced, sku, register capacity, clients, sales. Currently I have a VBA application in excel that does all smoothly but I wanted to migrate all this to an online platform. Can I do this with Bubble?
    The landing page will be just a login screen as all data should be only accessed by the company users. Basically the software just need to have forms for CRUD and then present this data in dashboards. I don’t need any payment connection or other addins.
    Would be nice if it could work in mobile as well.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Yes, this is definitely possible with Bubble. Bubble is the perfect tool for any CRUD applications 👌

  • @learningstuff5679
    @learningstuff5679 Рік тому +1

    thank you. subscribed

  • @Vectorveen
    @Vectorveen Рік тому

    Can I create a DB and make it customizable by each user individually?

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому

      Great question. You can create a series of data fields under your user data type, then only store relevant information for specific users.

  • @r4lfxd
    @r4lfxd Рік тому

    Hi, not sure if Im not late to ask, but is there any downside to go too "granular" with this? In a way where performance will be impacted? My database structure is robust as it is and as I'm planning this out after watching this, it seems like a mess.

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому +1

      Great question. One thing I'd try to avoid doing is storing duplicates of data fields. It's fine to create a granular database, but you don't want to store twice the amount of data for some fields that cross over.

    • @r4lfxd
      @r4lfxd Рік тому

      @@BuildingWithBubble Gotcha!
      Also, I have some knowledge of Object Oriented programing, am I fine to think of the Post details references as calling on an object (like Post1.GetImage)? Or would that create problem for me down the line?

  • @krzysztofczapla8588
    @krzysztofczapla8588 Рік тому

    Hello
    When I am adding my photos I cant make OG-post = current cell's post (dont have any current option)

    • @BuildingWithBubble
      @BuildingWithBubble  Рік тому +1

      Happy to help. Can you just double-check that your picture uploader element sits within your first repeating group cell.
      If you have this positioned outside of the cell, it won't be able to reference the 'current cell's post'.
      Let me know if this does the trick.

    • @krzysztofczapla8588
      @krzysztofczapla8588 Рік тому

      @@BuildingWithBubble thanks 🙏🏻 I will check and let you know

  • @lemoneyd_
    @lemoneyd_ 2 роки тому +1

    Hey man, thanks for your videos! I just want to ask, in my sign up page, I already asked for the user's first and last name. How can I fetch that info so that it will automatically be loaded when the user creates his/her profile? Thank you!

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +1

      Happy to help. Once a user has registered an account, you can add a text element onto any page, then select the 'insert dynamic data option'.
      From here, you can choose to display the 'current users X (X being whatever field you'd like).
      Hope this helps!

    • @lemoneyd_
      @lemoneyd_ 2 роки тому

      @@BuildingWithBubble Thanks for your reply. What I actually want to happen is, once they click the "sign up button" it will redirect them to a setting page just like what you did. Where in they can continue adding some of their info, like username, bio, etc. And also their first name and last name (which were asked also in the sign up pop up page) so I want these info to pre loaded to the settings page.

    • @lemoneyd_
      @lemoneyd_ 2 роки тому

      @@BuildingWithBubble I actually choose input element instead of text element on my setting page

    • @lemoneyd_
      @lemoneyd_ 2 роки тому

      I got it already man. I should have added another field to store first name/last name on the Sign the user up workflow. Thanks!

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      @@lemoneyd_ Glad to hear you got there in the end 👍

  • @peoplac
    @peoplac 3 місяці тому

    hey there please how do we create a sticky group like that on instragram's nav bar on a larger screen

    • @BuildingWithBubble
      @BuildingWithBubble  2 місяці тому

      I'd recommend checking out the floating group element in Bubble. This will help create what you're looking for

  • @Bibin_Babz
    @Bibin_Babz 7 місяців тому

    How do i store Image in one datatype and rest of the data in another datatype but get a single row of data

    • @BuildingWithBubble
      @BuildingWithBubble  7 місяців тому

      Good question. In Bubble, you can link different data types together. This allows you to store everything in one row.
      To do this, just create a data field and set the type of content to be the data type of the first data type.
      Hope this helps.

  • @AhmedKhodir-novyPro
    @AhmedKhodir-novyPro 2 роки тому

    is it better to make the likes as a list of users or a seperate datatype that is linked back to the post "from a performance point of view"?

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Great question. If you're truly looking to build for scale and not just an MVP (like most of my tutorials cover), I'd personally create the likes as a separate data type that links back to a post.
      On the post data type, I'd also create a data field called 'like count' that stores a numerical value. Whenever a new like entry is created in your database, I'd +1 to this numerical field so you can easily list this static number on a post. If a user was to then view who actually liked the post, you could reference the separate data type and display a list of all those users.
      I should also just point out that this is my personal opinion. There's always multiple ways of doing things within Bubble.
      Hope this helps!

  • @dextersl2
    @dextersl2 2 роки тому

    what do you use for your screen recordings?

  • @misse2449
    @misse2449 2 роки тому

    Hi. I've done all of the steps and then created a profile for one user and added images but it doesn't pop up in the repeating group. I've gone over it several times. What could I possibly be doing wrong? Thanks!

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +1

      Hey, happy to help. I'm under the impression that this might be caused by a privacy setting added on your user data type.
      By default, Bubble limits what data can be displayed to select users. I'd recommend watching my previous tutorial from the 7:08 mark to see how I'd recommend removing this privacy setting: ua-cam.com/video/STPV4cDcX6c/v-deo.html
      Let me know if this does the trick!

    • @misse2449
      @misse2449 2 роки тому

      @@BuildingWithBubble Thanks. I'll look.

  • @skillswiththomas
    @skillswiththomas Рік тому

    Thanks alot🎉

  • @Francotujk
    @Francotujk 2 роки тому

    Hello!
    I want to build an app where the users can post blogs. Each blog will have the text (a large paragraph).
    The data type of that paragraph can be TEXT? Or I will have some optimization problem.
    What i'm saying is that data type (text) will have A LOT of text. Will be any problems?
    Thanks!

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Hey, I'd personally recommend the following:
      1. Creating two data type called 'blog' and 'blog content'.
      2. Under the 'blog content' data type, store the long-form text as a data field called 'blog text'.
      3. From the original 'blog' data type, link each entry to a separate 'blog text' entry that can store the full content of each post.
      Let me know if this helps.

    • @Francotujk
      @Francotujk 2 роки тому

      @@BuildingWithBubble Ok, I understand.
      I will try that.
      Thanks

  • @theresacaruso4183
    @theresacaruso4183 2 роки тому

    Amazing vids!! Can you demonstrate how to make an instagram story?

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +2

      Appreciate it! And yes, I'd love to create a full tutorial on this as I've had a few requests. Be sure to keep an eye out 👀

    • @theresacaruso4183
      @theresacaruso4183 2 роки тому

      @@BuildingWithBubble awesome! will do

  • @rewiredbyadhd
    @rewiredbyadhd 2 роки тому

    Can you do a video about a Twitter clone ?🙏 Please🙏

  • @enfxacademychile
    @enfxacademychile 2 роки тому

    nice, firebase bubble example is possible?

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +1

      Yes, it's possible to integrate Bubble with Firebase. I've never done this myself, but I can always add it to my list of courses in my backlog..

  • @tittorajan
    @tittorajan 2 роки тому

    For the post and comments you have-not made any ref back to users, who do you retrieve info about the creator of the post or comment

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Great question. Whenever an entry is added in your database, Bubble will automatically register who the creator (user) is, so you won't need to add an additional field to link a comment or post back to a user. You can reference who the creator is by pulling data from the 'current comments creator'.
      Hope this helps!

  • @sivasaikumarbodapati1190
    @sivasaikumarbodapati1190 3 роки тому

    How to store social login details in our users database in bubble?

    • @BuildingWithBubble
      @BuildingWithBubble  3 роки тому +1

      I've just recorded a few tutorials about using social logins, but I'd be happy to record a dedicated video for this.
      Were there any specific social platforms you'd like to see used?

  • @AryanChaurasia10
    @AryanChaurasia10 3 роки тому

    Please build reddit clone on bubble it's hard to let user create subreddit and edit their subreddit community

    • @BuildingWithBubble
      @BuildingWithBubble  3 роки тому +1

      A Reddit clone is at the top of my list. I'll try and record this one over the Christmas break. Be sure to keep an eye out.

  • @tanmaykaushik3732
    @tanmaykaushik3732 2 роки тому

    How to add a filter.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      Are you referring to a filter to view your app data within the database itself, or a filter to customise the data that's displayed in an element like a repeating group?

  • @vincent_hall
    @vincent_hall 9 місяців тому

    Data type plural?
    Who would do that?
    It's so weird:
    Users:
    Bob Hoskins
    21 years old
    Sydney, NSW
    $30,000
    There's only 1 user per entry.

  • @LoneLeagle
    @LoneLeagle 2 роки тому

    Do you know how to code?

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому

      I can understand the basics of HTML & SQL, but I've never written a line of scripting code in my life.

    • @LoneLeagle
      @LoneLeagle 2 роки тому

      @@BuildingWithBubble I believe, I know, you would build a huge channel making tutorial videos showing people how to build features & clones of the most popular apps with code. HTML & CSS are easy, so I recon you could learn both within days & there are plenty of shortcuts. I plan on building my front end with Figma & Webflow, so I can export the code instead of coding all the HTML & CSS from scratch. You're already good at visual programming, so I recon you could get pretty good at JavaScript fundamentals within weeks, as long as you learn the practical way by focusing on concepts. You already understand variables with bubble, which is just a storage for a value with a name aka a name value pair. An array in JS is a variable with a list of values instead of only having 1 value like a variable. An object is simply a collection of name value pairs & an object can contain functions that are called methods. I know you would learn all the data stuff quick. Functions are basically created the same way you create workflows in bubble, except it's with code. JavaScript's syntax is simple, but you don't have to memorize it all as long as you understand the concepts & there are plenty of sites showing JS syntax reference.

    • @BuildingWithBubble
      @BuildingWithBubble  2 роки тому +1

      @@LoneLeagle That's a great explanation. I can't even keep track of how many times I tried to learn Javascript over the past few years.
      It could be worth another shot given what I know about visual programming now. I'd never say never!

    • @LoneLeagle
      @LoneLeagle 2 роки тому

      @@BuildingWithBubble Another option is you could learn flutter & dart to build the front & backend for web & mobile apps. And flutter compiles the code to make apps faster. Flutter is built & maintained by Google.