--- title: "This week's database news, issue 63" publication: "DB Weekly" issue: 63 published_at: "2015-07-10" canonical_url: "https://dbweekly.com/issues/63" --- Database Weekly 63 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/63) [Database Weekly](http://dbweekly.com) Issue 63 — July 10, 2015 Featured Sorry for the brief hiatus, but now we're back with a fresh lick of paint. Onward! :-) [PipelineDB: The Streaming SQL Database](http://www.pipelinedb.com/?utm_source=dbweekly&utm_medium=email) — An open-source relational database (based on PostgreSQL 9.4) that runs SQL queries continuously on streams, incrementally storing results in tables. PipelineDB [Data Modeling with Multi-Model Databases](http://radar.oreilly.com/2015/07/data-modeling-with-multi-model-databases.html?utm_source=dbweekly&utm_medium=email) — A case study for mixing different data models within the same data store, based around the open source multi-model database [ArangoDB.](https://github.com/ArangoDB/ArangoDB) Max Neunhöffer [Switching User Database On A Running System](https://labs.spotify.com/2015/06/23/user-database-switch/?utm_source=dbweekly&utm_medium=email) — Spotify shares the tale of what happened to switch all their user storage from Postgres to Cassandra. Spotify Labs [Bringing SSL and More to Compose MongoDB](https://www.compose.io/articles/bringing-ssl-and-more-to-compose-mongodb/?utm_source=cooper&utm_medium=newsletter&utm_campaign=mongossl) — There's a new MongoDB deployment option going into beta at Compose and it brings SSL connectivity and a new flexible configuration to the table. Rather than use MongoDB's SSL, we configure our deployments with our own special sauce that allows us to use the mongos router. Composesponsored — [![\](https://copm.s3.amazonaws.com/947ae30d.png)](https://www.compose.io/articles/bringing-ssl-and-more-to-compose-mongodb/?utm_source=cooper&utm_medium=newsletter&utm_campaign=mongossl) [Test PostgreSQL 9.5 Alpha in a Docker container](http://www.databasesoup.com/2015/07/test-postgresql-95-alpha-in-docker.html?utm_source=dbweekly&utm_medium=email) — Postgres 9.5 is around the corner and if you don’t want to wait until it’s fully released to start playing here’s a Docker container to get you up and running with it. databasesoup.​com [A First Forward Look at MongoDB 3.2](https://www.compose.io/articles/mongodb-3-2-a-first-forward-look/?utm_source=dbweekly&utm_medium=email) — MongoDB 3.2 is due by the end of the year, but what can we expect from it? Compose [Heroku Announces General Availability of Its Redis Solution](https://blog.heroku.com/archives/2015/6/25/heroku-redis-ga-and-introducing-heroku-data-links?utm_source=dbweekly&utm_medium=email) — Heroku’s in-house Redis hosting system is now generally available. A new feature called ‘Data Links’ has also been announced to let Heroku users easily do data federation; it uses Postgres’ foreign data wrappers under the hood. Heroku [MySQL Performance Optimization: 50% More Work with 60% Less Latency Variance](http://engineering.pinterest.com/post/122520169079/mysql-performance-optimization-50-more-work-with?utm_source=dbweekly&utm_medium=email) — A look at Pinterest’s path to discovering an optimal configuration for its MySQL cluster including benchmark results and what the configuration looks like in [these slides.](http://www.slideshare.net/denshikarasu/all-your-iops-are-belong-to-us-a-pinteresting-case-study-in-mysql-performance-optimization) Pinterest [Oracle's Biggest Database Foe: Could It Be Postgres?](http://www.techrepublic.com/article/oracles-biggest-database-foe-could-it-be-postgres/?utm_source=dbweekly&utm_medium=email) — An EnterpriseDB survey showed 77% of users are dedicating all new deployments to PostgreSQL with 37% reporting they had migrated existing apps from Oracle or Microsoft SQL Server to Postgres. TechRepublicopinion [The Data Lake](http://martinfowler.com/bliki/DataLake.html?utm_source=dbweekly&utm_medium=email) — A look at the concept of ‘data lakes’, a term taking off in popularity lately. Compared to warehouses, data lakes let providers push all their data in for future use without an aggregation stage. Martin Fowler In brief [10 Things You Didn't Know You Could Do with the Oracle Database](http://www.luxoft-training.com/news/10-things-you-didn-t-know-you-could-do-with-the-oracle-database/?utm_source=dbweekly&utm_medium=email) Alexander Pavlovskiyopinion [Slow PostgreSQL Performance? Don't Forget to Vacuum your Database](https://lob.com/blog/supercharge-your-postgresql-performance/?utm_source=dbweekly&utm_medium=email) lob.​com [Introducing Disque: An Open Source Message Broker From The Creator of Redis](http://www.thedotpost.com/2015/06/salvatore-sanfilippo-introducing-disque?utm_source=dbweekly&utm_medium=email) Salvatore Sanfilippovideo [The Chemical Wedding of RethinkDB and Node.js](https://www.airpair.com/javascript/posts/the-chemical-wedding-of-rethinkdb-and-nodejs?utm_source=dbweekly&utm_medium=email) Alisson Cavalcante Agiani [Examples of SQL to Couchbase N1QL Conversions](http://www.querycouchbase.com/?utm_source=dbweekly&utm_medium=email#/query) Couchbase [101 Things I Wish You Knew About SQL Server](http://thomaslarock.com/2015/06/101-things-i-wish-you-knew-about-sql-server/?utm_source=dbweekly&utm_medium=email) Thomas LaRockopinion [Cayley: An Open-Source Graph Database From Google](https://github.com/google/cayley?utm_source=dbweekly&utm_medium=email) Googlecode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/63) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK