The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

MySQL

deploy

    dnf -y install mariadb-devel
    cpanm Devel::CheckLib DBI https://github.com/gooddata/DBD-MariaDB/archive/master.tar.gz

connect

    my $dbh = DBI->connect(
        qq[DBI:MariaDB:database=$db;host=$host;port=$port],
        $username,
        $password,
        {   RaiseError               => 1,
            PrintWarn                => 0,
            ShowErrorStatement       => 1,
            mariadb_auto_reconnect   => 1,
            mariadb_multi_statements => 1,
        }
    );

create table

    CREATE TABLE IF NOT EXISTS `table` (
        `id` VARCHAR(20) NOT NULL,
        PRIMARY KEY (`player_id`)
    ) DEFAULT CHARSET=utf8mb4;