Storage
Last updated
This page explains the three SQLite tables and the access methods on
database.SQLite; see Configuration for where the file lives.Tables
| Table | Columns | Purpose |
|---|---|---|
news | id, title, url (UNIQUE), content, full_content, source, author, word_count, published_at, created_at | Articles and extracted text |
feeds | id, url (UNIQUE), dismiss, created_at, updated_at | Feeds; dismiss = 1 means removed |
data | id, key (UNIQUE), value | Key-value settings: apikey, summary |
On startup
NewSQLite() creates the tables with CREATE TABLE IF NOT EXISTS and indexes news.url, news.published_at, news.source, feeds.url, feeds.dismiss, and data.key.Articles
| Method | Behavior |
|---|---|
Insert(news, content) | INSERT OR REPLACE; with a nil content, full text and author are empty strings and word count is 0 |
Get(hours) | Returns articles whose published_at is within N hours, newest first; rows that fail to scan are skipped |
GetFromURL(url) | Fetches one article by URL; returns an error when not found |
On read, empty full text and author and a zero word count become nil, so callers check
FullContent == nil to decide whether to extract.Feeds
| Method | Behavior |
|---|---|
InsertFeed(url) | INSERT OR REPLACE with dismiss set to 0; a re-added feed gets a new creation time |
RemoveFeed(url) | Sets dismiss to 1 and updates updated_at |
GetFeed() | Returns URLs with dismiss = 0, ordered by creation time |
Key-Value and Connection
| Method | Behavior |
|---|---|
GetKey(key) | Reads a value; returns an error when missing |
SetKey(key, value) | INSERT OR REPLACE, trimming whitespace from key and value |
Close() | Closes the connection; called when Run() returns |