PHP todo app database setup question

+--------+----------+-------------+
| userid | username |  password   |
+--------+----------+-------------+
|      1 | md       | [hash here] |
|      2 | jochem   | [hash here] |
+--------+----------+-------------+

+--------+----------+-------------+
| userid | username |  password   |
+--------+----------+-------------+
|      1 | md       | [hash here] |
|      2 | jochem   | [hash here] |
+--------+----------+-------------+

+--------+--------+-------------------+-------+
| taskid | userid |    description    | done  |
+--------+--------+-------------------+-------+
|      1 |      1 | Make an app       | FALSE |
|      2 |      1 | Do something else | FALSE |
+--------+--------+-------------------+-------+

+--------+--------+-------------------+-------+
| taskid | userid |    description    | done  |
+--------+--------+-------------------+-------+
|      1 |      1 | Make an app       | FALSE |
|      2 |      1 | Do something else | FALSE |
+--------+--------+-------------------+-------+

$create = !file_exists(...sqlite3);
$pdo = new pdo(...);

if($create) {
  $pdo->query(file_get_contents(...sql));
}

$create = !file_exists(...sqlite3);
$pdo = new pdo(...);

if($create) {
  $pdo->query(file_get_contents(...sql));
}

CREATE TABLE users (
    user_id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    password TEXT NOT NULL
);

CREATE TABLE users (
    user_id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    password TEXT NOT NULL
);

CREATE TABLE users (
    username TEXT NOT NULL,
    password TEXT NOT NULL
);

CREATE TABLE users (
    username TEXT NOT NULL,
    password TEXT NOT NULL
);

QLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users ( username TEXT NOT NULL, password TEXT NOT NULL);
sqlite> CREATE TABLE tasks ( taskid INTEGER PRIMARY KEY AUTOINCREMENT, rowid INTEGER, description TEXT, done BOOLEAN );

QLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users ( username TEXT NOT NULL, password TEXT NOT NULL);
sqlite> CREATE TABLE tasks ( taskid INTEGER PRIMARY KEY AUTOINCREMENT, rowid INTEGER, description TEXT, done BOOLEAN );

[md89@darknet database]$ sqlite3 todoDB.sqlite3
SQLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password NOT NULL);
sqlite> CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN);
sqlite> .exit
[md89@darknet database]$ 

[md89@darknet database]$ sqlite3 todoDB.sqlite3
SQLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password NOT NULL);
sqlite> CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN);
sqlite> .exit
[md89@darknet database]$ 

CREATE TABLE users (userid INTEGER UNSIGNED PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password NOT NULL);

CREATE TABLE users (userid INTEGER UNSIGNED PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password NOT NULL);

CREATE TABLE users (userid UNSIGNED BIG INT PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL); 

CREATE TABLE users (userid UNSIGNED BIG INT PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL); 

CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN);

CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN);

Each column in an SQLite 3 database is assigned one of the following type affinities:

    TEXT
    NUMERIC
    INTEGER
    REAL
    BLOB

Each column in an SQLite 3 database is assigned one of the following type affinities:

    TEXT
    NUMERIC
    INTEGER
    REAL
    BLOB

[md89@darknet database]$ sqlite3 todoDB.sqlite3
SQLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL);
sqlite> CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN, FOREIGN KEY(userid) REFERENCES users(userid)); 
sqlite> .exit

[md89@darknet database]$ sqlite3 todoDB.sqlite3
SQLite version 3.43.2 2023-10-10 12:14:04
Enter ".help" for usage hints.
sqlite> CREATE TABLE users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL);
sqlite> CREATE TABLE tasks (taskid INTEGER PRIMARY KEY AUTOINCREMENT, userid INTEGER NOT NULL, description TEXT, done BOOLEAN, FOREIGN KEY(userid) REFERENCES users(userid)); 
sqlite> .exit

<?php

    namespace models;

    class User {
        public $username;
        public $password;

        public function __construct($username, $password)
        {
            $this->username = $username;
            $this->password = $password;
        }
    }

<?php

    namespace models;

    class User {
        public $username;
        public $password;

        public function __construct($username, $password)
        {
            $this->username = $username;
            $this->password = $password;
        }
    }

<?php

    namespace models;

    class Task
    {
        public $description;
        protected $done;

        public function isDone() {
            return $this->done;
        }

        public function done() {
            $this->done = true;
        }
    }

<?php

    namespace models;

    class Task
    {
        public $description;
        protected $done;

        public function isDone() {
            return $this->done;
        }

        public function done() {
            $this->done = true;
        }
    }

public function __construct(
  public string $username,
  public string $password,
) {}

public function __construct(
  public string $username,
  public string $password,
) {}

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['REQUEST_URI'], $_SERVER['PATH_INFO']), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['REQUEST_URI'], $_SERVER['PATH_INFO']), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['PATH_INFO'] ?? $_SERVER['REQUEST_URI'] ?? "/", PHP_URL_PATH), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

    namespace helpers;

    class Request {
        public static function uri() {
            return trim(
                parse_url($_SERVER['PATH_INFO'] ?? $_SERVER['REQUEST_URI'] ?? "/", PHP_URL_PATH), "/"
            );
        }

        public static function method() {
            return $_SERVER['REQUEST_METHOD'];
        }
    }

<?php

namespace database;

require '../Config.php'; 


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:" . Config::PATH_TO_SQLITE);
            }

            return $this->pdo;
          }
    }

<?php

namespace database;

require '../Config.php'; 


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:" . Config::PATH_TO_SQLITE);
            }

            return $this->pdo;
          }
    }

<?php

    namespace App;

    class Config {
        const PATH_TO_SQLITE = './database/todoDB.sqlite3';
    }

<?php

    namespace App;

    class Config {
        const PATH_TO_SQLITE = './database/todoDB.sqlite3';
    }

<?php

    namespace App;

    class Config {
        const PATH_TO_SQLITE = '../app/database/todoDB.sqlite3';


    }

<?php

    namespace App;

    class Config {
        const PATH_TO_SQLITE = '../app/database/todoDB.sqlite3';


    }

<?php

namespace database;

require '../Config.php'; 


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:" . App/Config::PATH_TO_SQLITE);
            }

            return $this->pdo;
          }
    }

<?php

namespace database;

require '../Config.php'; 


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:" . App/Config::PATH_TO_SQLITE);
            }

            return $this->pdo;
          }
    }

<?php

namespace database;


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite://todoDB.sqlite3");
            }

            return $this->pdo;
          }
    }

<?php

namespace database;


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite://todoDB.sqlite3");
            }

            return $this->pdo;
          }
    }

md89@darknet PHPTodoApp]$ composer require env/dotenv
./composer.json has been created
Running composer update env/dotenv
Loading composer repositories with package information
Updating dependencies
Lock file operations: 1 install, 0 updates, 0 removals
  - Locking env/dotenv (v2.0.0)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 1 install, 0 updates, 0 removals
  - Downloading env/dotenv (v2.0.0)
  - Installing env/dotenv (v2.0.0): Extracting archive
Generating autoload files
No security vulnerability advisories found.
Using version ^2.0 for env/dotenv
[md89@darknet PHPTodoApp]$ 

md89@darknet PHPTodoApp]$ composer require env/dotenv
./composer.json has been created
Running composer update env/dotenv
Loading composer repositories with package information
Updating dependencies
Lock file operations: 1 install, 0 updates, 0 removals
  - Locking env/dotenv (v2.0.0)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 1 install, 0 updates, 0 removals
  - Downloading env/dotenv (v2.0.0)
  - Installing env/dotenv (v2.0.0): Extracting archive
Generating autoload files
No security vulnerability advisories found.
Using version ^2.0 for env/dotenv
[md89@darknet PHPTodoApp]$ 

<?php
var_dump(parse_ini_file('.env', false, INI_SCANNER_RAW));

<?php
var_dump(parse_ini_file('.env', false, INI_SCANNER_RAW));

PDO_DSN="sqlite3://db.sqlite3"

PDO_DSN="sqlite3://db.sqlite3"

define('ENV', \Env\Dotenv::toArray(
  path: '.env',
  strict: false,
));

define('ENV', \Env\Dotenv::toArray(
  path: '.env',
  strict: false,
));

PDO_DB = "sqlite3://app/database/todoDB.sqlite3"

PDO_DB = "sqlite3://app/database/todoDB.sqlite3"

<?php
   
   require __DIR__ . "/vendor/autoload.php";

<?php
   
   require __DIR__ . "/vendor/autoload.php";

    "autoload": {
        "psr-4": {"Acme\\": "class/"}
    }

    "autoload": {
        "psr-4": {"Acme\\": "class/"}
    }

{
    "require": {
        "env/dotenv": "^2.0"
    },

    "autoload" : {
        "psr-4": {"Acme\\": "class/"}
    }
}

{
    "require": {
        "env/dotenv": "^2.0"
    },

    "autoload" : {
        "psr-4": {"Acme\\": "class/"}
    }
}

<?php

namespace database;


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:/todoDB.sqlite3");
            }

            return $this->pdo;
          }
    }

<?php

namespace database;


    class SQLConnection {
        /**
         * PDO instance
         * @var type
         */

         private $pdo;

         /**
          * return pdo connection to sqlite
          * @return \PDO
          */
          public function connect() {
            if ($this->pdo == null) {
                $this->pdo = new \PDO("sqlite:/todoDB.sqlite3");
            }

            return $this->pdo;
          }
    }