Comment by aPoCoMiLogin

most of these is more lack of experience than the DB fault. most systems have its quirks, so you have to get used to it.