In Chapter 7, Getting Started with the Database, we covered a lot of ground: We created a database schema and granted our application access, we were introduced to Migratus and started using it to create our first table, and we were introduced to YeSQL for inserting data into the DB without the use of any ORM sorcery. In this chapter, we will continue our example by fetching data from the database. We will be:
Creating two new tables: albums and artists
Seeding our new tables with example data
Creating a new page that displays the recently added albums
Creating a new artist page
Linking the Recently Added page to the artist page
Much of this chapter should appear obvious after everything we've done so far. So let's get to work!