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...
-
LIVE
LFA TV
19 hours agoLFA TV ALL DAY STREAM - FRIDAY 7/18/25
1,330 watching -
1:21:02
vivafrei
3 hours agoLive with Vince Coglianese! Not Just the Epstein Stuff... Let's Talk About Some Trump Wins!
66.9K26 -
LIVE
Dr Disrespect
5 hours ago🔴LIVE - DR DISRESPECT - NEW AAA BATTLE ROYALE ON UNREAL ENGINE 5 #OTG #OFFTHEGRID
2,853 watching -
2:52:15
Barry Cunningham
3 hours agoWATCH LIVE: PRESIDENT TRUMP SIGNS LAWS ON CRYPTO AND ENDS NPR, PBS, & USAID!
26K16 -
44:02
The White House
3 hours agoPresident Trump Participates in a Signing Ceremony for S.1582 GENIUS Act
21.3K21 -
LIVE
LadyDesireeMusic
2 hours ago $0.04 earnedLive Piano Renditions | Make Ladies Great Again | Live Piano Requests TONS to choose from
105 watching -
4:13:45
Viss
5 hours ago🔴LIVE - Winning with Tactics & Outplay The Competition - How To With Viss!
5.69K1 -
1:09:46
Jeff Ahern
2 hours ago $0.20 earnedFriday Freak out with Jeff Ahern
12.9K7 -
LIVE
Spartan
2 hours agoSpartan - Pro Halo Player for OMiT | Scrims vs FaZe @ 4 EST + Ranked
12 watching -
1:40:47
WolfsDenBoxing
1 hour agoStreaming Fights: New Wave or Distraction
2.35K