Much Ado About Stored Procedures

Drizzle is against stored procedures (SP): Drizzle does not currently have any plugins that implement stored procedures. We viewed the implementation in MySQL to be non-optimal. They bloat the parser and only support one language (SQL2003 stored procedures), which was not well known. Fundamentally, stored procedures usually are not the correct architectural decision for applications that need to scale. Pushing more computation down into the database (which is the trickiest layer to scale) isn’t a good idea. We do recognize the value of using stored procedures to reduce the time row locks are held, but think we can achieve the … Continue reading Much Ado About Stored Procedures

SQL Injection

Courtesy: uber:ASP.Net By now you’re probably familiar with the risk of SQL injection attacks. Just to refresh your memory, this is when a naughty user of your site gets actual SQL statements to execute by way of a form on your page. If you concatenate strings to form SQL commands, you’re at risk. Consider this spot of code: string sql = “SELECT * FROM User WHERE Name = ‘” + NameTextBox.Text + “‘ AND Password = ‘” + PasswordTextBox.Text + “‘”; Seems innocent enough, right? If someone knows that your code looks like that, you could be in a world … Continue reading SQL Injection

Click and Learn App

Click and Learn app by Howard Hughes Medical Institute Interactively explore topics in biology with the Click and Learn app. Each module features supporting videos and animations (Internet connection required). Learn about topics in evolution, neurobiology, infectious diseases, and bioinformatics.This app will be updated with more Click and Learn modules in the future. It is geared for high school biology students and anyone interested in the biological sciences.Modules originally released as part of HHMI’s Holiday Lectures on Science DVDs. The Howard Hughes Medical Institute (HHMI) is a nonprofit medical research organization that ranks as one of the nation’s largest philanthropies. … Continue reading Click and Learn App

Dealing with Information Overload

Courtesy: basex On Monday, the Information Overload Research Group (IORG) hosted a virtual literary salon on the topic of Information Overload entitled “Five Authors, Five Books, A Dialogue on Information Overload.” The event featured authors who have written recent books related to the subject of Information Overload. They were asked to discuss why they wrote their books, and what issues they feel are most relevant today. Dave Crenshaw, author of The Myth of Multitasking, spoke about the problem of switch tasking, which describes what happens when people switch back and forth rapidly between tasks, lowering their productivity. Crenshaw suggested several … Continue reading Dealing with Information Overload

Physicalization or Virtualization?

Courtesy: arstechnica “Physicalization” is an awkward name for an approach to server consolidation that seeks to offer a hardware-based alternative to virtualization by cramming multiple, low-power processors into a small amount of rack space. These processors are invariably mobile processors, designed for power-sensitive mobile products, and server vendors are building very small, modular server nodes around them and packing them as densely as possible into rack units. It’s too early to tell if this trend has legs, but ever since we’ve started covering it, something about it has been bothersome: in short, it seems to go against Moore’s Law. But … Continue reading Physicalization or Virtualization?

SeaMicro Atom Servers

First Generation Servers How It Works (courtesy: arstechnica) Each server node consists of one Atom Z530 chipset (Atom CPU plus I/O hub), a small pool of DRAM, and a special ASIC chip that attaches to the I/O hub’s PCIe bus. This ASIC is what makes the SeaMicro idea work, and it does so by pretending to be a standard complement of PCIe-based storage and networking controllers. So while the front side of the ASIC attaches to the Atom chipset via PCIe, the backside of it attaches to a high-bandwidth, proprietary bus that connects the invidual server nodes to each other … Continue reading SeaMicro Atom Servers