Premium Only Content

Unreal & SQL Databases - Part 4 - Relational DB Primer
Getting down to the basics of setting up a new SQLite database, creating some tables, making relationships, and querying for data.
Chat about gamedev on Discord:
https://discord.gg/jjy2aJ3hj9
Links to websites:
SQLite Docs: https://www.sqlite.org/docs.html
SQLite Tutorial .net: https://www.sqlitetutorial.net/
Links to software:
DBBrowser: https://sqlitebrowser.org/
Jetbrains Rider: https://www.jetbrains.com/rider/
DBSchema: https://dbschema.com/
SQLite shell (part of the standard SQLite downloads): https://www.sqlite.org/download.html
Chapters
0:00 Introduction
0:29 Relational Databases - Your Way
1:06 Creating a SQLite Database
1:35 Naming the Project
2:01 Making a New DB file
2:21 Introducing TABLES
3:03 Making the 'Background' Table
4:03 Primary Keys (PK)
4:48 SQLite INT PK = Autonumber
5:37 Making the 'CharacterClass' Table
6:33 Relating 'CharacterClass' to 'Background'
8:45 Making the 'WeaponType' Table
9:15 One To Many Relationships
9:53 Many To Many Relationships
11:01 Relating 'WeaponType' and 'CharacterClass'
12:14 A Note About Naming Tables
13:34 SELECT Query 1
14:45 SELECT Query 2
16:46 Helpful Websites
17:12 Recap
18:53 SELECT Query 3
19:41 Relationships & Queries
20:39 Query JOINS
21:51 Dont Get Overwhelmed
22:32 What Would Be Useful to YOU?
22:57 Next Time...
-
DVR
vivafrei
3 hours agoJoey Swoll CANCELS Himself! Oprah Closing Roads for Tsunami Evacuees? Canada Can't Find Criminals?
61K19 -
1:47:35
Right Side Broadcasting Network
5 hours agoLIVE REPLAY: President Trump Delivers Remarks on Making Health Technology Great Again - 7/30/25
48.4K13 -
38:23
Members Club
1 hour ago $0.11 earnedShooter Strikes NYC, WNBA Wig Meltdown, and Sweeney’s Jeans Go Viral - MC05
2.73K2 -
33:41
The Finance Hub
4 hours ago $0.49 earnedBREAKING: NANCY PELOSI JUST GOT HIT WITH A MAJOR BOMBSHELL!!!
5.59K4 -
LIVE
LFA TV
21 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 7/30/25
1,268 watching -
2:04:14
Pop Culture Crisis
3 hours agoOprah Tsunami BACKLASH, Billie Eilish RACIST? Joey Swoll BENDS THE KNEE | Ep. 888
22.3K4 -
1:22:25
The HotSeat
2 hours agoLibs Are BIG Mad Over New Commercials and The Fed Is Just Another Political Weapon
15.4K6 -
LIVE
Film Threat
6 hours agoSAN DIEGO COMIC-CON! FANTASTIC FALL OUT FOR MARVEL | Hollywood on the Rocks
69 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 717] NEVER Apologize to The Counterculture Mob! Be You, Be True | Oprah & “Elites” God Complex
157 watching -
1:38:10
The Quartering
4 hours agoKash Patel "Discovers" Secret FBI Files On Trump, NYC Shooter New Conspiracy, Planned Parenthood
131K20