Database Setup

Note: WIP. Please contact para in the Discord for corrections or missing information.

---

Here we will create the database for our development environment. We will assume that we have installed our RDBMS of choice.

• MySQL
• PostgreSQL
• SQLite

MySQL

Remark: Version 5.7+ is required.

Remark: Ensure that the pdo_mysql php extension is enabled in your php.ini.

If we have phpMyAdmin installed, we simply visit localhost/phpmyadmin in our browser of choice and create the database.

If we have installed mysql on our server, we simply create the database using the MySQL command-line client.

In our .env file, configure the following for our local database access:

DB_CONNECTION=mysql
DATABASE_URL=
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=animethemes
DB_USERNAME=root
DB_PASSWORD=
DB_SOCKET=
MYSQL_ATTR_SSL_CA=null

Where we can adjust the database, username and password to our liking.

PostgreSQL

Remark: Version 9.6+ is required.

Remark: Ensure that the pdo_pgsql php extension is enabled in your php.ini.

We simply create the database with the psql command-line tool.

In our .env file, configure the following for our local database access:

DB_CONNECTION=pgsql
DATABASE_URL=
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=animethemes
DB_USERNAME=root
DB_PASSWORD=
DB_SOCKET=
MYSQL_ATTR_SSL_CA=null

Where we can adjust the database, username and password to our liking.

SQLite

Remark: Version 3.32.0+ is required.

Remark: Ensure that the pdo_sqlite php extension is enabled in your php.ini.

We simply create the database file wherever we like.

In our .env file, configure the following for our local database access:

DB_CONNECTION=sqlite
DATABASE_URL=
DB_HOST=
DB_PORT=
DB_DATABASE=/absolute/path/to/database.sqlite
DB_USERNAME=
DB_PASSWORD=
DB_SOCKET=
MYSQL_ATTR_SSL_CA=null

.sqlite files will be ignored by git.