> For more mundane things like websites I use php and MySQL. Haskell is the language I'd *like* to know.
You can use Haskell and MySQL for [CRUD](https://en.wikipedia.org/wiki/Create,_read,_update_and_delete) web apps. I like [Servant](https://haskell-servant.readthedocs.io/en/stable/) for routing. There's also [scotty](https://hackage.haskell.org/package/scotty) for routing which is inspired by Ruby's [Sinatra](http://sinatrarb.com/). For MySQL I would use [MySQL-simple](https://hackage.haskell.org/package/mysql-simple).
If you want to learn Haskell, you might try what Prof. Robby Findler at Northwestern University does. He organizes mostly student-run seminars every other semester. He explores stuff like the [K Framework](http://www.kframework.org/index.php/Main_Page), [Coq](https://coq.inria.fr/) and other cutting edge topics.
> I guess that Python ('executable pseudo-code') is considered a bit of a lingua franca on the web these days.
I will try my hardest to use Python to communicate ideas.