Should I use separating or combining databases?

SebastianHoeing · 2024-11-08T19:40:20.975Z

Hi there,

so, I have this crazy idea to build an internal web app for a company I work for building travel itineraries and track revenue.

Thanks to Bubble, I cannot sleep calm. I have at least know, If I can do it or not.

I know the backbone is the DB structure, so I put many hours in planning this step. Also I have all the time I need, to build the app, which is an advantage.

At first, I want to build an kind of MVP with the most important function to create itineraries.

So this are the data types I plan to use:

User
Client agency
Itinerary
Content Library Item

The first three are more logical. The fourth I am struggeling with, and this is the question I wrote in the title of this post: Should I separate or combine these data type?

Separated in data types with it’s own set of data fields
Hotel
Transfer
Activity
Car Rental

Combined in one data type
Data field Type to separate: hotel, transfer, activity, car rental)

I confronted Gemini with this problem. It recomends to combine the data type and separate it by data fields.

So what do you think?

Thanks a lot for your bubbleling input
Sebastian

Ps.: If somebody is interested here, I would love to build this app in public, like a Discord Group or Youtube channel. Would love to connect not only here in the great forum. DM me if you are interested.

cmarchan · 2024-11-08T21:56:17.792Z

I understand this to be an “itinerary item” with 4 types (hotel, transfer, activity, carRental). Looks like it may be easier to keep it as your 4th dataType

Best of luck with your project!

SebastianHoeing · 2024-11-08T23:28:30.000Z

Thanks @cmarchan

Will set up the data base this weekend an give an update next week.