ifacethoughts

Using MySQL For Schema-less Data

Bret Taylor, one of the founders of FriendFeed, explains how they use MySQL to store schema-less data. It is an insightful post not only because he explains why they chose MySQL, but also the limitations of their schema-less design over an RDBMS. And more importantly it illustrates The importance of modeling your data, even if it is to realize that it has flexible schemas, without thinking of what tools you will use.

Scaling By Eliminating The Database

Frank Sommers discusses an idea presented by Robert McIntosh about building a high volume application without a RDBMS. The idea itself is not new, I have seen references to scalability problems converging towards the database. But the details with which Robert McIntosh tries to achieve some advantages of the database, like indexing, through other options are engaging. [Continue]

SQL Injection

SQL Injection is probably the best reason, other than speed of execution sometimes, to use stored procedures instead of dynamic SQL queries. Ill-intentioned users can inject character literals through their input that can be used to comment out part of the query being executed. Scott Glu has a tip on ways of preventing it (via Miguel de Icaza). [Continue]

freshthoughts

contactme

Abhijit Nadgouda
iface Consulting
India
+91 9819820312
My bookmarks

badgesand...

This is the weblog of Abhijit Nadgouda where he writes down his thoughts on software development and related topics. You are invited to subscribe to the feed to stay updated or check out more subscription options. Or you can choose to browse by one of the topics.