Unreal & SQL Databases - Part 5 - User Account Login
Creating a user account login system backed by a SQL database.
This example uses the unreal engine, and will focus on SQLite for ease of use, however, this particular example could use almost any SQL database, including client/server ones such as MySQL, PostgreSQL, SQLServer or Oracle, with little to no changes needed.
Chat about gamedev on Discord:
/ discord
Links
Project on Github: https://github.com/Ysgrathe/SQLiteGam...
Hashing Passwords https://www.experte.com/it-security/p...
BLAKE3 https://github.com/BLAKE3-team/BLAKE3/
Chapters
0:00 Introduction
0:20 A Word About Security
1:09 Database – A User Table
4:11 Password Hashing
6:57 Sarcastic Rant
7:42 Database Queries
7:57 Create User Query
9:06 Test Login Query
9:34 Get Account Data Query
9:58 Edit Account Query
11:26 Change Password Query
11:44 Delete Account Query
12:48 Data Access Layer
14:16 User Interface Widgets
15:33 Widget Base Class
17:37 Create Account Widget
18:57 Login Widget
19:47 User Details Widget
20:28 Edit Details Widget
21:13 Change Password Widget
21:53 Delete Account Widget
23:09 Quick & Dirty Test Setup
24:50 Quick & Dirty Demonstration
26:51 Summary