In this Perl programming tutorial, we will explore how to connect to a database using the DBIx schema classes we generated in the previous video, and we'll also have a first look at how to fetch data from a database via DBIx ResultSet.
Chapters:
00:00 Intro
00:00 Changing schema namespace
01:15 Fixing database password error
02:10 Connecting to database via DBIx
04:05 Fetching data via DBIx ResultSet
SQL to fix password error:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Docs:
https://metacpan.org/pod/DBIx::Class
https://metacpan.org/pod/DBIx::Class::Row
https://metacpan.org/pod/DBIx::Class::ResultSet
https://metacpan.org/pod/DBIx::Class::Schema::Loader
Tags:
#Perl #PerlProgramming #CodingInPerl #PerlDevelopment