> What's it like to work with? Do you prefer it to JS/PHP/Python for web related projects?
Coming from dynamic languages it will feel very different, especially if you don't have a lot of experience with typed compiled languages. Personally, I came from a JS background and I love it. It totally sold me on the benefits of a good type system so much so that I sorely miss it when working with JS now.
Writing web servers in Rust is a fairly new space, it's not as mature as js/php/python, however things are moving quickly. Having your code run orders of magnitude faster is pretty nice too.
> Can you iterate on code quickly, or is there a compile step on every iteration?
I think conflating 'working on code quickly' with compilation is a mistake, however, yes, you do need to compile your code. IMO a compiler will help you iterate more quickly because it's able to check for errors before you run your code.
> Are there stable libraries for interacting with MySQL/Redis/Postgres asynchronously?
If you want an ORM the thing you want to look at is diesel. I'm not sure if it's async or not.
> Is there good IDE support, for example in Atom?
rust language server (RLS) has plugins for most editors. I think the best experience for developing rust right now is in VScode or vim, IMO.