sqlpage--sqlpage/examples/todo application (PostgreSQL)/README.md

Todo app with SQLPage

This is a simple todo app implemented with SQLPage. It uses a PostgreSQL database to store the todo items.

It is meant as an illustrative example of how to use SQLPage to create a simple CRUD application. See the SQLite version for a more detailed explanation of the structure of the application.

Differences from the SQLite version

• URL parameters that contain numeric identifiers are cast to integers using the ::int operator
• the printf function is replaced with the format function
• primary keys are generated using the serial type
• dates and times are formatted using the to_char function
• the INSERT OR REPLACE statement is replaced with the ON CONFLICT clause