I love these! Please keep making more database design videos!
@DatabaseStar
Жыл бұрын
Thanks! Glad to hear you like them. Do you have any database design topic suggestions?
@JimRohn-u8c
Жыл бұрын
@@DatabaseStar I haven’t gotten a chance to watch all of your videos only bits and pieces cause work is crazy right now, but if you could make a video that shows how to design a Database from scratch for a new application you wanna create that would be awesome. So for example, let’s say I have to build a database for an e-commerce store which will handle payments, orders, and shipping all in house, how do we even start to design a database for an application idea we have? In the example I gave most companies handle payments and shipping through 3rd parties but I would wanna handle it all in house so the database would have to be designed differently than most, so understanding how to design a database no matter what application you plan on building would be awesome. I guess my request may overflow a bit into the business analyst realm as well but if it’s detailed enough it would be extremely valuable cause a developer at a startup has to wear multiple hats. As a new developer who wants to build applications on his own, understanding how to design a database well in the beginning is crucial because if we don’t we will either have to make difficult changes to the database design later without losing data or the business logic for the application itself will be more complicated to write.
@sobeck6900
Жыл бұрын
perhaps topic about scheduling appointments@@DatabaseStar
@CarlosRL97
Жыл бұрын
For example, an application about recycling, that allows users to exchange Different types of plastic in containers, distributed around the city, and for each exchange user can receive points that can be used later to exchange, again, for some offers from markets or any products @@DatabaseStar
@DatabaseStar
Жыл бұрын
Great ideas, thanks for the suggestions! I'll add them to my list of videos.
@CarlosRL97
Жыл бұрын
the knowledge that these videos provide is incredible, thank you!
@DatabaseStar
Жыл бұрын
Glad you like them!
@dheerajs2838
Жыл бұрын
Love your videos. Like the new tool.. but creating ref line outside tables feels weird
@DatabaseStar
Жыл бұрын
Thanks! Yeah it does feel a bit strange!
@trentcox9239
Жыл бұрын
if you get the time mate, some time spent on auditing solutions of various robustness would be absolutely awesome, its one of those things in my experience that if i go searching for an answer to this, ill get a million different solutions and get no closer to implementing something with confidence. some like to create 'god' tables that hold auditing information for the whole system, others prefer to have audit tables alongside tables that track versions of information prefixed with 'audit_' in the table name....anyway....food for thought
@DatabaseStar
Жыл бұрын
Good idea! I can create a video on that topic. I've seen some approaches to this I can use.
@thomasmabika7291
11 ай бұрын
Wonderful! Please do database design for Airbnb.
@DatabaseStar
11 ай бұрын
Thanks! That's a good idea.
@codingcambodia
Жыл бұрын
It is easy to understand. May you design a small database design for a POS system for a coffee shop?
@DatabaseStar
Жыл бұрын
Thanks! Yes I can create a video for that.
@susmantobealivebruh4238
Жыл бұрын
Love your videos been following you for some time! Can you please make for a Hotel management application! Thank you!
@DatabaseStar
Жыл бұрын
Thanks! Good idea, I think that's on my list.
@AndrulisTravel
8 ай бұрын
Great video. Couple questions: 1. ENUM vs table (for listing type: sale, rent) 2. If this listing page will have 200k properties and you wanna use filters to filter out by types, features, and price with pagination. What are the strategies for fast querying?
@DatabaseStar
8 ай бұрын
Thanks! 1. I prefer table instead of ENUM as it's more flexible and you can get the list of values easier. But ENUM can still work. I'll make a video on this in the future. 2. Generally, indexes will be the first solution to use here. You can add indexes on columns being used in the filter. If queries are still slow, there are other strategies you can use.
@AndrulisTravel
8 ай бұрын
@@DatabaseStar thanks. Maybe in the future you will have a video about a similar case, when you wanna have a search (like in listings) using multiple parameters.
@user-mf2ny2xu5z
6 ай бұрын
Got clear idea about db design for real estate. I have one question, What will be scenario for if an agent done listing, and later on he left the job. then what will be happen to the property or listing?
@DatabaseStar
6 ай бұрын
Good question. Ideally the listing and property will stay. And it could either be moved to a different agent, or the agent could be marked as inactive or their employment ended.
@michaelyao9389
Жыл бұрын
8:25. Hi. I have a qeustion. Shouldn't be a joining table between `employee_id` and `listing_id`? Why `property_id`. I think it may should be based on listing id instead of property id?
@DatabaseStar
11 ай бұрын
Hey, that's a good point. It would be better to link it to listing instead of property, in case a property is listed multiple times and different employees work on it.
@michaelyao9389
11 ай бұрын
Hi. @@DatabaseStarYeah. Thanks for the reply and confirmation. Love your videos. I leart a lot from your channel. Thank you again. :)
@tareq6364
10 ай бұрын
This is great work, but is it suitable for converting to My SQL?
@DatabaseStar
10 ай бұрын
Yeah, it can be converted to any SQL database including MySQL.
@rohitpandey832
Жыл бұрын
The content is very good as always. The new tool i feel is a distraction. Thanks for all the effort.
@DatabaseStar
Жыл бұрын
Thanks for the feedback on the new tool! Glad you like the videos too.
@3ALEGIONS
10 ай бұрын
Hi, Excellent video, I have a question, should we have 2x tables, tblUser for Public site login and tblAdminUsers for Admin site login or just one table tblUsers for both?
@DatabaseStar
10 ай бұрын
Hi, good question. I think it depends on how similar they are. Generally I would recommend using one table for both. I created a video recently on this exact topic here: kzitem.info/news/bejne/sZ1mp3iqsKZkZaA
@muhammadali7092
10 ай бұрын
Does anyone know about the website that follows this database design this helps me to understand the flow of the project to create
@DatabaseStar
10 ай бұрын
I don’t know if there are any that follow this exact design. But there are many that use the same concepts, such as real estate companies or property management companies.
Пікірлер: 41