--- title: "This week's database news, issue 65" publication: "DB Weekly" issue: 65 published_at: "2015-07-31" canonical_url: "https://dbweekly.com/issues/65" --- Database Weekly 65 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/65) [Database Weekly](http://dbweekly.com) Issue 65 — July 31, 2015 Featured [Why NoSQL Mattered, and SQL Still Matters](https://medium.com/s-c-a-l-e/database-guru-on-why-nosql-matters-and-sql-still-matters-c64239fe84fd?utm_source=dbweekly&utm_medium=email) — 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](http://www.vertabelo.com/blog/technical-articles/7-common-database-design-errors?utm_source=dbweekly&utm_medium=email) — Covers invalid naming, insufficient column widths, poor indexing, ignoring time zones, ignoring collation, and more. Grzegorz Kaczor [Work with the 2.984618%](http://www.launchbit.com/taz/11159-6010-111) — We have the top 3% ultra-vetted freelance developers. It's fact, not gimmick. Toptalsponsored [![\](http://launchbit.com/taz-i/6010-1af3eab78da2acd5857891f3170307153cce557e-text.png)](http://www.launchbit.com/taz/11159-6010-111) [SQLite Release 3.8.11.1: Now 2x Faster than 3.8.0](https://www.sqlite.org/releaselog/3_8_11_1.html?utm_source=dbweekly&utm_medium=email) — Despite the maturity of the SQLite project, its performance continues to increase significantly. SQLite.​org [Amazon Aurora Now Available](https://aws.amazon.com/blogs/aws/now-available-amazon-aurora/?utm_source=dbweekly&utm_medium=email) — 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. Amazon [mycli: A Better Command Line Interface for MySQL and MariaDB](http://mycli.net/?utm_source=dbweekly&utm_medium=email) — A command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. Pelicantools [Transactions in Redis](http://www.dr-josiah.com/2015/07/transactions-in-redis.html?utm_source=dbweekly&utm_medium=email) — “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](http://www.craigkerstiens.com/2013/07/29/documenting-your-postgres-database/?utm_source=dbweekly&utm_medium=email) — 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](https://medium.com/@samson_hu/building-analytics-at-500px-92e9a7005c83?hn=&utm_source=dbweekly&utm_medium=email) — 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.” Samson Hu In brief [Open-Sourcing IBM Cloudant’s CouchDB Search Integration with Lucene](https://cloudant.com/blog/open-sourcing-cloudant-search/?utm_source=dbweekly&utm_medium=email) IBM Cloudantnews [Database Design: Email Confirmation and Recovering Passwords](http://www.vertabelo.com/blog/technical-articles/database-design-email-confirmation-and-recovering-passwords?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [SQL Server Indexing Strategies: Clustered, NonClustered, and Filtered Indexes](http://www.vertabelo.com/blog/technical-articles/sql-server-indexing-strategies-clustered-nonclustered-and-filtered-indexes?utm_source=dbweekly&utm_medium=email) — Indexing decisions can have a huge impact on database performance. Jeffrey J Kellertutorial [Optimizing Redis Usage For Caching](http://sorentwo.com/2015/07/27/optimizing-redis-usage-for-caching.html?utm_source=dbweekly&utm_medium=email) Parker Selberttutorial [Using Set Theory to Integrate Development and Deployment](http://www.databasejournal.com/sqletc/using-set-theory-to-integrate-development-and-deployment.html?utm_source=dbweekly&utm_medium=email) Database Journaltutorial [App Analytics Workbook](http://www.launchbit.com/taz/11185-5708-111) — New Interactive Workbook: Identify, Track, Optimize Your App Success Metrics Localyticssponsored [Mongob: Collection-Based Backup Tool for MongoDB](https://github.com/cmpitg/mongob?utm_source=dbweekly&utm_medium=email) — Supporting incremental backup with ObjectId and more. Nguyễn Hà Dươngtools [SQLsmith: A Tool That Generates Random SQL Queries](https://github.com/anse1/sqlsmith?utm_source=dbweekly&utm_medium=email) — Aimed at testing and exposing bugs in database systems. Andreas Seltenreichtools [Data Explorer: An Open Source Data Explorer](https://github.com/keen/explorer?utm_source=dbweekly&utm_medium=email) — An open source point-and-click interface for querying and visualizing event data. Keen IOcode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/65) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK