>You do not have to learn database tuning. KubeBlocks can leverage storage and computing resources to achieve optimal database performance.
No one has ever delivered on this pipe dream.
You just get it running, hack your spaghetti and when it becomes a problem you're already assigned on another project so someone else will have to sort it out.
Just remember when you leave a pool of shit behind, one of the victims might be making a hiring decision about you at some point in the future.
People try to do their best.
If SQLite feels that performing database optimizations (such as running ANALYZE or creating new indexes) will improve the performance of future queries, then some database I/O may be done.
People say they don't need sysadmins and stuff like this is the result.
Vertical scalability limits are very soon met and can be difficult to fix post-fact.
To be clear I agree "waste money to avoid applying basic database techniques" is A Bad Thing!
At best it becomes someone else’s problem, as others here have said.