3 ms·

I like to have my `*_id` columns at the front, and `created_at` etc. at the back. And in the middle all the fields by descending importance. Just a personal hab

by iruoy 4y ago

I like to have my `*_id` columns at the front, and `created_at` etc. at the back. And in the middle all the fields by descending importance. Just a personal habit so I can quickly lookup data in a table.

pbz 4y ago
Exactly... You gain so much speed by having everything in the right order.
- sophacles 4y ago
  This seems pretty voodoo to me. Do you have any examples that show it?
  - pbz 4y ago
    I'm not sure how I could show if something is easier/harder to work with. Speed in this context refers to human processing speed, not database speed.
ggregoire 4y ago
I'm totally with you on this, and would love to be able to directly reorder the columns in the tables. A possible workaround is to have a view for every table (which I often read is a good practice anyway) and order the columns as you want in the views.