I was wondering how the above stated concept works.
1. Firstly, does editing a DB column automatically update the dataProvider to reflect the change?
2. If I want to save to a database, is it better to automatically save after each change or should I ask the user to press a Save button to do so? Which would be best practice if this can be established?
1. editing should automatically edit dataProvider. If you use default editing it be automatically. If you create you own itemEditor you should check it.
2. Both methods for editing can be. You can save each correction to DB. Also you can detect all changes and save them after pressing special button. The best variant is depends on the task.