Well that's certainly an idea.

Holy shit. Talk about getting owned.

See that's the thing, there is no real "best IDE to use" for most projects outside the windows/.net ecosystem. You get your pick with the caveat that you need to configure your IDE for the particular workflow and languages/tools you'll be working with.

Visual Studio Code, Neovim, Emacs, Jetbrains products, etc. are all fine choices depending on your personal preferences.

Looking at the documentation, it looks like PostgreSQL is the db server of choice.

Also note that the documentation there has sections on installing using Docker, Ansible, and seeing up an AWS instance as well as setting one up from scratch.