8. Reading Data from the Database | Clojure Web Development Essentials

Creating the catalog

At this point, we want to lay the foundation of allowing our user to catalog and view their record collection. We will create a simple Recently Added album page, and a simple Show me all the albums for this artist page (which I'll just call "the artist page"). The first thing to do in order to facilitate this incredible functionality is to create the artists table and the albums table.

Creating the artists table

We will use Migratus to create the artists table. As such, we need to create another SQL migration file. So let's do the following:

In the src/migrations folder, create a new migration script called 00000000000200-artists.up.sql.
For our hipstr app, the artists table is going to be extremely simple. We'll have an artist_id that uniquely identifies the artist, a name (go figure), and two timestamps, created_at and updated_at, for keeping track of when the artist was created and last updated. Add the following SQL:
```
CREATE TABLE artists                              ...
```

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Clojure Web Development Essentials

By : Baldwin

Clojure Web Development Essentials

By: Baldwin

Overview of this book

Creating the catalog

Creating the artists table

Clojure Web Development Essentials

By : Baldwin

Clojure Web Development Essentials

By: Baldwin

Overview of this book

Creating the catalog

Creating the artists table

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access