Now let's start reading from the database.

First we'll find individual posts.

Down here we have the get route found individual article.

I've created a simple synchronous function called find that gets the ID

from the route, and searches from the static articles.

We can use SQLizer's find by ID method to find an article by the ID.

Now we can get rid of the static articles at the top here and define function too.

Next, let's work on getting all the articles back.

In the get route for all of the articles we can use SQLizer's find all method.

This will retrieve all of the articles, instead of a single article.

Let's restart the server.

This should now retrieve and show all of the blog posts.

Let's create another blog post.

My second Blog Post.

Authored by me.

And we can have any old text in this body here.

It shows correctly.

And when we go back to the article list page, we have a problem.

The latest article appears last.

We need to order the results.

The findAll method can take an options object.

Within that you can add any number of criteria to filter the results including

order by to order a result set you use the order key

with an array of a race.

Each array includes the column you'd want to order by.

And in which order, ascending or descending.

It's an array of a race because you can order by multiple columns.

In this case, it's only one, and it's in descending order.

Let's reboot the server now, and go back to the list page.

And now the articles are in the desired order.

Next, let's work on updating models.