Thanks Arpit. I have seen very exerienced people using varchar as a one-size-fits-all approach. They simply put any random number with it and it's done. In an enterprise environment, changing this using some liquibase script or any other approach not only involves lots of re-discussion but also break stuff. This topic of CHAR vs VARCHAR vs TEXT is very much important to understand and implement.

Arpit, the explanation that you provide is extremely well-designed and in-depth. Its always a treat to watch your videos. Since you dive deep into system design concepts, request you to create a solid video on SOLID principles, this would help all levels of engineers.

Hi Arpit, great video as usual. It would be great if you can create a video about the behind-the-scenes of the disk IO involved with GETting a row (all the jazz around blocks, page seeks, etc.). That would also end up emphasizing and justifying the reason why there’s an additional latency of fetching a long TEXT/VARCHAR from a different page lookup and why DBs prefer to keep their rows short. Rest, keep on making such amazing videos.

@AsliEngineering

5 ай бұрын

That is my next video. Adding it here would have made this video an hour long. Next few videos will be about Heap tables and Toast tables.

@yash_renaissance_athlete

5 ай бұрын

@@AsliEngineering Thanks a ton. Appreciate it! Will wait eagerly for the next one :) My obsidian is filled with the notes of your videos by the way 😂 Cheers!

best channel! Thank you for sharing your knowledge 🙏🏽

Great content, exactly what I wanted to know. Thank you

thanks Arpit bhai

Good comparison of the 3 data types. What about NVARCHAR?

Thanks arpit❤

We can also have index on TEXT field, can you elobrate on reason why varchar is better for quick index lookup for exactness?

@AsliEngineering

5 ай бұрын

that will be in my next couple of videos. some really interesting decisions taken by postgreSQL here.

Thanks Arpit, another great video! Just a suggestion to make videos more interestiing, 1. I think you should use white background without any lines. 2. Just use 1 or 2 types of inks. 3. Also I think writing in slides format is better because if someone wants to read on the page, its little confusing to what to look at and where to start from. Thanks again.

@AsliEngineering

5 ай бұрын

Thank you for the suggestion. I tried with typed slides, but that felt more like lecture and less like a video. Plus here I can scribble and doodle. But point taken, let me make some alterations.

Please make a video on index only scan vs index scan vs bitmap index.

I'm here from X. What a content man!!! Already subscribed. I'm in 4th year Plz guide me how should i start system design from your playlist.

@AsliEngineering

5 ай бұрын

Start with kzread.info/head/PLsdq-3Z1EPT36NJXTutvKcreetuHCr9a- and then explore other videos from other playlists. Whenever you dont understand or come across a new term. DFS.

@arpit, can you give a usecase for char? I find it hard to believe major dbs chose to implement it if there is no use case?

@whenkunda8447

5 ай бұрын

Never-mind gen AI to the rescue 😂 • Fixed-length fields: CHAR is useful when you need to store data that always has a fixed length, like an ISBN number or a credit card number. • Alignment and formatting: CHAR can help with aligning data in tables or reports, ensuring consistent spacing and formatting. • Compatibility: In some legacy systems or older databases, CHAR might be required for compatibility reasons.

@AsliEngineering

5 ай бұрын

It is a legacy column. Old systems and use cases had a requirement. Now it is not much prevalent.

@AsliEngineering

5 ай бұрын

But even these are now stored with varchar. Earlier it helped with displays without post processing

@whenkunda8447

5 ай бұрын

Thank you very much. I appreciate the response!

Hi Arpit do you have any advance course on MongoDB

@AsliEngineering

5 ай бұрын

nope. I do not have a course on MongoDB.

Good information but it would be best if the information is in hindi .

Can the promotional stuff go to the end

@AsliEngineering

2 ай бұрын

No. Given my videos are heavy on engineering, most people don't watch till the end. I need to promote things at the beginning.

@harshil1466

2 ай бұрын

@@AsliEngineering ahh makes sense is there any way we can get a separate paid version ? Cause this is something i always get irritated by causing me to close the video.

Arpit take some vitamin d

@AsliEngineering

5 ай бұрын

Yes. since last few months I have been doing this more often :)

@oldgangster4119

5 ай бұрын

Why?

I'm designing a new-ish schema right now and was contemplating between varchar and text. Immaculate timing!🫡

@AsliEngineering

5 ай бұрын

Right on time it seems 😅

@VedankPande

5 ай бұрын

@@AsliEngineering 🙌🙌