News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by hans_castorp on Monday July 11, 2022 @09:00AM (#32055589)
Well, writing a procedure that rebuilds the complete table in Postgres or Oracle is easy as well. I never needed this, but I am sure, there are some sample implementations out there.

Rebuilding the entire table doesn't seem feasible for large tables to begin with. Especially with a lot of incoming and outgoing foreign keys.

I disagree that MySQL is the most "popular".

It might be the "most used" one because of so many web hosting services included it for ages by default.

Re:Postgres 15 improves UNIQUE and NULL by jl6 on Monday July 11, 2022 @09:14AM (#32055705)
Tangential, but there are almost certainly more SQLite databases in existence than every other RDBMS put together, probably by 3 or 4 orders of magnitude.

It doesn’t support column reordering either.