DB Modification / unique id

[Kevin T. Lee]

Hey Manuel! 

I looked at the RSS id stuff, LA times doesn't have anything that is similar to the OC register in terms of a numeric ID.

The field guid looks like ocregister-29821 for OC Register and is a link to the article for the LA times. 

Thoughts? 

Best,

Kevin

[Manuel Yang]

I took a look at the LA times xml and within its link tag looks like there's some numbers in the url we can use that are separated by commas.

<link>

http://www.latimes.com/books/jacketcopy/la-et-jc-is-2014-the-year-of-reading-woman-20140122,0,1673667.story?track=rss

</link>

first item in the list separated by commas is the date, followed by a zero and then probably what looks like it's unique number. However just to be sure, let's combine all three numbers and use that as it's unique ID. Now it's just a matter of parsing the url to get those numbers and combining them into a bigger number. Let me know if you need any help with it.

Thanks,

Manuel Yang

[Kevin T. Lee]

Alright, I'll take a look back at that.

Best,

Kevin Lee

[Kevin T. Lee]

Hey Manuel,

I was able to figure out the OC Register stuff, I couldn’t find the link example you provided. Is that through a different feed? as opposed to this one: http://feeds.latimes.com/latimes/news/local

Best,

Kevin 

On Jan 22, 2014, at 2:27 PM, Kevin T. Lee <kevin...@gmail.com> wrote:

[Manuel Yang]

Ah I just googled la times XML feed and clicked the first one haha. But yeah looking at the provided feed the only I could think of is creating a different schema for it.

- Manuel Yang

[Kevin T. Lee]

Hey! 

I was talking to Erick yesterday, I'll switch the unique Id from a number to a string value, since when we query things its typically with the sentiment, source and not the Id.

If you guys see anything that talks about disadvantages to having a string value as a unique Id let me know! It just seems uncommon but not I'm not a DB genius. Thanks!

Best,

Kevin Lee

On Sat, Jan 25, 2014 at 8:49 PM, Manuel Yang <man...@uci.edu> wrote:

Oh maybe we can switch the unique from a number to a string value

- Manuel Yang

On Jan 25, 2014, at 12:55 PM, "Kevin T. Lee" <kevin...@gmail.com> wrote:

Oh haha no worries, would that be easier? Still using a numeric value for Id?

Dang LA times for being different hahaha