Posts

Time to actually store the posts in the database! We'll also add a browse command to view all the posts from the feeds the user follows, right in the terminal!

Assignment

Add a posts table to the database.

A post is a single entry from a feed. It should have:

id - a unique identifier for the post
created_at - the time the record was created
updated_at - the time the record was last updated
title - the title of the post
url - the URL of the post (this should be unique)
description - the description of the post
published_at - the time the post was published
feed_id - the ID of the feed that the post came from

Some of these fields can probably be null, others you might want to be more strict about - it's up to you.

Create a createPost function. This should insert a new post into the database.
Create a getPostsForUser function. Order the results so that the most recent posts are first. Make the number of posts returned configurable.
Update your scraper to save posts. Instead of printing out the titles of the posts, save them to the database!
- Make sure that you're parsing the "published at" time properly from the feeds. Sometimes they might be in a different format than you expect, so you might need to handle that.
Add the browse command to get the latest posts for the user. It should take an optional "limit" parameter. If it's not provided, default the limit to 2.
Test a bunch of RSS feeds!

Again, no CLI tests for this one. Play around with the program and make sure everything works as intended!