DB Weekly
Issue 56 — April 24, 2015
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.
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.)
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.
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
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.
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.
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.