newsboat

# Newsboat

This guide explains how to read and manage RSS/Atom feeds using Newsboat, a command-line RSS/Atom feed reader.

## Installation

### Debian/Ubuntu

```bash
sudo apt update
sudo apt install newsboat sqlite3 pandoc
```

### macOS

```bash
brew install newsboat sqlite3 pandoc
```

### Others

Search online for “install newsboat on [your OS]” for specific instructions.

## Files
  - configuration: ~/.newsboat/config
  - feed URLs: ~/.newsboat/urls
  - cache: ~/.newsboat/cache.db

If Newsboat is not in your PATH, use your OS search to locate its files.

## List Feeds

```bash
cat ~/.newsboat/urls
```

### Example output
```
$ cat ~/.newsboat/urls
https://604now.com/rss/
```

## Add a Feed

```bash
echo "https://example.com/feed.xml" >> ~/.newsboat/urls
```

## Remove a Feed

```bash
sed -i.bak '/https:\/\/example.com\/feed.xml/d' ~/.newsboat/urls
```

This removes the feed URL and creates a backup `urls.bak`.

## Refresh All Feeds

```bash
newsboat -x reload
```

## Read an article

Retrieve articles from the Newsboat cache using `sqlite3` and convert HTML to plain text with `pandoc`.

The rss_item table schema:
```sql
CREATE TABLE rss_item (
	id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
	,guid VARCHAR(64) NOT NULL
	,title VARCHAR(1024) NOT NULL
	,author VARCHAR(1024) NOT NULL
	,url VARCHAR(1024) NOT NULL
	,feedurl VARCHAR(1024) NOT NULL
	,pubDate INTEGER NOT NULL
	,content VARCHAR(65535) NOT NULL
	,unread INTEGER (1) NOT NULL
	,enclosure_url VARCHAR(1024)
	,enclosure_type VARCHAR(1024)
	,enqueued INTEGER (1) NOT NULL DEFAULT 0
	,flags VARCHAR(52)
	,deleted INTEGER (1) NOT NULL DEFAULT 0
	,base VARCHAR(128) NOT NULL DEFAULT ""
	,content_mime_type VARCHAR(255) NOT NULL DEFAULT ""
	,enclosure_description VARCHAR(1024) NOT NULL DEFAULT ""
	,enclosure_description_mime_type VARCHAR(128) NOT NULL DEFAULT ""
);
```

### Read the latest article

```bash
sqlite3 -noheader ~/.newsboat/cache.db \
"SELECT 'title = ' || title || '\nurl   = ' || url || '\ndate  = ' || dat...