Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


This 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


If 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.


That's generally what I end up doing. It's not ideal, but it at least allows me to order the columns how I want.


MySQL also lets you control the layout of your table on disk via BTree primary storage and composite primary keys.


This seems like something that could be done client side instead. But maybe not an option for psql CLI


It is, and something an ORM can manage, but I spend a LOT of time in the psql CLI.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: