Log in

No account? Create an account
LiveJournal Development [entries|archive|friends|userinfo]
LiveJournal Development

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

May 13th, 2003

A question or a suggestion [May. 13th, 2003|11:10 am]
LiveJournal Development


An introduction seems to be in order. Well, I'm a coder, a developer, a hacker, a what-have-you, and have been for pretty much as long as I remember. While I've yet to do anything touching LJ code, I have lurked around here and some other communities for a while, making comments and suggestions when appropriate (and sometimes not, I'm sure).

As to the reason for this post, I noticed some HTML being stripped from the subject of a recent post on my journal. Would it be a problem (this has possibly been discussed and decided before; I wouldn't know) to modify cleanhtml.pl so that the line reading my $subject_allow = [qw[a b i u em strong cite]]; includes s and strike as well?

If it's not a problem, this could be the humble beginning of my sporadic LJ code-touching.
link9 comments|post comment

Switching to InnoDB in Daughter Sites. [May. 13th, 2003|08:34 pm]
LiveJournal Development


Alright. I was doing a code update today for Plogs.net when I ran into some problems about being unable to allocate an itemid, which I tracked down to funky new code that uses a counter table, which tracked me back to the CVS log that mentions moving to InnoDB. Alright. So I dug out more CVS log entries and diffs about the changes to the tables themselves. Then I tracked over to MySQL's online documentation and got some info on converting tables from MYISAM to InnoDB and figured out that you theoretically just need to do:


But that's just theoretical. Also, some auto_increment columns need to be changed, et cetera. How did LJ do this? Is there a script somewhere that automatically does this change? bin/upgrading/update-db.pl doesn't notice the changes and doesn't suggest that I do anything, and I don't want to end up losing lots of data in this process.


Also, I propose that large changes like this go into this community to keep people aware of things like this. It would have saved me a lot of time and effort. Thanks.
link4 comments|post comment

[ viewing | May 13th, 2003 ]
[ go | Previous Day|Next Day ]