Storing hierarchical data in a database Part 2a: Modified preorder tree traversal

Second part in this series of discussions/tutorials on storing hierarchical data in a database. You can read the first on here. The original article I read that got me started on these ideas can be found here (you’ll notice the tree diagrams are similar). Most credit should be given to Gijs Van Tulder; I simply …

Security: Don’t blindly trust $_SERVER variables

Article one: Chris Shiflett: SERVER_NAME Versus HTTP_HOST Article two: Sean Coates: XSS Woes I thought both were quite insightful, though Sean’s stands-out more because PHP_SELF is used so often (be sure to check-out his phpinfo(); example at the end of the post). One method, as he explained, is to put the $_SERVER[‘PHP_SELF’] variable into htmlentities() …

Digital Fish Library in the news!

The DFL is in the news again! http://www.digitalfishlibrary.org/the_news/ Included in the most recent updates: News segment from NBC 7/39 in San Diego, and the press release at the SIO website. Also, link to our little spot in Nature (one of the most prestigious scientific journals in the world). Nature 440, 396-397 (23 March 2006) ~Cameron

Storing hierarchical data in a database: Part 1

(Click to see part 2a and 2b) In this first of two (or three) posts, I’m going to present a fairly conventional way of representing hierarchical data in a database. (The original article I read that got me interested on posting these ideas can be found here, hence the similarity in the tree structure). My …

Digital Fish Library Press Release

Today is the big day – our press release is now out, and even featured on the SIO (Scripps Institution of Oceanography) website. In just under an hour we’ll begin scanning a juvenile great white shark as part of the press “event.” If you haven’t read my other posts on the DFL, here’s a brief …

Hey there! Come check out all-new content at my new mistercameron.com!