SQL Abuse
Tuesday, October 02, 2012, Modified: Tuesday, October 02, 2012 Refs

I have been using SQLite a lot recently on Android and in my homebrew web server. I don't have a history of working with relational databases, and it has not seemed at all natural to me. Rolling my own object relational mapping on Android was particularly unpleasant. I'd read enough to know that the way I wanted to do things was not orthodox and I bent to convention, even though the thought of changing schemas after deployment to Play is worrying.

Finding out recently that reddit runs off two tables: 'thing' and 'data' inspired me to go ahead and ignore the relational model and just abuse SQLite from here on out. I came across a related blog post by Stavros Korokithakis about a project of his while following up his interview about bootstrapping startups in Techzing podcast #147. It's nice to see that someone else is taking a similar line. BTW, thanks Stavros for the tip about Theme Forest. Your blog and sites look a lot better than a $10 spend on design would suggest.

Friend Feed

Following the link from Stavros, I see that FriendFeed were also pushed by schema change inertia and operational issues to dump relational concepts while still using an SQL database. Their main schema looks like this:

Try Buffer, a smarter way to share links and pictures by spreading your tweets and posts out over time. Sign up from this link and we both get extra features.

Home :: Items