[DiscordArchive] Nothing related with instances and instance lockouts?
[DiscordArchive] Nothing related with instances and instance lockouts?
Archived author: chipzz • Posted: 2024-02-18T21:19:45.147000+00:00
Original source
does it actually have tangible benefits?
Archived author: chipzz • Posted: 2024-02-18T21:19:57.599000+00:00
Original source
I can see LISTEN/ NOTIFY as a potential benefit
Archived author: chipzz • Posted: 2024-02-18T21:20:21.995000+00:00
Original source
It may open up a path to a multi-server setup
Archived author: Tea • Posted: 2024-02-18T21:20:26.928000+00:00
Original source
transactional alter table in autoupdater
Archived author: chipzz • Posted: 2024-02-18T21:20:41.301000+00:00
Original source
but that would require substantial work to take advantage of
Archived author: chipzz • Posted: 2024-02-18T21:21:30.670000+00:00
Original source
Is that enough benefit to warrant 1) the additional setup cost and 2) people having to migrate their existing mysql db to postgres?
Archived author: Tea • Posted: 2024-02-18T21:21:38.829000+00:00
Original source
no
Archived author: chipzz • Posted: 2024-02-18T21:21:46.752000+00:00
Original source
Because migrating would not be a walk in the park
Archived author: chipzz • Posted: 2024-02-18T21:22:21.741000+00:00
Original source
I would say LISTEN/ NOTIFY would be a much better reason, but that requires work and redesign
Archived author: chipzz • Posted: 2024-02-18T21:37:04.612000+00:00
Original source
<@1050098945650606090> anyway, while I agree with you in principle that postgres is the superior solution (there's no argument there), as illustrated by the fact that I asked the same question ~5 years ago (and gave you the link to that), you also have to be realistic about the pros and cons of such migration