How to learn about database models and database structure

[wegetdesign]

Great share - there is a lot of value in this post

[TipLister]

appreciate your comment. Thank you!

[damiandurrant27]

This was very helpful, thank you, I am definitely struggling a bit with the database piece. Thanks!

[sdfroggatt]

@NigelG

Just remember that the “id” and “fk” parts are done for you by Bubble field types and list

I am fairly new to bubble, and looking at the database entries I have created I cannot find ID or FK (am I correct in thinking FK=Foriegn Key). I have found a Unique ID in every entry if that is one of the keys

[steveluu1123]

Thanks @boston85719 !

[cowieajc]

Hi, I am new to Bubble, and I would like to accelerate my learning. It seems that understanding how to structure databases would be a good skill to learn BEFORE learning Bubble?

In which case, what am I looking to learn? (I can write the words “structure databases” very confidently, but I really have no idea what they mean at all)

Would it be worth me taking a Udemy course, or is this something I can pick up from a 20 minute video? Directions to a good resource would be amazing!

Also, what other skills should I learn in advance / parrallel that would make my Bubble learning journey more efficient? My aim (hope?) is to eventually become at least moderately proficient at Bubble…

Many thanks!

[cmarchan]

Hello @cowieajc

Resources below for your consideration:

One of the best if not the best set of Bubble wisdom gold nuggets written so far (paid) by @petter

The Ultimate Guide to Bubble Performance - 156 pages of optimizing tips

Hey everyone, I’m very happy to announce that I’m releasing my book The Ultimate Guide to Bubble Performance today. [image] It’s a 156 page PDF available on Gumroad that dives deeply into the hard-earned lessons I’ve learned over five years of full-time Bubbling, focusing on: how to determine whether Bubble is the right tool for your project: the pros, cons and limitations from a performance perspective how to set up your app to load pages, process workflows and edit database records at ma…

All other ones are non-paid:

Alternative approach to the Bubble’s recent tutorials for list of things

Performance Q&A guide

So some overall guidelines. Note that these kinds of guidelines definitely have a sell-by date, since we’re always trying to optimize slow stuff, but here are some of the big performance levers: The more data a search fetches, the longer it takes. That probably sounds pretty basic, but we routinely see pages that fetch thousands of data items on page load. Or, we sometimes see searches that only fetch a few things – but each thing has KBs or MBs of text data stored in its field. Bubble …

RG vs "Search for" (performance questions)

@rpetribu The conventional wisdom after much time learning from knowledgeable folks in this forum (my understanding of it). And through my own experience building apps is to: build light objects minimize list fields (only when less than 100 entries), only use them purposefully relate objects indirectly but both ways when necessary preload searches feed from preloaded searches avoid inflow searches (… hence preloading them) mnimize back and forths between client and server use custom events ex…

Good database design in Bubble

How to Configure Database in Bubble (old)

[J805]

Bubble also just came out with this last month:

https://manual.bubble.io/help-guides/working-with-data/guides-setting-up-your-database-by-app-type

It’s a free resource of different types of databases.

Hope that helps!

@j805 www.NoCodeMinute.com

For All Your No-Code Education Needs:

• One-on-One Coaching

• eLearning Hub Now FREE Access Too!

• Video Tutorials

• No-Code Blog

• Subscribe to Free Videos on YouTube

[cowieajc]

Thanks, this is much appreciated! I look forward to chunky reading