--- title: "This week's database news, issue 60" publication: "DB Weekly" issue: 60 published_at: "2015-05-29" canonical_url: "https://dbweekly.com/issues/60" --- This week's database news, issue 60 This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/60) DB WeeklyIssue 60 — May 29, 2015 Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email) [Can Anyone Provide A Sound Argument for Choosing MySQL Over Postgres?](https://news.ycombinator.com/item?id=9586504)Hacker NewsIt’s not easy, but some people fight MySQL’s corner pretty well. [Content Recommendation From Links Shared on Twitter Using Neo4j and Python](https://www.airpair.com/posts/review/55635b0ce7480311007471ee?utm_source=dbweekly&utm_medium=email)William LyonA look at how to use a graph database to implement a feature that recommends articles to users based on other articles they’ve shared on Twitter. [Modelling a Game Economy with Neo4j](http://theburningmonk.com/2015/04/modelling-game-economy-with-neo4j/?utm_source=dbweekly&utm_medium=email)Yan CuiA look at some of the concepts behind modelling the economy within a game using a graph database. [Which Database Should You Use and When?](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter)BrightTALKSponsoredCheck out this webcast recording which covers 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. [View Now.](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter) [![BrightTALK\](http://s3.amazonaws.com/nlga/uploads/item/image/36259/i.png)](https://www.brighttalk.com/webcast/11427/152031/?cm_mmc=data-_-bigdata-_-MySQL-Webinar-_-dbweekly-newsletter) [Couchbase Server Hits 1M Writes/sec with 3B Items with 50 Nodes On Google Cloud](http://blog.couchbase.com/couchbase-server-hits-1m-writes-with-3b-items-with-50-nodes-on-google-cloud?utm_source=dbweekly&utm_medium=email)Couchbase“Couchbase Server was able to sustain 1.1 million writes per second. The data set size was 3 billion items with a value size of 200 bytes.” [Adobe Migrated An Activity Feed from Mongo to Cassandra](http://planetcassandra.org/blog/interview/picture-perfect-scale-and-savings-adobes-behance-migrates-their-activity-feed-from-mongodb-to-apache-cassandra-for-70-cost-savings/?utm_source=dbweekly&utm_medium=email)Mark DumphyAnd got a 70% cost savings. Why and how? [The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4](http://blog.2ndquadrant.com/the-within-group-and-filter-sql-clauses-of-postgresql-9-4/?utm_source=dbweekly&utm_medium=email)2nd QuadrantSometimes complex orderings then calculations over data can be a bit complicated in SQL. Postgres 9.4 quietly brought a few new functions that make it more powerful and easier to iterate over groups of data for things like percentiles and more. [Temporal in SQL Server 2016](http://channel9.msdn.com/Shows/Data-Exposed/Temporal-in-SQL-Server-2016?WT.mc_id=dlvr_twitter_ch9)Channel 9Temporal in SQL Server is designed to simply the handling of time-varying data. It provides the ability to look at data trends, types of data changes, and the overall data evolution within your database. 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 In brief - [Microsoft's Study into NoSQL Usage for .NET Applications](http://www.instant.ly/s/W4AKL/nav#p/186a0?utm_source=dbweekly&utm_medium=email) news If you can help Microsoft’s Data Platform Team, check out this survey. Microsoft Data Platform Team - [PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 Released](http://www.postgresql.org/about/news/1587/?utm_source=dbweekly&utm_medium=email) news postgresql.org - [Postgres Pushes Past MySQL in Developers' Hearts](http://www.techrepublic.com/article/postgres-pushes-past-mysql-in-developer-hearts/?utm_source=dbweekly&utm_medium=email) news TechRepublic - [MySQL 5.7's Key Features](https://www.percona.com/blog/2015/05/27/mysql-5-7-key-features/?utm_source=dbweekly&utm_medium=email) news Muhammad Irfan - [SQL Server to add JSON Support](http://www.infoq.com/news/2015/05/SQL-Server-JSON?utm_source=dbweekly&utm_medium=email) news InfoQ - [Collaborative Filtering Recommender System Use Case Scenario in OrientDB](https://wildgraph.wordpress.com/2015/05/05/collaborative-filtering-recommender-system-use-case-scenario-in-orientdb/?utm_source=dbweekly&utm_medium=email) tutorial A way of using a graph database like OrientDB for building a recommendation system. wildgraph - [Preventing SQL Injection in PHP Applications - the Easy and Definitive Guide](https://paragonie.com/blog/2015/05/preventing-sql-injection-in-php-applications-easy-and-definitive-guide?utm_source=dbweekly&utm_medium=email) tutorial Paragon Initiative Enterprises - [Typechecking SQL in Slick and doobie (in Scala)](http://underscore.io/blog/posts/2015/05/28/typechecking-sql.html?utm_source=dbweekly&utm_medium=email) tutorial Richard Dallaway - [SQL Server Radio: An SQL Server Podcast](http://www.sqlserverradio.com/?utm_source=dbweekly&utm_medium=email) Madeira SQL Server Services - [3 Must-Read Books About Database Performance](http://www.databasefriends.co/2015/05/3-must-read-books-about-database.html?utm_source=dbweekly&utm_medium=email) Database Friends - [A Review of Kent Graziano’s 'A Check List for Doing Data Model Design Reviews'](http://www.vertabelo.com/blog/notes-from-the-lab/a-check-list-for-doing-data-model-design-reviews?utm_source=dbweekly&utm_medium=email) opinion Grzegorz Kaczor - [Simple Scheduled Backups for MongoDB](http://afshinm.name/scheduled-backup-for-mongodb?utm_source=dbweekly&utm_medium=email) tools Afshin Mehrabani - [Awesome MySQL: A Curated List of MySQL Resources and Tools](http://shlomi-noach.github.io/awesome-mysql/?utm_source=dbweekly&utm_medium=email) tools Shlomi Noach - [elasticsearch-sql: Use SQL to Query Elasticsearch](https://github.com/NLPchina/elasticsearch-sql?utm_source=dbweekly&utm_medium=email) code Query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL. NLPChina - [mgfs: Mount A MongoDB Database As A Filesystem](https://github.com/amsa/mgfs?utm_source=dbweekly&utm_medium=email) code Amin - [Reqlite: RethinkDB in JavaScript](https://github.com/neumino/reqlite?utm_source=dbweekly&utm_medium=email) code An implementation of a ReQL server in JavaScript. 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/60) © 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)