47SQL.1 - HoloCure Collabs tool, using Postgres and SQL
This time, using SQL to make the collabs tool.
Which means I first have to make a database, and tables.
Where to download Postgres and pgAdmin
https://www.postgresql.org/
https://www.pgadmin.org/
00:00 Download Postgres and pgAdmin
00:24 Looking at the CSV data-file
00:48 Create a new database
01:05 Create table through the GUI
02:50 Table SQL
03:37 Making the unlocks-table
04:59 Insert Into-method
08:13 Part 1
08:30 Show all weapon names
09:17 Show all collab names
10:24 All collabs + information
12:14 Using min on both weapon columns (bad)
12:45 Look up a collab
13:02 Variables
15:45 There's no '* but exclude these collumns'
16:47 Look up a weapon