DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 65 — July 31, 2015
Featured
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.
Toptal     sponsored   
SQLite Release 3.8.11.1: Now 2x Faster than 3.8.0 — Despite the maturity of the SQLite project, its performance continues to increase significantly.
SQLite.​org
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.
Amazon
mycli: A Better Command Line Interface for MySQL and MariaDB — A command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.
Pelican    tools   
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.”
Samson Hu
In brief
Open-Sourcing IBM Cloudant’s CouchDB Search Integration with Lucene
IBM Cloudant    news   
Database Design: Email Confirmation and Recovering Passwords
Vertabelo    tutorial   
SQL Server Indexing Strategies: Clustered, NonClustered, and Filtered Indexes — Indexing decisions can have a huge impact on database performance.
Jeffrey J Keller    tutorial   
Optimizing Redis Usage For Caching
Parker Selbert    tutorial   
Using Set Theory to Integrate Development and Deployment
Database Journal    tutorial   
App Analytics Workbook — New Interactive Workbook: Identify, Track, Optimize Your App Success Metrics
Localytics    sponsored   
Mongob: Collection-Based Backup Tool for MongoDB — Supporting incremental backup with ObjectId and more.
Nguyễn Hà Dương    tools   
SQLsmith: A Tool That Generates Random SQL Queries — Aimed at testing and exposing bugs in database systems.
Andreas Seltenreich    tools   
Data Explorer: An Open Source Data Explorer — An open source point-and-click interface for querying and visualizing event data.
Keen IO    code   
« Prev
Next »