--- title: "This week's database news, issue 59" publication: "DB Weekly" issue: 59 published_at: "2015-05-22" canonical_url: "https://dbweekly.com/issues/59" --- This week's database news, issue 59 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/59) DB WeeklyIssue 59 — May 22, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [MemSQL 4 Released, Available in New 'Community Edition'](http://blog.memsql.com/memsql-community-edition/?utm_source=dbweekly&utm_medium=email)MemSQLMemSQL is a real-time database for transactions and analytics and it’s now open to everyone in the form of a free ‘community edition’ release. [The Sea of SQL](http://thedailywtf.com/articles/sea-of-sql?utm_source=dbweekly&utm_medium=email)The Daily WTFA 4986 character SQL query with surprisingly little duplication. If you fancy trying to work out what a query is doing in your lunch hour, start here. [JSON Support Coming to SQL Server 2016](http://blogs.msdn.com/b/jocapc/archive/2015/05/16/json-support-in-sql-server-2016.aspx?utm_source=dbweekly&utm_medium=email)MicrosoftNoSQL continues to have an impact outside of its niche with Microsoft rolling JSON support into SQL Server. Jovan Popovic shows off how it’ll work. [See What Tinder is doing to Scale their MongoDB](http://solve.rackspace.com/sfo2/03.html?cm_mmc=data_bigdata_tinder-video_dbweekly-newsletter)RackspaceWatch as Tinder CTO, Ryan Ogle, as he gives you an inside look into their IT strategy and the real-world solutions that are helping them scale their business, manage big data, and navigate digital trends. [View Now.](http://solve.rackspace.com/sfo2/03.html?cm_mmc=data_bigdata_tinder-video_dbweekly-newsletter) [![Rackspace\](http://s3.amazonaws.com/nlga/uploads/item/image/37697/i.png)](http://solve.rackspace.com/sfo2/03.html?cm_mmc=data_bigdata_tinder-video_dbweekly-newsletter) [Top 10 Data Mining Algorithms in Plain English](http://rayli.net/blog/data/top-10-data-mining-algorithms-in-plain-english/?utm_source=dbweekly&utm_medium=email)Raymond LiCovers C4.5, k-means, SVM, PageRank, Bayes and others. If you want simple, straightforward explanations, check it out. [Yahoo's MySQL Performance Analyzer](https://github.com/yahoo/mysql_perf_analyzer?utm_source=dbweekly&utm_medium=email)Yahoo Inc.MySQL Performance Analyzer is an open source, Java-based project for MySQL performance monitoring and analysis. [SQL MERGE Is Quite Distinct From UPSERT](http://www.postgresql.org/message-id/CAM3SWZRP0c3g6+aJ=YYDGYAcTZg0xA8-1_FCVo5Xm7hrEL34kw@mail.gmail.com?utm_source=dbweekly&utm_medium=email)Peter GeogheganWhy is Postgres pursuing a non-standard variant of UPSERT rather than SQL’s MERGE? A developer explains why: they’re quite different things. [Your Data Fits in RAM](https://news.ycombinator.com/item?id=9581862)Hacker NewsSome discussion around the implications of a recent [tweet](https://twitter.com/garybernhardt/status/600783770925420546) by Gary Bernhardt leaning on the idea that servers with 6TB of memory can help alleviate ‘big data problems’. Jobs - [Senior Database Administrator (Austin, TX)](https://uscareers-rackspace.icims.com/jobs/9847/mongodb-administrator/job?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-Mongojob)ObjectRocket by Rackspace is seeking a Mid-to-Senior level DBA to join our Engineering team to work on our scalable, highly-available DBaaS 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) Rackspace In brief - [In-Database R coming to SQL Server 2016](http://blog.revolutionanalytics.com/2015/05/r-in-sql-server.html?utm_source=dbweekly&utm_medium=email) news “With this update, data scientists will no longer need to extract data from SQL server via ODBC to analyze it with R. Instead, you will be able to take your R code to the data.” Revolution Analytics - [A Lockbox in The Cloud: Microsoft Research Project Reveals New Method for Keeping Data Private](http://blogs.microsoft.com/next/2015/05/18/a-lockbox-in-the-cloud-microsoft-research-project-reveals-new-method-for-keeping-data-private/?utm_source=dbweekly&utm_medium=email) news Next at Microsoft - [Workload Analysis with MySQL's Performance Schema](http://githubengineering.com/using-mysql-performance-schema-for-workload-analysis/?utm_source=dbweekly&utm_medium=email) tutorial GitHub Engineering - [Getting the First Row per Group 5X Faster (with SQL)](https://periscope.io/blog/first-row-per-group-5x-faster.html?utm_source=dbweekly&utm_medium=email) tutorial Periscope - [Think Twice, Join Once: Distinct On in PostgreSQL](http://www.noelherrick.com/blog/postgres-distinct-on?utm_source=dbweekly&utm_medium=email) tutorial Noel Herrick - [Using MySQL's Experimental HTTP API with Ruby](http://ilyabylich.svbtle.com/experimental-mysql-http-api-and-ruby?utm_source=dbweekly&utm_medium=email) tutorial Ilya Bylich - [Why The Hate for MS Access?](http://www.reddit.com/r/Database/comments/36djqw/why_the_hate_for_ms_access/?utm_source=dbweekly&utm_medium=email) opinion Reddit - [Faster Responses: Data and Query Caching using Redis](https://www.airpair.com/javascript/posts/data-and-query-caching-using-redis?utm_source=dbweekly&utm_medium=email) opinion Shivang Doshi - [Why Auto Increment Is A Terrible Idea](https://www.clever-cloud.com/blog/engineering/2015/05/20/Why-Auto-Increment-Is-A-Terrible-Idea/?utm_source=dbweekly&utm_medium=email) opinion Clément Delafargue 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/59) © 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)