Re:SQLite the only database you will ever need in most cases
by rakoo on Thursday February 16, 2023 @01:20PM
(#34823028)
> (Nearly) zero down time is a common requirement.
Are we still talking about small to medium web apps ? I'm sorry but if HN goes down things will be OK. In fact, there is a very large majority of services that can go down go down and things will still be OK.
(Nearly) zero down time is a common requirement. Can a live backup be made while transactions are in progress? That appears to be the case. What about schema changes? Can columns or indexes be added without interfering with access to the tables in question? And so on.