Build a User Management App with Vue 3

This tutorial demonstrates how to build a basic user management app. The app authenticates and identifies the user, stores their profile information in the database, and allows the user to log in, update their profile details, and upload a profile photo. The app uses:

• Zuvo Database - a Postgres database for storing your user data and Row Level Security so data is protected and users can only access their own information.
• Zuvo Auth - allow users to sign up and log in.
• Zuvo Storage - allow users to upload a profile photo.

Project setup

Before you start building you need to set up the Database and API. You can do this by starting a new Project in Zuvo and then creating a "schema" inside the database.

Create a project

1. Create a new project in the Zuvo Studio.
2. Enter your project details.
3. Wait for the new database to launch.

Set up the database schema

Now set up the database schema. You can use the "User Management Starter" quickstart in the SQL Editor, or you can copy/paste the SQL from below and run it.

supabase migration new user_management_starter

Building the app

Start building the Vue 3 app from scratch.

Initialize a Vue 3 app

This guide uses Vite with Vue 3 Template to initialize an app called supabase-vue-3:

# npm 6.x
npm create vite@latest supabase-vue-3 --template vue

# npm 7+, extra double-dash is needed:
npm create vite@latest supabase-vue-3 -- --template vue

cd supabase-vue-3

Then install the only additional dependency: supabase-js

npm install @supabase/supabase-js

And finally save the environment variables in a .env file, you need the API URL and the key that you copied earlier.

With the API credentials in place, create an src/supabase.js helper file to initialize the Zuvo client. These variables are exposed on the browser, and that's fine since you have Row Level Security enabled on the Database.

Code sample: see project quickstart in Zuvo Studio.

App styling (optional)

An optional step is to update the CSS file src/style.css to make the app look better. You can find the full contents of this file in the example repository.

Set up a login component

Set up an src/components/Auth.vue component to manage to add Magic Links as an option, so users can sign in with their email without using passwords.

Code sample: see project quickstart in Zuvo Studio.

Account page

After a user signs in, allow them to edit their profile details and manage their account. Create a new src/components/Account.vue component to handle this.

Code sample: see project quickstart in Zuvo Studio.

Profile photos

Next, add a way for users to upload a profile photo. Zuvo configures every project with Storage for managing large files like photos and videos.

Create an upload widget

Create a new src/components/Avatar.vue component that allows users to upload profile photos:

Code sample: see project quickstart in Zuvo Studio.

Update the Account component

With the Avatar component created, update src/components/Account.vue to include it:

Code sample: see project quickstart in Zuvo Studio.

Launch!

With all the components in place, update App.vue:

Code sample: see project quickstart in Zuvo Studio.

Once that's done, run this in a terminal window:

npm run dev

And then open the browser to localhost:5173 and you should see the completed app.

At this stage you have a fully functional application!