4 ms·
Migrations are quite highly prioritized in PostgreSQL. PostgreSQL has the by far best migration support of any database I have worked with. There is of course a
by jeltz 5y ago
Migrations are quite highly prioritized in PostgreSQL. PostgreSQL has the by far best migration support of any database I have worked with. There is of course a lot of work left to do but that is true for many other areas in PostgreSQL.
Also I can't agree at all with "nobody coded it", patches in this area generally welcome. My first real patch for PostgreSQL was about improving migrations. And there has been talk about several of the ideas you propose, but nobody is working on any of them right now. So I mostly think it is a lack of resources in general.
- oauea 5y agoDDL migrations are amazing. Migrations between different postgres versions not so much.
- skrebbel 5y agoSorry, I didn't mean offense. What I meant with "nobody coded it" is that the migration DX features that don't exist yet, likely don't exist simply because they haven't been made yet (and not because eg they're architecturally impossible or because the postgres team are stupid or sth). Its hard to complain about OSS without attacking the creators, I tried to do that right buy clearly I failed nevertheless :-) Thanks for your contributions!
- nix23 5y ago>Sorry, I didn't mean offense. Don't be a SJP, you have the right to offend someone when he talks bs.
- burnished 5y agoWhat does SJP mean?
- deleted 5y ago[deleted]
- CRConrad 5y ago"Social Justice" something, probably, like in "SJW" = "Social Justice Warrior". Some people see politeness or compassion as weakness, and ttherefore use terms acknowledging it as pejoratives. The funny thing is, they think this makes objects of derision of their targets, and don't realise that it's themselves it does so.
- burnished 5y agoAh, I suppose that makes sense. Its weird to me how 'Social Justice Warrior' is derogatory.. because it puts you against people fighting for justice. I get the mind games (I think) you have to play to arrive at the conclusion that SJW is a good insult but its got this "are we the baddies?" energy, to me.
- nix23 5y ago> far best migration support of any database I have worked with BS, have you never worked with mysql or sqlite?
- dijit 5y agoMySQL migrations are beyond a joke. It’s absolutely impossible that you’re not trolling with such a statement.
- nix23 5y agoCopy/hardlink the data-files and start the new engine instead have to make a dump and import it? It's a joke that you have to make a offline dump and import for upgrades with pgsql.
- aynyc 5y agoI love postgresql, as long as I don’t have to do upgrade. I have yet to see a successful zero downtime upgrade. That being said, other databases aren’t that much better. Maybe except SQLite.