---
title: "This week's database news, issue 105"
publication: "DB Weekly"
issue: 105
published_at: "2016-05-19"
canonical_url: "https://dbweekly.com/issues/105"
---

Database Weekly 105   . 

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

[Database Weekly](http://dbweekly.com) Issue 105 — May 19, 2016     

Featured [OmniDB: An Open Source Web Tool for DB Management](http://omnidb.com.br/en_index.html?utm_source=dbweekly&utm_medium=email) — Works with Oracle, MySQL, SQLite, SQL Server, and more, lets you make queries, see visual schemas, interact with tables directly, etc. OmniDBtools [How to Find a DBA Job (Interview with Brent Ozar)](http://www.sqlserverradio.com/brent-ozar-2/?utm_source=dbweekly&utm_medium=email) — An SQL Server Radio interview with Brent Ozar about what a DBA needs to know in order to get a job in the modern database world. Matan Yungman [7 Handy SQL Scripts for SQL Developers](http://code.tutsplus.com/tutorials/7-handy-sql-scripts-for-sql-developers--cms-25834?utm_source=dbweekly&utm_medium=email) — “a few SQL scripts which have proven to be very useful for my daily job as a SQL developer..” Sovit Poudeltutorial [CQRS and Event Sourcing made easy with RavenDB](http://ravendb.net/articles/cqrs-and-event-sourcing-made-easy-with-ravendb) — CQRS enables us to meet a wide range of architectural challenges; achieving scalability, managing complexity & changing business rules. Storing data using the Event Sourcing technique is the only way to never lose data. In this article, we will discuss some alternatives to adopt CQRS & Event Sourcing. RavenDBsponsored [![\](https://copm.s3.amazonaws.com/6ca16c32.png)](http://ravendb.net/articles/cqrs-and-event-sourcing-made-easy-with-ravendb) [BTrDB: Optimizing Storage System Design for Timeseries Processing](https://blog.acolyer.org/2016/05/04/btrdb-optimizing-storage-system-design-for-timeseries-processing/?utm_source=dbweekly&utm_medium=email) — A look at a full time-series DB created with just 4,709 lines of Go code - in a year, it stored 2.1 trillion data points, and supported 119M queries per second in a four-node cluster. the morning papertools [Module Hub: A Marketplace for Redis Modules](http://redismodules.com/?utm_source=dbweekly&utm_medium=email) — Last week we covered how Redis is [gaining a loadable module system](http://www.antirez.com/news/106?utm_source=dbweekly&utm_medium=email), and already a central repository for them has appeared. Redis Labstools [BigQuery and Dataproc Shine in Independent Big Data Platform Comparison](https://cloud.google.com/blog/big-data/2016/05/bigquery-and-dataproc-shine-in-independent-big-data-platform-comparison?utm_source=dbweekly&utm_medium=email) — Big data expert Mark Litwintschik benchmarks Google BigQuery, Hadoop, Spark, ElasticSearch, Presto and Google Cloud Dataproc with interesting results. Google Cloudtutorial [How to Add A New Keyword to SQL's Grammar in Postgres](http://shaplov.livejournal.com/903924.html?utm_source=dbweekly&utm_medium=email) — A simple example of some low-level hacking on the Postgres source code. Svami Dhyan Natarajtutorial Jobs [Work on a Better Stack](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=betterstack&utm_campaign=q2-16-dbweekly&utm_location=us) — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly. Hired.​com In brief [Free Redis Shirt](https://www.compose.io/redis?utm_source=cooper&utm_medium=newsletter-redis-shirt&utm_campaign=redis-shirt) — This month only, deploy Redis on Compose, get a free Redis tshirt. There's no obligation to keep your Redis deployment, but of course we hope you love it as much as you love the shirt. Composesponsored [OrientDB v2.2 Released: Improved Security, Performance, Ops and APIs](http://orientdb.com/released-orientdb-v2-2/?utm_source=dbweekly&utm_medium=email) OrientDBnews tools [SqlSmash Now Has A Free Community Version](http://www.ssmstipsandtricks.com/blog/2016/05/01/sqlsmash-now-has-a-free-community-version/?utm_source=dbweekly&utm_medium=email) — SqlSmash is a plugin for SQL Server Management Studio for writing SQL scripts. Latish Sehgalnews tools [SQL Vs. NoSQL: What's The Difference?](https://www.upwork.com/hiring/data/sql-vs-nosql-databases-whats-the-difference/?utm_source=dbweekly&utm_medium=email) — A brief, high level introduction. One for clients/bosses/etc. Carey Wodehousetutorial [Creating Activity Feeds in PostgreSQL 9.5](http://blog.chaps.io/2016/05/18/creating-activity-feeds-in-postgresql.html?utm_source=dbweekly&utm_medium=email) — A look at how to create modern activity feeds with Facebook-like grouping using only Postgres. Piotr Okonskitutorial [Hadoop Past, Present, and Future](http://www.datanami.com/2016/05/17/hadoop-past-present-future/?utm_source=dbweekly&utm_medium=email) — It’s been a decade since Hadoop was first created as an Apache top-level project. Bog Mugliaopinion [Apache's Wacky But Winning Recipe for Big Data Development](http://www.datanami.com/2016/05/12/apaches-wacky-winning-recipe-big-data-development/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [Why We Migrated Away From Librato to InfluxDB?](http://zemanta.github.io/2016/05/10/from-librato-to-influxdb/?utm_source=dbweekly&utm_medium=email) Zemantaopinion [Time Series, The New Shiny?](http://basho.com/posts/technical/time-series-the-new-shiny/?utm_source=dbweekly&utm_medium=email) Alexander Sicularopinion [InfluxDB Markedly Outperforms Elasticsearch in Time-Series Data & Metrics Benchmark](https://influxdata.com/blog/influxdb-markedly-elasticsearch-in-time-series-data-metrics-benchmark/?utm_source=dbweekly&utm_medium=email) InfluxDataopinion [Explore your Redis memory usage with RedisGreen](http://www.redisgreen.net/memory-analysis/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2016b&utm_content=link&utm_term=explore+model+memory) — RedisGreen's new memory map models your database, helping you track down problems and gain new insights. RedisGreentools sponsored [Metabase: An Open Source Way to Share and Query Data Within A Company](http://www.metabase.com/?utm_source=dbweekly&utm_medium=email) Metabasetools [pgsync: Sync Postgres Data to Your Local Machine](https://github.com/ankane/pgsync?utm_source=dbweekly&utm_medium=email) — A handy utility inspired by Heroku’s pgtransfer for copying data from your production DB to a local instance. Andrew Kanecode [qb: A Database Toolkit for Go](https://qb.readme.io/?utm_source=dbweekly&utm_medium=email) readme.​iocode    

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