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 !

[StandUp]

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

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)

[jaimeisaac]

Hello Nigel,
Could you help me clarify table structure for my case?
I’m trying to build a field operation webapp. My goal is to have users (Table A) send field reports (Table B) as submissions using a forms app. After that just create a pdf report for client (Table C).

Table B will be the center of the app, as I need to generate graphs with that data ,filter by user or client, populate a report.
Should i add a data fields in Table B with user and client as Table A and C data types?

Any feedback will be appreciated, sir.

Jaime

[jaimeisaac]

Nigel, i appreciate your patience , you’re right about this application is many to many because clients will login to the app to see their data too and i need a way limit access to reports that only belong to that user/client.

Thank you