Hey Damon!

FoF is missing several new and new(ish) fields, particularly because
it takes ages to update the DB. I'll add the verified field to gist!

Thanks for pointing out the protected field! I think I set it to
varchar(5) because Twitter sometimes sends back 'false' and sometimes
sends back '1', and most of the time sends back null. (It may send
back '0', and 'true' as well, I can't remember.) I save it to the DB
the way Twitter sends it, and do the mapping on read. Probably the
smart thing to do is, like you said, make it a tinyint(1) then scrub
the data before insert.

My new strategy to database updates is 1) to do as many as possible in
one batch 2) put Friend Or Follow in read-only mode, so it still
works, but the DB user cache/table isn't updating. I can stop doing
inserts for a few days before anyone seems to really notice. A more
better solution would probably be some sorta' hot swap, ie: point the
app to a backup copy of the DB, do the updates on the primary DB, then
point the app back to the primary DB. It's easier for me to just go
read-only for a stint though. Updates are a headache with YesSQL for

On Apr 1, 7:15 pm, Damon C <d.lifehac...@gmail.com> wrote:
> Curious why you're using a varchar field for protected as opposed to
> tinyint(1)/boolean? I don't see a "verified" field either, not sure if
> that's necessary for FoF.
> Other than that, most of my stuff is pretty similar although I'm not
> quite as discerning on the lengths of the fields. I usually just do
> varchar(255).
> Do you have a strategy/opinion for when Twitter adds additional fields
> like geo, verified, etc? This is one of the primary reasons I've been
> considering leaving YesSQL since I have to shut down my site for hours
> just to do an ALTER. :(
> Damon
> On Apr 1, 4:12 pm, DustyReagan <dustyrea...@gmail.com> wrote:
> > So, it occurs to me how many developers must be reinventing the MySQL
> > schema for the User object. I've started work on optimizing my
> > database for Friend Or Follow, and thought it'd be cool to share my
> > schema and collaborate with other YesSQL users.
> > Here's where I'm 
> > starting:http://dustyreagan.com/twitter-mysql-user-object-table-schema/
> > Leave comments here or on my blog and I'll update the MySQL in the
> > main post. It'd be nice to have this for other Twitter objects as well.

Reply via email to