Gobuffalo error "There is no connection named development defined!"

In my go project I install gobuffalo:

go get github.com/gobuffalo/pop/...

And then I run soda migrate but I got this error There is no connection named development defined!

Does anyone know what problem I am facing with?

First a quick reply, explanation below.

1. Delete the database.yml file.
2. Force soda to create the same file with the command "soda g config"
3. After that my "soda migrate" command stopped giving the error and worked. (Don't forget to put your db cofig details in the generated file in the first section (development) only)

In Detail

Actually I copied an old working directory of Go to create another one. In the new place it was not working. I think that was the problem. If still not working try installing SODA and do the above in the new place, I did that also.
https://gobuffalo.io/documentation/database/soda/
https://gobuffalo.io/documentation/database/configuration/

For me, I named the file database.yaml initially, changing the name of file to database.yml worked just fine.

Please ensure you don't have any formatting extension's available I was initially getting the same issue later resolved by 'uninstalling' prettier.

Steps I followed:

• 'soda g config' and edit your database.yml (make sure it is 'database.yml')
• I was also creating some Fizz migrations 'soda generate fizz table_name'
• Edit changes to the database.yml file (I am using Dbeaver by default it usually asks you to set user as 'postgres' and if you have any password set in order to make connection with 'postgres' you can use that same password in the password)
• i.e
  development:
  dialect: postgres
  database: db_name
  user: postgres
  password: ****
  host: 127.0.0.1
  pool: 5
  • now you can use 'soda migrate' or 'soda migrate up' in case you have some
    code there for creating a table
    may this approach helps