Need some advice on making an API with axum and SQLx

help
1

Hi,

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.

Thanks

2

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

3

Thanks for the advice.

4

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.