--- title: "This week's database news, issue 56" publication: "DB Weekly" issue: 56 published_at: "2015-04-24" canonical_url: "https://dbweekly.com/issues/56" --- This week's database news, issue 56 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/56) DB WeeklyIssue 56 — April 24, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [A Tiny Intro to Database Systems](http://blog.dancrisan.com/a-tiny-intro-to-database-systems?utm_source=dbweekly&utm_medium=email)Dan CrisanA 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](https://blog.twitter.com/2015/another-look-at-mysql-at-twitter-and-incubating-mysos?utm_source=dbweekly&utm_medium=email)TwitterTwitter 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](http://objectrocket.com/blog/how-to/overview-of-redis/?cm_mmc=data-_-redis-_-Redis-overview-_-dbweekly-newsletter)RackspaceSponsoredNew 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.](http://objectrocket.com/blog/how-to/overview-of-redis/?cm_mmc=data-_-redis-_-Redis-overview-_-dbweekly-newsletter) [![Rackspace\](http://s3.amazonaws.com/nlga/uploads/item/image/35931/i.png)](http://objectrocket.com/blog/how-to/overview-of-redis/?cm_mmc=data-_-redis-_-Redis-overview-_-dbweekly-newsletter) [Yes SQL! Celebration at Oracle BI Warehousing and Analytics Summit 2015](https://www.youtube.com/watch?v=CXg7DOnp3os)YouTubeJoin 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](http://www.transformy.io/?utm_source=dbweekly&utm_medium=email)TransformyPaste 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](https://github.com/robconery/massive-js?utm_source=dbweekly&utm_medium=email)Rob ConeryLoads 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](http://www.databasejournal.com/features/oracle/more-than-oracle-knows-what-to-do-with.html?utm_source=dbweekly&utm_medium=email)Database JournalOracle’s latest database release has an unusual problem when joining tables with 500 or more columns. Jobs - [Database Administrator (Blacksburg, VA)](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job?utm_source=dbweekly&utm_medium=email)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.](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job) Rackspace - [DevOps Engineer (Austin, TX)](https://uscareers-rackspace.icims.com/jobs/13168/devops-engineer--objectrocket/job?utm_source=dbweekly&utm_medium=email)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.](https://uscareers-rackspace.icims.com/jobs/13168/devops-engineer--objectrocket/job) Rackspace In brief - [Recent Performance Improvements in Apache Spark](https://databricks.com/blog/2015/04/24/recent-performance-improvements-in-apache-spark-sql-python-dataframes-and-more.html?utm_source=dbweekly&utm_medium=email) news Databricks - [Experfy: The Uber of Big Data Projects](http://www.datanami.com/2015/04/20/experfy-the-uber-of-big-data-projects/?utm_source=dbweekly&utm_medium=email) news Datanami - [Generating Reports on MySQL Data](http://www.databasejournal.com/features/mysql/generating-reports-on-mysql-data.html?utm_source=dbweekly&utm_medium=email) 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](http://www.databasejournal.com/features/mssql/concat-and-stuff-functions-in-sql-server-2012.html?utm_source=dbweekly&utm_medium=email) tutorial Database Journal - [Make Sure to Schedule Your SQL Server Replication Jobs](http://www.madeirasql.com/make-sure-to-schedule-your-sql-server-replication-jobs/?utm_source=dbweekly&utm_medium=email) tutorial Matan Yungman - [MySQL On Mesos: Today's Database Meets Tomorrow's Datacenter](https://mesosphere.com/blog/2015/04/17/mysql-on-mesos-todays-database-meets-tomorrows-datacenter/?utm_source=dbweekly&utm_medium=email) Mesosphere - [The 7 Best Data Science and Machine Learning Podcasts](https://medium.com/@mattfogel/the-7-best-data-science-and-machine-learning-podcasts-e8f0d5a4a419?utm_source=dbweekly&utm_medium=email) opinion Matt Fogel - [Rodeo: A Data-Centric IDE for Python](https://github.com/yhat/rodeo?utm_source=dbweekly&utm_medium=email) tools yhat - [Linkurious: Web-Based Data Visualization for Graph Databases](http://linkurio.us/?utm_source=dbweekly&utm_medium=email) tools Linkurious SAS - [liblfds: Portable, License-Free, Lock-Free Data Structure Library for C](http://www.liblfds.org/?utm_source=dbweekly&utm_medium=email) code liblfds.org - [SquiDB: A SQLite Database Layer for Android by Yahoo](https://github.com/yahoo/squidb?utm_source=dbweekly&utm_medium=email) 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. 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/56) © 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)