PostgreSQL CRUD

Build the five routes of a products API on top of a PostgreSQL database. You will keep the connection URL in an ENV node, describe a products table with a Schema node, then create one flow per route — list, create, get, update and delete — each made of an API Endpoint, an ORM node and a Response. Run the flows in the debugger and inspect the backend code Fimaflow generates.

What you will build

• Store the database URL in an ENV node
• Create the products table with a Schema node
• List and create products
• Read, update and delete a product by id
• Run the flows and inspect the generated code