DB Weekly
Issue 55 — April 17, 2015
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."
Neo4j
This 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.
ObjectRocket by Rackspace
Sponsored
Join 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
RethinkDB
RethinkDB 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.
Fourthbit
Implementing 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.
Datanami
The popular MySQL support and consulting company has a plan to go after MongoDB’s business with an alternative drop-in replacement.
James Serra
A quick overview of NoSQL database systems, with the most popular options in various groups (key value, graph, column, etc.)
ThingieQuery
An Excel plugin that lets you do things using SQL on Excel spreadsheets.
Jobs
-
Senior Database Administrator (Austin, TX)
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.
Rackspace
In brief
-
Google Cloud Dataflow Now Open for Business news
Datanami -
Building Your First Application with MongoDB: Creating A REST API using The MEAN Stack tutorial
MongoDB -
Intro to Database Systems: Schema Refinement - Functional Dependencies tutorial
"Schema refinement is just a fancy term for saying polishing tables."
Dan Crisan -
Using MongoDB Tailable Cursors to Create Real-Time Apps video
A short 3 minute demo of capped collections and tailable cursors.
Tugdual Grall -
Hadoop: The Tale of Data Storage to Data Processing opinion
Datanami -
Why or How Did You End Up Working with Databases and SQL? Do You Enjoy It? opinion
Reddit -
Finding Bugs in SQLite, The Easy Way
lcamtuf -
Deep Dive into Spark SQL’s Catalyst Optimizer
Databricks -
Writing a Redis Client in Pure Bash
Nikola Krzalic -
SQLAlchemy 1.0.0 Released: The Python SQL Toolkit and ORM code tools
SQLAlchemy -
SQL to C Translator for SQLite 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 code
Jesse Jiryu Davis