inSync Local SQL edition

This application also demonstrates how to take a picture of a contact using your webcam and store it in the SQLite database as a blob
In the "SQL in View" approach, you embed SQL statements as needed in View components.

In this example the ContactForm component has create, update, and delete methods with the appropriate embedded SQL statements to insert, update, and delete a contact in the database. This approach works for quick prototyping, but is generally a bad practice. When you mix view logic and data access logic in the same component, neither the view logic nor the data access logic is reusable: you can't reuse the view with a different way to access your data, and you can't reuse your data access logic with a different view.