3 ms·
I love, love, love Postgres! The one feature MySQL has that Postgres doesn't is the ability to add a new column in an arbitrary position in the table. I like my
by leftnode 5y ago
I love, love, love Postgres! The one feature MySQL has that Postgres doesn't is the ability to add a new column in an arbitrary position in the table. I like my tables to have a common "layout" and I would love to have this feature in Postgres.
- nkozyra 5y agoThis is annoying but it's not a huge hassle to duplicate/copy/rename, assuming your data is small and not sharded in some unique way
- Spivak 5y agoIf your data is tiny then within reason nothing matters, any popular database will be just fine. Where you care is precisely when your data gets big enough to be unwieldy.
- leftnode 5y agoThat's generally what I end up doing. It's not ideal, but it at least allows me to order the columns how I want.
- teaearlgraycold 5y agoThis seems like something that could be done client side instead. But maybe not an option for psql CLI
- leftnode 5y agoIt is, and something an ORM can manage, but I spend a LOT of time in the psql CLI.
- srcreigh 5y agoMySQL also lets you control the layout of your table on disk via BTree primary storage and composite primary keys.