---
title: "This week's database news, issue 72"
publication: "DB Weekly"
issue: 72
published_at: "2015-09-25"
canonical_url: "https://dbweekly.com/issues/72"
---

Database Weekly 72   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/72) 

[Database Weekly](http://dbweekly.com) Issue 72 — September 25, 2015     

Featured [Scylla DB: An Apache Cassandra-compatible Database Written in C++](http://www.scylladb.com/?utm_source=dbweekly&utm_medium=email) — From the team behind KVM comes a new open source database that promises to be the ‘world’s fastest column-store database’. It’s Apache Cassandra compatible and can just be dropped in. Scylla [SQL vs NoSQL: How to Choose](http://www.sitepoint.com/sql-vs-nosql-choose/?utm_source=dbweekly&utm_medium=email) — A look at some different scenarios and applying the right criteria to choose whether the SQL or NoSQL route is right for them. Craig Buckleropinion [9 Tips for Better Database Design](http://www.vertabelo.com/blog/notes-from-the-lab/9-tips-for-better-database-design?utm_source=dbweekly&utm_medium=email) — Plan ahead, document your model, follow conventions, think carefully about your keys, use integrity checks carefully, and more. Jeffrey Edison [Real-time Database Monitoring at Any Scale with Datadog](http://dtdg.co/1PkYlNZ) — Use Datadog's turn-key integrations to seamlessly aggregate metrics and events across your databases and entire devops stack. Gain powerful insight into all your apps, tools and services. Begin your Free Datadog Trial today! Datadogsponsored [![\](https://copm.s3.amazonaws.com/b3734b7e.png)](http://dtdg.co/1PkYlNZ) [Handling Circular Data Structures in Postgres](https://www.garysieling.com/blog/handling-circular-data-structures-in-postgres?utm_source=dbweekly&utm_medium=email) — If you’re dealing with groups that contain other groups, or any other kind of nested structure the default might be to simply make a bunch of separate database calls from within your app. Fortunately with recursive queries there is a better way. Gary Sieling [A New Breed of Database Hopes to Blend The Best of NoSQL and RDBMS](http://www.techrepublic.com/article/a-new-breed-of-database-hopes-to-blend-the-best-of-nosql-and-rdbms/?utm_source=dbweekly&utm_medium=email) — Multi-model databases may help tame the growing complexity of enterprise data. Matt Asay explains. TechRepublic [Yesquel: Scalable SQL Storage for Webapps [PDF\]](http://sigops.org/sosp/sosp15/current/2015-Monterey/printable/106-aguilera.pdf?utm_source=dbweekly&utm_medium=email) — “We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NoSQL with all the features of a SQL relational system.” An academic paper. Aguilera, Leners, Walfish In brief [Elasticsearch 2.0.0-beta2 Released](https://www.elastic.co/blog/elasticsearch-2-0-0-beta2-released?utm_source=dbweekly&utm_medium=email) — The final Elasticsearch 2.0 is just around the corner. Elasticnews [Enterprise Cassandra Gets a Storage Boost](http://www.enterprisetech.com/2015/09/22/enterprise-cassandra-gets-a-storage-boost/?utm_source=dbweekly&utm_medium=email) Enterprise Technews [Inside Platfora's Transition to Apache Spark](http://www.datanami.com/2015/09/22/inside-platforas-transition-to-apache-spark/?utm_source=dbweekly&utm_medium=email) Datanaminews [Tape Storage Spec Jumps to 15TB](http://www.datanami.com/2015/09/15/tape-storage-spec-jumps-to-15tb/?utm_source=dbweekly&utm_medium=email) — You’ve got to keep that data backed up somewhere. Datanaminews [Better Density and Lower Prices for Azure’s SQL Elastic Database Pools](http://weblogs.asp.net/scottgu/better-density-and-lower-prices-for-azure-s-sql-elastic-database-pools?utm_source=dbweekly&utm_medium=email) Scott Guthrienews [Working with Email Addresses in SQL](https://blog.modeanalytics.com/working-email-addresses-sql/?utm_source=dbweekly&utm_medium=email) — Check if an email is valid (with a regexp - be careful!), split an email into its key parts, and more, all from SQL. Benn Stanciltutorial [Real-Time Search With MongoDB and Solr](http://geniuscarrier.com/real-time-search-with-mongodb-and-solr/?utm_source=dbweekly&utm_medium=email) Yang Zhaotutorial [Delightful Database Seeding with Docker](https://ardoq.com/delightful-database-seeding-with-docker/?utm_source=dbweekly&utm_medium=email) — “Using Docker we have created a user friendly tool that anyone in our organization can use, (even sales) both when resetting a demo laptop, and when getting a new on-site installation quickly up and running.” Kristian Helgesentutorial [Using the SQLite JSON Extension with Python](http://charlesleifer.com/blog/using-the-sqlite-json-extension-with-python/?utm_source=dbweekly&utm_medium=email) Charles Leifertutorial [Storing Data with Redis](http://www.mikeperham.com/2015/09/24/storing-data-with-redis/?utm_source=dbweekly&utm_medium=email) — “Would you stuff all of your data into one database table? That’s crazy, Mike, don’t be silly! What if I told you most people do just that with Redis?” Mike Perhamopinion [The Simple Power of Elasticsearch Analyzers](http://opensourceconnections.com/blog/2015/09/18/the-simple-power-of-elasticsearch-analyzers/?utm_source=dbweekly&utm_medium=email) Doug Turnbullopinion [The SELECT Problem in Redis](http://www.federicopereiro.com/redis-select/?utm_source=dbweekly&utm_medium=email) — “The need to maintain your own indexes for structured data is the sole reason that makes Redis unsuitable for certain applications.” Federico Pereiroopinion [How Medium Detects Hotspots in DynamoDB using ElasticSearch, Logstash and Kibana](https://medium.com/medium-eng/how-medium-detects-hotspots-in-dynamodb-using-elasticsearch-logstash-and-kibana-aaa3d6632cfd?utm_source=dbweekly&utm_medium=email) Medium Engineering [Deploy An Elastic High-Availability SQL Cluster with Crate and Weave](https://blog.giantswarm.io/deploy-elastic-high-availability-sql-cluster-crate-weave/?utm_source=dbweekly&utm_medium=email) Giant Swarmtools [PolyBase in SQL Server 2016](https://channel9.msdn.com/Shows/Data-Exposed/PolyBase-in-SQL-Server-2016?utm_source=dbweekly&utm_medium=email) — PolyBase is a new feature that integrates SQL Server Parallel Data Warehouse (PDW) with Hadoop. Channel 9tools video    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/72) [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