Wait for database port in PHP code

[qdm12]

I have seen that you use wait-for-it.sh in your Docker repository for the entrypoint.

Can we perhaps have the PHP program retry with an incresing backoff period the connection to the database before failing (e.g. 2s, 5s, 10s, 20s then fail)? That way there is no need for the container to have some custom shell script to wait for the database to be up.

As far as I know, this is also good practice although please let me know if you feel like there would be a good reason to keep things as is.

I can try doing a PR, although I'm not really familiar with PHP but I guess I can find my way 😉

[Bubka]

I have no clue how to handle such behavior as db connection is managed by laravel & doctrine.

But there is maybe another option: The wait-for-it script is used to ensure db connection is up before php artisan migrate runs. I could write a custom artisan command that check to connection before running the migrations. The command would be used in place of php artisan migrate in entrypoint.sh

[qdm12]

Would it be possible to have access to the sql database $connection somewhere? That way you could call $connection->ping(), and use that in a for/while loop together with a sleep timer to do this. I'll look in your code later.

EDIT: Or just try running a query like SELECT 1; and see if it fails or not? 🤔
EDIT 2: How about https://www.php.net/manual/en/function.mysql-ping.php ?

[Bubka]

I wrote an artisan command to check if the connection is established, Laravel provides the DB::Connection()->GetDatabaseName() function which is very handy for that. But given #39 I guess it becomes useless.

[qdm12]

Oh yeah good point, oops... Well it might get useful if one day someone wants to use something else than sqlite 😉 Nice job!!