February 20th, 2002

livejournal

Module Name: livejournal
Committed By: bradfitz
Date: Thu Feb 21 03:16:36 UTC 2002

Modified Files:
---------------
livejournal/bin/upgrading: update-db-general.pl update-db.pl
livejournal/cgi-bin: conshared.pl ljlib.pl ljprotocol.pl ljviews.pl
livejournal/htdocs/community: join.bml

Log Message:
------------
db & code changes to make the friends data table over 30% smaller.
changing it (eventually) from a char(7)+char(7) to a
mediumint+mediumint for the color info. no reason to use 7 bytes per
color when it's a 24 bit value.

so for now we bloat it up to 8 bytes per color, to store the 24 bit
color in decimal for awhile, then convert those 16 bytes down to 6.

this may not seem important now, but after cluster conversion is done,
and we can kill all the 43GB of crap on the master db, this is one of
the largest tables remaining, yet it's under 100 MB... it'll be down
to like 60 MB or so. :)


To generate a diff of this commit:
cvs rdiff -r1.48 -r1.49 livejournal/bin/upgrading/update-db-general.pl
http://cvs.livejournal.org/browse.cgi/livejournal/bin/upgrading/update-db-general.pl.diff?r1=1.48&r2=1.49
cvs rdiff -r1.10 -r1.11 livejournal/bin/upgrading/update-db.pl
http://cvs.livejournal.org/browse.cgi/livejournal/bin/upgrading/update-db.pl.diff?r1=1.10&r2=1.11
cvs rdiff -r1.6 -r1.7 livejournal/cgi-bin/conshared.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/conshared.pl.diff?r1=1.6&r2=1.7
cvs rdiff -r1.164 -r1.165 livejournal/cgi-bin/ljlib.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/ljlib.pl.diff?r1=1.164&r2=1.165
cvs rdiff -r1.79 -r1.80 livejournal/cgi-bin/ljprotocol.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/ljprotocol.pl.diff?r1=1.79&r2=1.80
cvs rdiff -r1.38 -r1.39 livejournal/cgi-bin/ljviews.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/ljviews.pl.diff?r1=1.38&r2=1.39
cvs rdiff -r1.10 -r1.11 livejournal/htdocs/community/join.bml
http://cvs.livejournal.org/browse.cgi/livejournal/htdocs/community/join.bml.diff?r1=1.10&r2=1.11

livejournal

Module Name: livejournal
Committed By: bradfitz
Date: Thu Feb 21 04:13:48 UTC 2002

Modified Files:
---------------
livejournal/cgi-bin: ljprotocol.pl

Log Message:
------------
fix from youngoat. woot.

this problem wasn't obvious because it only happened sporadically
(other parts could've loaded it into cache)


To generate a diff of this commit:
cvs rdiff -r1.80 -r1.81 livejournal/cgi-bin/ljprotocol.pl
http://cvs.livejournal.org/browse.cgi/livejournal/cgi-bin/ljprotocol.pl.diff?r1=1.80&r2=1.81

livejournal

Module Name: livejournal
Committed By: bradfitz
Date: Thu Feb 21 04:59:43 UTC 2002

Modified Files:
---------------
livejournal/htdocs: create.bml editinfo_do.bml

Log Message:
------------
don't let newlines get into name field. (breaks flat protocol. and
it's better to not let bad shit get in in first place than try and
fix it on every access). thanks to delusionalangel for pointing
this out, by way of a bug report.


To generate a diff of this commit:
cvs rdiff -r1.19 -r1.20 livejournal/htdocs/create.bml
http://cvs.livejournal.org/browse.cgi/livejournal/htdocs/create.bml.diff?r1=1.19&r2=1.20
cvs rdiff -r1.27 -r1.28 livejournal/htdocs/editinfo_do.bml
http://cvs.livejournal.org/browse.cgi/livejournal/htdocs/editinfo_do.bml.diff?r1=1.27&r2=1.28