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

Подписаться 22 тыс.

Просмотров 38 тыс.

50% 1

In this video, I'll explain the step-by-step process of creating your own custom database within Bubble.io. From understanding how to structure different data types and data fields, through to optimizing for long-term performance - this tutorial covers everything you'll need to know.
Using a live example, I'll explain the following strategies and proceeders to help configure your own custom database:
1. How to best approach creating data types & and data fields
2. How to understand the difference between data field types (text, images, files, etc)
3. How to link different data types to connect information
4. How to optimize your database for long-term performance
5. How to create your own Instagram clone database from scratch
6. How to dynamically display data on an app page
--
About me:
In 2020, I worked directly with the Bubble team to write their 'How-to build' blog series. Each installment shared written instructions on how to recreate popular products using their no-code tool. Since the beginning of 2021, I've focussed on creating my own video series to teach no-code makers how to get the most out of Bubble's platform.
Note: This video series has no direct affiliation with Bubble themselves. This is something I've created on my own.
--
Timeline:
00:00 - Database overview
01:09 - Data types & data fields
09:15 - Data fields as lists
11:21 - Optimizing database performance
15:43 - Live demo
24:38 - Displaying data on a page
26:30 - Additional insights

Наука

Опубликовано:

9 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 94

@nikhiljain8679 Год назад

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

@BuildingWithBubble Год назад

I got you! Glad it could help 🙌

@vincent_hall 4 месяца назад

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

@BuildingWithBubble 4 месяца назад

Appreciate it 🙏 Glad it could help!

@agentesdoreino3928 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.

@sirajraj9412 4 месяца назад

Entire RU-vid 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 4 месяца назад

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

@2strokeorchoke496 Год назад

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

@BuildingWithBubble Год назад

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

@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 Год назад

@@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.

@AW-pm7tr 2 года назад

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

@BuildingWithBubble 2 года назад

Awesome to hear the content is helpful 🙌

@orcanmehmet Год назад

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

@BuildingWithBubble Год назад

Appreciate it 🙏

@skillswiththomas 11 месяцев назад

Thanks alot🎉

@BuildingWithBubble 11 месяцев назад

I got you ✌

@learningstuff5679 11 месяцев назад

thank you. subscribed

@BuildingWithBubble 10 месяцев назад

Appreciate it 🙏

@bussenswe 2 года назад

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 2 года назад

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

@LoneLeagle 2 года назад

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 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 2 года назад

@@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.

@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 2 года назад

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 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!

@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 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!

@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 Год назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sTdJ1SZYIgs.html Hope this helps!

@abstractplanet6018 2 года назад

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 2 года назад

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

@kaushalp9128 2 года назад

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 2 года назад

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

@JoaquinTorroba 10 месяцев назад

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 10 месяцев назад

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!

@JoaquinTorroba 10 месяцев назад

Thanks@@BuildingWithBubble. I'll do that.

@brunoamaral3091 Год назад

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 Год назад

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

@krzysztofczapla8588 Год назад

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

@BuildingWithBubble Год назад

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 Год назад

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

@Vectorveen Год назад

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

@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 10 месяцев назад

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 10 месяцев назад

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 10 месяцев назад

@@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?

@itzshammi 3 месяца назад

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

@BuildingWithBubble 3 месяца назад

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.

@rahulrijal2191 2 года назад

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 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 2 года назад

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

@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 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 2 года назад

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

@lemoneyd_ 2 года назад

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 2 года назад

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_ 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_ 2 года назад

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

@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 2 года назад

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

@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 2 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-STPV4cDcX6c.html Let me know if this does the trick!

@misse2449 2 года назад

@@BuildingWithBubble Thanks. I'll look.

@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 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.

@dextersl2 2 года назад

what do you use for your screen recordings?

@BuildingWithBubble 2 года назад

I use a tool called Loom.

@dextersl2 2 года назад

@@BuildingWithBubble Thanks it looks super simple.

@sivasaikumarbodapati1190 2 года назад

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

@BuildingWithBubble 2 года назад

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?

@theresacaruso4183 2 года назад

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

@BuildingWithBubble 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 2 года назад

@@BuildingWithBubble awesome! will do

@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 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!

@tanmaykaushik3732 2 года назад

How to add a filter.

@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?

@denisstaana513 Год назад

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 Год назад

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!

@denisstaana513 Год назад

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.

@rewiredbyadhd Год назад

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

@BuildingWithBubble Год назад

Happy to add it to the list 👌

@enfxacademychile 2 года назад

nice, firebase bubble example is possible?

@BuildingWithBubble 2 года назад

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..

@AryanChaurasia10 2 года назад

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

@BuildingWithBubble 2 года назад

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.

@vincent_hall 4 месяца назад

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 2 года назад

Do you know how to code?

@BuildingWithBubble 2 года назад

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

@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 2 года назад

@@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 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.