First, check your .env file, specifically the DB_HOST and DB_PORT variables, which must be set to

DB_HOST=127.0.0.1
DB_PORT=5434

If you are developing locally and have commented out the app section in docker-compose.yaml, don’t forget to change the APP_URL value to

APP_URL=http://localhost:8000

Clear the configuration cache

php artisan config:clear

To verify the database connection, try running the migration command to populate the database structure

php artisan migrate

If everything went well, Adminer will be available at http://localhost:8080. Log in using the credentials from the .env file. Make sure to select PostgreSQL as the connection type and set the host to db. Use the values from DB_USERNAME, DB_PASSWORD, and DB_DATABASE for the username, password, and database name. After logging in, you should see the tables created by the migration.

For local development, we usually don’t need to work with real data. Therefore, seeders have been added to the application to populate the database with fake data for testing purposes. Note: These features are not available on the production server. To populate the database, run the following command:

php artisan db:seed

During development, it’s common we sometimes need to empty and populate the database with a new data. This can be easily done with the following command:

php artisan migrate:refresh && php artisan db:seed

Now, you can start your application with the command

composer run dev

If everything went well, the application will be available at http://localhost:8000. The database seeding will create an admin user with the following credentials

• email: admin@molmedb.cz
• password: admin

And that’s it!