Why NoSQL Mattered, and SQL Still Matters —
University of California Berkeley professor Michael Franklin reflects on the state of distributed databases, SQL, and what the NoSQL movement demonstrated.
Derrick Harris
7 Common Database Design Errors —
Covers invalid naming, insufficient column widths, poor indexing, ignoring time zones, ignoring collation, and more.
Grzegorz Kaczor
Work with the 2.984618% — We have the top 3% ultra-vetted freelance developers. It's fact, not gimmick.
Amazon Aurora Now Available —
Amazon Aurora is a MySQL-compatible, relational database engine that provides up to five times better performance than MySQL at a price point one tenth that of a commercial database.
Transactions in Redis —
“Over the last few months, I’ve been thinking about and implementing transactions for Lua scripting in Redis. Not everyone understands why I’m doing this, so let me explain with a bit of history.”
Dr Josiah
Documenting Your PostgreSQL Database —
Everyone is used to documenting their code, but something that’s seldom done is documenting databases. It’s assumed that columns are clearly named, but even in the most clear database being explicit about what something is and how it works is valuable.
Craig Kerstiens
Building Analytics at 500px —
A look at the stack behind the popular online photography community and how they tie their MySQL databases into their analytics system and use Amazon RedShift. Tons of great insights and stories in here, including why “production schemas are awful for analytics.”