github.com/shhj1998/rss-search-api

RSS Search API

This repository is a server code for fetching and searching RSS data efficiently. There are also many useful Go packages to help you develop your own RSS project!

Table of Contents

1. Packages
2. Getting Start
3. API
   • Item API
   • Channel API
4. Schema
   • ER Model
   • Table
5. Performance
   • Test DB Info
   • Results
6. Library Used
7. See Also

Packages

• rsserver : Our main package that provides many functionalities to act with our rss database. More information is available on our documentation.
• rssapi : A simple REST api server that uses rsserver package. Available apis are described below.

Getting Start

After downloading the repository, you should enter the following commands to run a rss-search-api server.

> dep ensure
> go run main.go

Before running, you should make a .env file to connect with your database. The sample .env file is here.

API

Item API

These apis help you to fetch and create rss item information.

GET /api/v1/item

Request

curl -i -H 'Accept: application/json' http://localhost/api/v1/item

Response

[
  {
    "title": "...",
    "description": "...",
    "link": "...",
    "published": "...",
    "author": {
      "name": "..."
    },
    "guid": "...",
    "enclosures": [
      {
        "url": "...",
        "type": "..."
      },
      ...
    ]
  }, 
  ...
]

Channel API

These apis help you to fetch and create rss channel information.

GET /api/v1/channel

Request

curl -i -H 'Accept: application/json' http://localhost/api/v1/channel

Response

[
  {
    "id": 1,
    "rsslink": "https://media.daum.net/syndication/society.rss",
    "title": "다음뉴스 - 사회Top RSS",
    "link": "http://media.daum.net/society/",
    "items": null,
    "feedType": "",
    "feedVersion": ""
  },
  {
    "id": 9,
    "rsslink": "https://media.daum.net/syndication/entertain.rss",
    "items": null,
    "feedType": "",
    "feedVersion": ""
  }
]

POST /api/v1/channel

Request

curl -i -H 'Accept: application/json' -X POST \ 
	--data '{"rss": "https://media.daum.net/syndication/entertain.rss"}' \
	http://localhost/api/v1/channel

Response

{
  "success": "successfully created a new Channel"
}

Error

• If you forgot adding request body with rss link,

{
  "error": "Request body doesn't match the api... Please read our api docs"
}

• If your rss link is invalid,

{
  "error": "http error: 400 Bad Request"
}

• If your rss link is not a rss,

{
  "error": "Failed to detect feed type"
}

• If you are creating an already existing rss channel,

{
  "error": "Error 1062: Duplicate entry '...' for key 'rss_link'"
}

GET /api/v1/channel/items

Request - fetch all channels with items

curl -i -H 'Accept: application/json' http://localhost/api/v1/channel/items

Response

[
  {
    "id": 1,
    "rsslink": "https://media.daum.net/syndication/society.rss",
    "title": "...",
    "link": "...",
    "items": [...],
    "feedType": "",
    "feedVersion": ""
  },
  {
    "id": 9,
    "rsslink": "https://media.daum.net/syndication/entertain.rss",
    "items": null,
    "feedType": "",
    "feedVersion": ""
  }
]

Request - fetch specific channels with items

You can filter the channel you only want by query strings. It is available to put multiple channel's id.

curl -i -H 'Accept: application/json' http://localhost/api/v1/channel/items?id=1&id=2000

Response

[
  {
    "id": 1,
    "rsslink": "https://media.daum.net/syndication/society.rss",
    "title": "...",
    "link": "...",
    "items": [...],
    "feedType": "",
    "feedVersion": ""
  }
]

GET /api/v1/channel/items/count/{count}

You can also use the feature of channel filtering with query string described in GET /api/v1/channel/items.

Request

curl -i -H 'Accept: application/json' http://localhost/api/v1/channel/items/count/1

Response

[
  {
    "id": 1,
    "rsslink": "https://media.daum.net/syndication/society.rss",
    "title": "...",
    "link": "...",
    "items": [...],
    "feedType": "",
    "feedVersion": ""
  },
  {
    "id": 9,
    "rsslink": "https://media.daum.net/syndication/entertain.rss",
    "items": null,
    "feedType": "",
    "feedVersion": ""
  }
]

Schema

ER Model

• Entity
  • Channel : RSS Channels provide items(news). It doesn't have a specific primary key, so we set a new feature 'channel_id' as a primary key.
  • Item : Items are the news published by RSS channels. In RSS 2.0, their is a primary key called 'guid'.
  • Enclosure : Enclosures are media that is used in items like image, video. Usually, one url only have one media, so we set url as a primary key.
• Relationship
  • Publish : This relationship represents what items were published by a channel. It is many-to-many.
  • Enclosure : This relationship represents which enclosures are used in a item. It is one-to-many.

Table

You can see the tables schema here. We add some b-tree index to higher the performance. If you are interested what is b-tree index, you can look here.

• Item
  • Because 'guid' is a long string, it will lower performance in search. So we made a new primary key which is integer named 'item_id'. Instead, we add a unique contraint to guid.
  • We add a b-tree index on item_id because it will be frequently used in joining with Publish table.
• Channel
  • Nothing special, just add a auto_increment integer primary key 'channel_id' with a b-tree index.
• Publish
  • To satisfy BCNF constraints - lower redundancy, we change Publish relationship to a table instead adding a feature in Item.
  • Because it is many-to-many, (item, channel) is a primary key. Each of them is a foreign key.
• Enclosure
  • Because Media is a one-to-many relationship, it don't need a additional table to lower redundancy.
  • Add a b-tree index and foreign key constraint to 'item'.

Performance

Test DB Info

We used 8 rss services and 3594 rss items(news) to test our api performance. The details of the rss services are described below.

Name	Link	Rows
다음뉴스 - 사회Top RSS	https://media.daum.net/syndication/society.rss	387
다음뉴스 - 시사 주요뉴스 RSS	https://media.daum.net/syndication/entertain.rss	975
다음뉴스 - 스포츠 주요뉴스 RSS	https://media.daum.net/syndication/today_sports.rss	810
다음뉴스 - 정치Top RSS	https://media.daum.net/syndication/politics.rss	312
다음뉴스 - 경제Top RSS	https://media.daum.net/syndication/economic.rss	431
다음뉴스 - 국제Top RSS	https://media.daum.net/syndication/foreign.rss	302
다음뉴스 - 문화/생활Top RSS	https://media.daum.net/syndication/culture.rss	202
다음뉴스 - Tech Top RSS	https://media.daum.net/syndication/digital.rss	163

Results

Details of the result are described below. The code used to test performance is here. It will not work in your local repository because it must be with a .env file that contains the test db information. We tested three api that were most likely to be used. GET /api/v1/channel/items/count/:count apis show almost same performance although the count value changes.

API	Time(ms)
GET /api/v1/channel	39.837295
GET /api/v1/channel/items	298.150581
GET /api/v1/channel/items?id=3	61.691366
GET /api/v1/channel/items/count/1	277.327405
GET /api/v1/channel/items/count/2	273.187845
GET /api/v1/channel/items/count/3	281.879731
GET /api/v1/channel/items/count/4	347.423070
GET /api/v1/channel/items/count/5	283.924582
GET /api/v1/channel/items/count/6	274.330836
GET /api/v1/channel/items/count/7	279.774116
GET /api/v1/channel/items/count/8	270.644527
GET /api/v1/channel/items/count/9	339.821699
GET /api/v1/channel/items/count/10	345.249172

Library Used

• gofeed - Provides rss parser and related types.
• sql-mock - Used to mock sql database and connection for testing.
• testify - Provides useful test functions like assertions.
• logger - Custom logger library.

See Also

• RSS 2.0 - More information about RSS specification.
• android-rss-viewer - Android application that uses rss-search-api.