fix appraisals for ~>
fix sqlite to use the common settings (which fixes the dupe key constraint issue)