Deploy Laravel application with database to Heroku

Hi and thanks, this worked like a charm in laravel 7. just a quick note in database.php I changed only the default cnnection to pgsql and added DB_DATABASE as env variable in heroku dashboard. thanks again!

Thanks for sharing this 🤝, but instead of doing this

On your laravel app go to config/database.php file, and put this code on the top.

$DATABASE_URL=parse_url(‘DATABASE_URL’);
Change DATABASE_URL to the url on your heroku config.

Why not add them to environment variable on Heroku, I guess that much better and neater. It works for me though ☺️.

Thanks for this tutorial. It helped me a lot for my first deployment !

Some things to note :

• with mySQL, it's free, even if heroku require to enter your credit card (no charge at all).
• don't forget to go in your database Dashboard (in Heroku, click on your addon) and fill your .env with the correct values of host/user... For the password, put it in your heroku config var, so no one can catch it. And do the same in your database.php

Hey,

When I run the migration command

heroku run php artisan migrate

I get the following error:

In Connection.php line 671:

SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4" (SQL: select * from information_schema.ta

bles where table_schema = public and table_name = migrations and table_type

= 'BASE TABLE')

In PostgresConnector.php line 68:

SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4"

Build Failed
show this message-
There are no commands defined in the "ide-helper" namespace.

   Script @php artisan ide-helper:generate handling the post-autoload-dump event returned with error code 1

! WARNING: A post-autoload-dump script terminated with an error
! ERROR: Dependency installation failed!
!

! The 'composer install' process failed with an error. The cause
! may be the download or installation of packages, or a pre- or
! post-install hook (e.g. a 'post-install-cmd' item in 'scripts')
! in your 'composer.json'.
!

! Typical error cases are out-of-date or missing parts of code,
! timeouts when making external connections, or memory limits.
!

! Check the above error output closely to determine the cause of
! the problem, ensure the code you're pushing is functioning
! properly, and that all local changes are committed correctly.
!

! For more information on builds for PHP on Heroku, refer to
! devcenter.heroku.com/articles/php-...
!

! REMINDER: the following warnings were emitted during the build;
! check the details above, as they may be related to this error:
! - A post-autoload-dump script terminated with an error
! Push rejected, failed to compile PHP app.
! Push failed

Thank you for the tutor. When I tried the "git push heroku master" command. This error always appears.

Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
In Connection.php line 671:
SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4" (SQL: select * from "products" where "pro

ducts"."deleted_at" is null limit 8) In PostgresConnector.php line 68:

SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4"

Nice article, straightforward and easy to understand.
I also suggest to watch this video as well: Deploy Laravel App on Heroku

Thanks but I want to install npm packages.

I hope you could also create instructions for deploying two separate projects using AWS using laravel (backend) vuejs (frontend).

You're amazing! Thank u so muchh!! <3

How to populate the heroku database with data on your local device

I think you can combine Laravel and dbdesigner.id as your database designer. This can make your project readable and clear documentation.

Thanks a lot!
Create Procfile inside your main Laravel.
Where is the Profile file? In my local repo or heroku account?

Hy, This was Really Informative .... Just a quick question: Should DATABASE_URL be kept secret?