Web Development with Clojure, 3rd Edition

Account Customization

Now that we have a page for each author, it’d be nice for authors to be able to personalize it. Let’s add a user bio at the top of the page, along with a display name, birth date, display picture, and a banner picture.

Let’s start by adding a profile column to the users table.

Create a new migration file from the REPL, like so:

user=> (create-migration "alter-users-add-profile")
nil

Then we write the database migration to add our profile column.

guestbook-profile/resources/migrations/20200415001222-alter-users-add-profile.up.sql

ALTER TABLE users
  ADD COLUMN profile JSONB DEFAULT '{}'::JSONB;

And we add the rollback migration.

guestbook-profile/resources/migrations/20200415001222-alter-users-add-profile.down.sql ...