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...
-
Game On!
2 hours agoSpecial Father's Day NFL Stream! Happy Father's Day Dads
1.28K -
43:20
Standpoint with Gabe Groisman
7 hours agoEp. 31. US Military Assessment of Gaza-Israel Conflict. Lt. Col. Geoffrey Corn
5.13K8 -
1:29:53
TheAlecLaceShow
16 hours agoGuests: Vivek, MTG, Roger Stone, Mike Lindell & More | Live From Detroit | The Alec Lace Show
7.25K57 -
LIVE
Major League Fishing
2 days agoLIVE Tackle Warehouse Invitationals, Stop 5, Day 2
401 watching -
7:39
Sideserf Cake Studio
1 day ago $0.01 earnedA Hyperrealistic Cake on the Ceiling?! Celebrating 6 Million Subscribers!
51K50 -
1:04:23
Squaring The Circle w/ Randall Carlson
1 day ago#008 Are Sea Levels REALLY Rising? Pt 1 - Squaring the Circle: A Randall Carlson Podcast
48.4K82 -
8:31
Film Threat
1 day agoHOUSE OF THE DRAGON SEASON 2 EPISODES 1 & 2 | Film Threat Reviews
49.8K10 -
11:31
shaneandliana
21 hours agoPossessed SLEEP WALKING Prank On My Parents *THEY FREAKED OUT*
56.8K15 -
10:30
Hack
1 day agoDIY Incubator: Using Old Watches and Polystyrene for Successful Hatching
53K17 -
19:23
Freakin' Reviews
1 day agoTesting Strange & Useful Amazon Gadgets!
55.9K16