I think it looks like a very good core design for the database.

We could rename "tag" to "category". It is likely that the user will want to organize feeds in different categories to merge them in one view. For instance "Business", "News", "Hobbies", "Sports", etc.

"Tags" and "categories" from a database perspective is pretty much the same, so the proposal to rename "Tag" to "category" is merely to emphasize that it will be used as a strong organizing tool. (Basically, I want to avoid having the user create multiple tags like "hobbies", "hobby", "my hobbies" for the same thing, and rather put them all in one category, "Hobby").


Great work!

On 04/22/2013 11:38 AM, Joey Chan wrote:
Seems that was my misunderstand  :P

So, any further suggestion or advices to the E-R diagram?


2013/4/22 <[email protected]>

I think we have misunderstanding.

Look in databasemodule.js

We have two tables, "userfeeds" and "feedentries" (mb not exact names, I can't check actual names).


22.04.13 13:06 Joey Chan написал(а):

Hi Roman,

Not similar exactly, I separate the article(item) from feed because I want to store the feeds and articles(items) in separate database tables. This may sounds a bit complicated but I think this is necessary.

:)


2013/4/22 <[email protected]>

We already have similar model, without favourites and tags, am I right? =)


22.04.13 6:49 Joey Chan написал(а):

Hi Ladies and Gentlemen,

I've done the E-R diagram of RSS Reader, preview:
内嵌图片 1

description:

1. feed is the primary entity, it may contains many "tags" , "articles(items)" and necessary attributes; 

2. article(item) is the secondary entity, every article(item) has its own attributes.
I separate article(item) from feed(which has a complete xml include articles) because the reader doesn't need to read the whole xml content if the user just wants to read one article, also, the design team will have more freedom to design the interaction with one article(item);

3. tag, means ... maybe call it "category"   >_<

4. favourite, favourite articles; 

* the attachment is a gia source file, pls use Dia(sudo apt-get install dia) to open it and feel free to discuss :)







-- 
Mailing list: https://launchpad.net/~ubuntu-touch-coreapps
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~ubuntu-touch-coreapps
More help   : https://help.launchpad.net/ListHelp

Reply via email to