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...
-
2:36:47
DLDAfterDark
5 hours ago $0.35 earnedIs The Left Recruiting To KILL Conservatives? Hey Fascist, CATCH!
5.63K1 -
22:53
Jasmin Laine
1 day agoParliament ERUPTS After "WORST Decision EVER!"—Carney Left SPEECHLESS by SHOCKING Report
33.1K73 -
11:50
Mrgunsngear
1 day ago $7.44 earnedSteiner MPS Enclosed Red Dot: Better Than The ACRO P2? 🔴
34.1K17 -
1:27:55
Sarah Westall
1 day agoSelecting World Leaders: Intelligence No Longer a Prerequisite w/ Martin Armstrong
42.8K21 -
2:03:07
Badlands Media
1 day agoDevolution Power Hour Ep. 393: Synthetic Reality, and the RICO Grande Strategy
65.2K24 -
11:23:18
GritsGG
12 hours agoQuad Win Streaks!🫡 Most Wins in WORLD! 3600+
82K10 -
41:16
MattMorseTV
7 hours ago $77.29 earned🔴Antifa is PREPARING for WAR.🔴
74.7K433 -
2:55:38
cosmicvandenim
15 hours agoCOSMIC VAN DENIM | Horror Game | STOREBOUND
27.1K3 -
50:18
Side Scrollers Podcast
8 hours agoLIVE SPECIAL EVENT - Blabs SPITS on Her Ancestors by BURNING Pasta
52.3K8 -
6:18:07
putther
7 hours ago $2.26 earned⭐ Bounty Hunting on GTA Online & GTA 5 RP ❗
37.4K1