Archive for the 'Database' Category

Database Anti-Pattern: Recursive Network Select

Recursive Network Select is a pattern that occurs when a program makes a call to a database returning a resultset and then as it loops through that resultset it makes a call to the database for each record as it loops through the resultset. In extreme cases, the program will add additional levels of [...]

Interviewing and Hiring programmers

I’ve seen and read a lot of discussions about hiring programmers. Most people claim to want great programmers, but few people know how to even marginally separate the good from the bad. “Great” is a loaded term, and it means different things to different people. What I want to focus on is [...]

Slashdot runs out of room for threaded comments

Slashdot ran into a major problem with their comment system today. Apparently they have a column called “parent_id” or some such that they forgot to switch an index to a 32 bit integer. The net result is they have disabled threaded comments until they can alter the table to 32 bit integers. [...]