search

justinkekeocha / udemy

Udemy clone using VITL stack: Vue, Inertia.JS, TailwindCSS and Laravel
https://udemy.justinkekeocha.com
2 stars 0 forks source link

Use a `text` data type for the `description` column in `courses` table #3

Open newtonjob opened 1 year ago

newtonjob commented 1 year ago

https://github.com/justinkekeocha/udemy/blob/fdc6555aeeb4da81cfde8a64064899905aeb411f/database/migrations/2023_06_01_160452_create_courses_table.php#L18

A description column typically contains some long text. In MySQL, it is typical to use a TEXT column for such field instead of a VARCHAR.

justinkekeocha commented 1 year ago

Okay I will change that.

Due to indexing and better performance of VARCHAR,I decided to use string most times. https://www.scaler.com/topics/varchar-vs-text-mysql/

But I will change that. Thanks for the correction