prompt_toolkit is, IMO, the standard by which all of these types of libraries should be measured.

It's incredibly easy to get started with, and lets you build crazy wonderful things like pt_python and pgcli/mycli.