Comment 1 for bug 1409708

5)
Use "WHERE id=:id" instead of "WHERE rowid=:id"

6) Add a database version so that your code can migrate your user database schema should it change in the future version
Example:
            db.user_version = 1 ;

7)
Why are you using a full text indexed table (notes) if you never use the MATCH feature?
Why not using a regular table?

Do you plan to add full text search? If that's the case you need the following tables notebook, notes and notes_fts

8)
Note and Notebook are not Gtk widgets they are domain classes (also called model classes).
They shouldn't be in the Widgets namespace or folder.