Since post authors expect to be able to view the passwords they assign to posts (and often don’t write them down), it will continue to be stored in plaintext.

What's wrong with encrypting the password before storing in the database, and decrypting upon retrieval?