Create JWT Token and Authenticate using pgcrypto and pgjwt - PostgreSQL / PostgREST

Показать описание

Master the process of setting up a PostgreSQL database, configuring PostgREST APIs, and implementing a secure login flow using JWT tokens with email and password authentication. This step-by-step guide is essential for developers working with modern web technologies. By the end, you'll have a robust backend ready for any application.
Learn how to set up your database, configure APIs, and create a secure login process using email and password. This step-by-step guide will walk you through everything you need to know to get your system up and running smoothly. Perfect for developers looking to streamline their backend processes!

pgcrytpo extension
pgjwt extension
username and password authentication

#DatabaseSetup #APIDevelopment #LoginFlow #BackendDevelopment #WebSecurity #WebDevelopment #FullStack #PostgreSQL #JWTtokens #PostgREST

----------------------------------------------------------------------------------------------------------------------------------------
Welcome to The Developer Toolkit. We cover a wide range of topics, from Oracle APEX, ReactJS, SQL Developer, React Native/Expo, Game Dev, Informatica, and much more. Don't forget to hit the 'Subscribe' button and turn on notifications so you never miss our new content!

If there's a specific topic you'd like us to cover or a question you'd like answered, don't hesitate to drop us a comment. We love hearing from you!

----------------------------------------------
Previous Videos:

Links:

Check/Verify JWT Token:

pgjwt Extension GitHub:

Helps with misc questions:

PGJWT Discussion:

-------------------

0:00 What we Doing
0:11 Install pgcrypto extension
0:20 Install pgjwt extension
0:32 pgjwt approach 1
1:25 pgjwt approach 2
1:55 Setup Auth Schema in DB
3:59 Grant Permissions for PostgREST
5:01 Setup PostgREST Docker Container
5:40 Testing Final Result
7:01 Outro