Any Database structures book / course recommended by experts for intermediate developers?

[mdburhan3]

Hello bubble experts

I am working on bubble since 1 year.
Till now i worked on multiple apps (to be precise 4) which are real time deployed live apps…

I often realise that while developing any app i mostly mess up the database design / structure
**mostly it will be fixed by my seniors & sometimes by the experts of this forum like @mikeloc @adamhholmes @Jici **

Can anybody guide me how can i improve this ?
Any recommended book for database structure design / course ?

Thanks in advance for your help

[mikeloc]

Hi there, @mdburhan3… it couldn’t hurt to start with these resources, if you haven’t seen them already.

https://manual.bubble.io/help-guides/structuring-an-application/data-structure

How to learn about database models and database structure

I feel that a lot of new users struggle with bubble, not just because there is a learning curve to the bubble platform itself, but because most are non-coders and do not have a background in database design. Personally, once I began to understand database design a bit more, it had profound impacts on how I was able to build using bubble, especially when it came to ease of manipulating data. I also feel, that a lot of new users forget about Google…that powerful search engine that can point you …

Also, if you google bubble.io database design, you will find other content, too, including videos.

Hope this helps.

Best…
Mike

[mdburhan3]

@mikeloc
Thanks

Off topic, just out of curiosity i would like to know
How did you improve your understanding of databases when you are on intermediate stage of your bubble career ? (I know you are having a lot of experience now but during initial years of your bubble)

[J805]

Hey @mdburhan3

Not sure if you saw this yet either but Bubble put many common examples in the manual as well. Check it out: Guides: Setting Up Your Database, by App Type - Bubble Docs

[mdburhan3]

@J805 Thanks a lot
I often go to bubble docs but i never saw this page…
I feel every bubble developer needs to check this out.

[mikeloc]

@mdburhan3, I’m not sure how much my understanding of databases has improved over the years, but my thinking about how to approach the data types when I start a new Bubble app has definitely evolved.

I’m sure some folks would disagree, but I think it is a waste of time to try to design every aspect of your data types before you start building a Bubble app because no matter how thorough you think you can be, the design is almost certainly going to change as you go. What I try to do is make sure I have all of the big aspects of the design covered up front. For example, does the app need to support multi-tenancy? Are there any data types that look like they will contain a large number of fields, and should I consider creating satellite data types instead of including all of the fields in one data type? Am I setting the data types up in a way that will make it easy to configure privacy rules? Should I use list fields, and if so, will the potential size of any of the lists affect performance? Etc.

Anyway, that’s just my approach… your mileage may vary.

[mdburhan3]

@mikeloc Thanks a lot for your response

@mikeloc

I think it is a waste of time to try to design every aspect of your data types before you start building a Bubble app because no matter how thorough you think you can be, the design is almost certainly going to change as you go

I am 100% agree with this

@mikeloc

should I consider creating satellite data types instead of including all of the fields in one data type

What are satellite data types ?

[mikeloc]

In a nutshell, it’s just breaking a data type that has lots of fields into multiple data types that are linked together. Here is an article about it.

[viquarahmed07]

@mdburhan3
This post helped me while starting out…

Bubble best practices: structuring your database (by AirDev)

Hi Bubblers, Wanted to share a new resource that I hope you find helpful. We at AirDev believe that Bubble will create a huge number of developers who haven’t necessarily built software before. As a result, we spend a lot of time thinking on how to train them in the best practices of building, which is especially important given how flexible Bubble is. As anyone who’s Bubbled extensively knows, there is a big gap between just building something on Bubble and building it well, using best design…

[mdburhan3]

@viquarahmed07 Thanks

[mdburhan3]

@mikeloc
Thanks a lot

How can i buy you a coffee?
You helped me lot of times…

You need to setup “Buy me a coffee” page
You almost help everyone on forum for free (You deserve some compensation).
God bless you

[viquarahmed07]

@mdburhan3

You almost help everyone on forum for free (You deserve some compensation).

@mikeloc who on earth would disagree with this …
Please setup some patreon page or one time payment …

I come regularly to forum & i know how difficult it is to help everyone (spending most of your day & including weekends)…

You & @adamhholmes definitely deserve compensation…

[jj11]

Check out www.nocodedatabases.com - there is a library of prebuild databases that you can copy and paste. Then, you can learn how those DBs were structured as they were created by professionals like myself!