Postgres Todo App
This article walks you through how you can easily set up a simple to-do app using Actix Web and SQLx with PostgresQL.
Description
This example shows how to make a simple TODO app using Actix Web and a shared Shuttle Postgres DB.
The following routes are provided:
- GET
/todos/<id>
- Get a to-do item by ID. - POST
/todos
- Create a to-do item. Takes “note” as a JSON body parameter.
You can clone the example below by running the following (you’ll need shuttle
CLI installed):
Code
Usage
Once you’ve cloned the example, try launching it locally using shuttle run
. Once you’ve verified that it runs successfully, try using cURL in a new terminal to send a POST request:
Assuming the request was successful, you’ll get back a JSON response with the ID and Note of the record you just created. If you try the following cURL command, you should be able to then retrieve the message you stored:
Interested in extending this example? Here’s as couple of ideas:
- Add update and delete routes
- Add static files to show your records
Was this page helpful?