Back-end - Coffee on the Keyboard

Sign in Subscribe

Back-end

A collection of 7 posts

An Object Caching Pattern for Django

Increasingly I’ve been treating even RDBMSes like structured key-value stores. There are still foreign keys and relationships in there, but the access patterns are most commonly by some kind of “primary” key (not always the primary key on the table, but a natural one). Normally when I do something

Visualizing the 2015 SotU on TodaysMeet

Now that you know how TodaysMeet works [https://www.coffeeonthekeyboard.com/how-todaysmeet-works-1237/], here’s part 2: using the message queue architecture to build the SotU visualizations. TodaysMeet [https://todaysmeet.com] has a long history [http://blog.todaysmeet.com/case-study-meeting-during-debates-88/] with political events [http://blog.todaysmeet.com/2014-state-of-the-union-room-205/]. During the 2012

Developing at Scale: Database Replication

When a website is small—like this one, for example—usually the entire thing, from the web server to the database, can live on a single server. Even a single virtual server. One of the first things that happens when a web site gets bigger is this is no longer

Responsible SQL: How to Authenticate Users

Most SQL-injection articles set a horrible example for young programmers. Here is a very typical “bad example” of why you need to escape user data before it goes into SQL queries: (ed. The symbol « is a line break that’s not in the real code.) 1. $username = $_POST[‘username’]; // username=

Connecting PHP, IIS 6, and SQL Server 2005

I know I will be accosted for this, but at work we needed to run PHP on IIS 6 ( fairly simple [http://www.peterguy.com/php/install_IIS6.html]) and connect it to a remote database server running SQL Server 2005 (not terrible, once I gave up the Microsoft way)

Help Me Scale

I’ve been reading Eran Hammer-Lahav’s intelligent [http://www.hueniverse.com/hueniverse/2008/04/scaling-a-micro.html] posts on [http://www.hueniverse.com/hueniverse/2008/03/scaling-a-micro.html] microblog scalability [http://www.hueniverse.com/hueniverse/2008/03/on-scaling-a-mi.html], and now I’m concerned about my own “microblog” site, Picofiction