My name is Peter Sanderson. I've been handed parts of the nascent Open LJ server for the company I'm working for. My present task is building a python script that allows for fulltext searchs for our lj site. I have a good working version running at the moment, but have been attempting to find certain types of documentation that might make it cleaner/more efficent. So far, I've had little success locating anything which discusses the interaction between the lj server itself and the SQL db behind it. While I've been moderately successful using a brute force method of comparing various bml pages with SQL tables, I was hoping someone here might be able to point me towards some reference (preferably a whitepaper or other simlarly high-level document) that discusses explicitly the way(s) in which these two backend elements work with one another.
Thank you in advance for any help you may be able to offer,