--- title: "This week's database news, issue 55" publication: "DB Weekly" issue: 55 published_at: "2015-04-17" canonical_url: "https://dbweekly.com/issues/55" --- This week's database news, issue 55 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/55) DB WeeklyIssue 55 — April 17, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [Primary Keyvil, Reprised](http://www.databasesoup.com/2015/03/primary-keyvil-reprised.html?utm_source=dbweekly&utm_medium=email)Josh Berkus“Inevitably, practices which are “necessary evils” tend to become “pervasive evils” in the hands of the untrained and the lazy. Not realizing that ID columns are a pragmatic compromise with application performance, many frameworks and development pragmas have enshrined numeric IDs as part of the logical and theoretical model of their applications.” [Graph Databases vs Relational Databases](http://neo4j.com/developer/graph-db-vs-rdbms/?utm_source=dbweekly&utm_medium=email)Neo4jThis article explores the differences between relational and graph databases and data models. In addition, it explains how to integrate graph databases with relational databases and how to import data from a relational store. [Augmenting MySQL with Big Data and NoSQL](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter)ObjectRocket by RackspaceSponsoredJoin us for our upcoming webinar. This webinar will explore a range of database technologies from MySQL/Percona to Hadoop, Mongo, and Redis. You’ll learn how you can fit all of these technologies together to make your data flow seamlessly between them and optimize your database performance. Learn More – [Register Today](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter) [![ObjectRocket by Rackspace\](http://s3.amazonaws.com/nlga/uploads/item/image/36259/i.png)](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter) [RethinkDB 2.0: Now Production Ready](http://rethinkdb.com/blog/2.0-release/?utm_source=dbweekly&utm_medium=email)RethinkDBRethinkDB 2.0 inverts the traditional database model. Instead of polling for changes, the developer can tell RethinkDB to continuously push live query updates to an application. [Building a Distributed Fault-Tolerant Key-Value Store](http://blog.fourthbit.com/2015/04/12/building-a-distributed-fault-tolerant-key-value-store?utm_source=dbweekly&utm_medium=email)FourthbitImplementing a fault-tolerant distributed key-value store isn’t easy, and while the implementation shown here isn’t production ready, there are lots of lessons to learn. [MySQL Leader Percona Takes Aim at MongoDB](http://www.datanami.com/2015/04/14/mysql-leader-percona-takes-aim-at-mongodb/?utm_source=dbweekly&utm_medium=email)DatanamiThe popular MySQL support and consulting company has a plan to go after MongoDB’s business with an alternative drop-in replacement. [Types of NoSQL Databases](http://www.jamesserra.com/archive/2015/04/types-of-nosql-databases/?utm_source=dbweekly&utm_medium=email)James SerraA quick overview of NoSQL database systems, with the most popular options in various groups (key value, graph, column, etc.) [ThingieQuery: An SQL Plugin for Excel](http://thingiequery.com/?utm_source=dbweekly&utm_medium=email)ThingieQueryAn Excel plugin that lets you do things using SQL on Excel spreadsheets. Jobs - [Senior Database Administrator (Austin, TX)](https://uscareers-rackspace.icims.com/jobs/9847/mongodb-administrator/job?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-Mongojob=false=960=500=true=false=0=60)ObjectRocket is seeking a Mid-to-Senior level DBA to join our Engineering team to work on our scalable, highly-available MongoDBaaS platform. Anyone can manage a single application - we manage and maintain thousands of production databases supporting billions of operations. You’ll be part of a highly capable and motivated team working on solving the hard problems of scalability, availability, and performance on a global platform. [Apply here.](https://uscareers-rackspace.icims.com/jobs/9847/mongodb-administrator/job?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-Mongojob=false=960=500=true=false=0=60) Rackspace In brief - [Google Cloud Dataflow Now Open for Business](http://www.datanami.com/2015/04/16/google-cloud-dataflow-now-open-for-business/?utm_source=dbweekly&utm_medium=email) news Datanami - [Building Your First Application with MongoDB: Creating A REST API using The MEAN Stack](https://www.mongodb.com/blog/post/building-your-first-application-mongodb-creating-rest-api-using-mean-stack-part-1?utm_source=dbweekly&utm_medium=email) tutorial MongoDB - [Intro to Database Systems: Schema Refinement - Functional Dependencies](http://blog.dancrisan.com/intro-to-database-systems-schema-refinement-functional-dependencies?utm_source=dbweekly&utm_medium=email) tutorial “Schema refinement is just a fancy term for saying polishing tables.” Dan Crisan - [Using MongoDB Tailable Cursors to Create Real-Time Apps](https://www.youtube.com/watch?v=N9fDxuohdy8) video A short 3 minute demo of capped collections and tailable cursors. Tugdual Grall - [Hadoop: The Tale of Data Storage to Data Processing](http://www.datanami.com/2015/04/14/hadoop-the-tale-of-data-storage-to-data-processing/?utm_source=dbweekly&utm_medium=email) opinion Datanami - [Why or How Did You End Up Working with Databases and SQL? Do You Enjoy It?](http://www.reddit.com/r/SQL/comments/32ua4c/why_or_how_did_you_end_up_working_with_databases/?utm_source=dbweekly&utm_medium=email) opinion Reddit - [Finding Bugs in SQLite, The Easy Way](http://lcamtuf.blogspot.com/2015/04/finding-bugs-in-sqlite-easy-way.html?utm_source=dbweekly&utm_medium=email) lcamtuf - [Deep Dive into Spark SQL’s Catalyst Optimizer](https://databricks.com/blog/2015/04/13/deep-dive-into-spark-sqls-catalyst-optimizer.html?utm_source=dbweekly&utm_medium=email) Databricks - [Writing a Redis Client in Pure Bash](http://digitalserb.me/writing-a-redis-client-in-pure-bash/?utm_source=dbweekly&utm_medium=email) Nikola Krzalic - [SQLAlchemy 1.0.0 Released: The Python SQL Toolkit and ORM](http://www.sqlalchemy.org/blog/2015/04/16/sqlalchemy-1.0.0-released/?utm_source=dbweekly&utm_medium=email) code tools SQLAlchemy - [SQL to C Translator for SQLite](http://alpinejoe.github.io/?utm_source=dbweekly&utm_medium=email) code Avoid parsing of SQL by converting it to C code, which may then be appended to sqlite3.c and compiled. alpinejoe - [PyMongo 3: A Rewrite of The Python Driver for MongoDB](http://emptysqua.re/blog/announcing-pymongo-3/?utm_source=dbweekly&utm_medium=email) code Jesse Jiryu Davis Curated by [Peter Cooper](http://twitter.com/peterc) and published by [Cooper Press](https://cooperpress.com/) for [Rackspace](http://www.rackspace.com/?utm_source=dbweekly&utm_medium=email). Send feedback by simply replying to this mail. Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q4.pdf) Want to post a job? E-mail us or [use our self-serve system.](https://cooperpress.com/jobs) [Unsubscribe](*|UNSUB|*) : [Change email address](*|UPDATE_PROFILE|*) : [Read this issue on the Web](http://dbweekly.com/issues/55) © Cooper Press Ltd. Office 30, Lincoln Way, Louth, LN11 0LS, UK [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)