REST CRUD API
A complete products API on PostgreSQL: create the table, then list, create, read, update and delete rows. Add your database URL and it runs.
Backend templatePostgreSQL · Validation · ORM31 nodes5 endpoints1
A complete products API on PostgreSQL: create the table, then list, create, read, update and delete rows. Add your database URL and it runs.
What's included
- A Setup flow that creates the products table with a Schema node
- Five routes: GET /products, POST /products, GET /products/:id, PUT /products/:id, DELETE /products/:id
- Input validation on create, rejected with a 422 before it reaches the database
- ORM nodes for every query — no SQL to write
- Set the DATABASE_URL variable in the Environment node before you run