Need some advice on making an API with axum and SQLx


I am currently working on a simple API that should implement user authentication and allow the user to send a JSON payload to be stored in postgres via sqlx.

Currently thinking of creating a table of the form

| id | username | hash password | payload |
|uuid | varchar | varchar | jsonb |

Is this appropriate? Any advice or ideas would be much appreciated.


If you only need to store a single payload per user that's fine. If there may be multiple payloads for a single user you probably want to use another table

Thanks for the advice.

This topic was automatically closed 90 days after the last reply. We invite you to open a new topic if you have further questions or comments.