DB Weekly Issue 56: April 24, 2015

DB Weekly

Issue 56 — April 24, 2015

Supported by

Dan Crisan

A great set of short posts bundled together to provide an overview of topics like SQL, constraints, triggers, the relational model, indexing, and more.

Another Look At MySQL At Twitter and Incubating Mysos

Twitter

Twitter provides some insights on how it uses MySQL and shares its plans to open source Mysos, a new MySQL on Mesos framework (Mesos is a system that abstracts datacenter resources so you can code against them as a single entity.)

Key Operations and Uses for Redis

Rackspace Sponsored

New to Redis? Looking for a few tips and tricks to get you started? This overview will cover some key operations and common uses of Redis, along with security options and a few simple example scripts. Learn More.

Yes SQL! Celebration at Oracle BI Warehousing and Analytics Summit 2015

YouTube

Join Oracle Corporation luminaries Andy Mendelsohn, Tom Kyte, and Steven Feuerstein as they share their thoughts about the longevity of SQL, what’s amazing about SQL, and why SQL is here to stay.

Transformy: Transforms Data Based on One Example

Transformy

Paste in a list and then write a transformed example of a single line of the data - it then attempts to apply your changes to the entire list.

Massive 2.0: A Postgres-Centric Data Access Tool for Node.js

Rob Conery

Loads all of your tables, Postgres functions, and local query files up as functions; supports full text search; has full JSONB document support; has a REPL; and more.

More Than Oracle Knows What To Do With

Database Journal

Oracle’s latest database release has an unusual problem when joining tables with 500 or more columns.

Jobs

Database Administrator (Blacksburg, VA)Rackspace is seeking a Senior Database Administrator in our Blacksburg, VA office. The Senior DBA will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. Learn More.
Rackspace
DevOps Engineer (Austin, TX)ObjectRocket by Rackspace is seeking a DevOps Engineer to join our team in Austin. Do you believe Open Source will always innovate faster? Is “Automate Everything” printed on the back of your hoodie? Are you most comfortable on the cutting edge of technology? If this describes you and you’re ready to attack some of the most complex problems in the industry, then it’s time for you to take on the challenge of being a DevOps Engineer at Rackspace. Apply Today.
Rackspace

In brief

Recent Performance Improvements in Apache Spark news
Databricks
Experfy: The Uber of Big Data Projects news
Datanami
Generating Reports on MySQL Data tutorial
A tutorial on creating a simple report using the Navicat Admin GUI for MySQL.
Database Journal
CONCAT and STUFF Functions in SQL Server 2012 tutorial
Database Journal
Make Sure to Schedule Your SQL Server Replication Jobs tutorial
Matan Yungman
MySQL On Mesos: Today's Database Meets Tomorrow's Datacenter
Mesosphere
The 7 Best Data Science and Machine Learning Podcasts opinion
Matt Fogel
Rodeo: A Data-Centric IDE for Python tools
yhat
Linkurious: Web-Based Data Visualization for Graph Databases tools
Linkurious SAS
liblfds: Portable, License-Free, Lock-Free Data Structure Library for C code
liblfds.org
SquiDB: A SQLite Database Layer for Android by Yahoo code
SquiDB combines features of an ORM with object-oriented SQL statement builders to make it easy to read and write your data without a bunch of messy SQL strings.
Yahoo Inc.