DB Weekly Issue 105: May 19, 2016

OmniDB: An Open Source Web Tool for DB Management — Works with Oracle, MySQL, SQLite, SQL Server, and more, lets you make queries, see visual schemas, interact with tables directly, etc.

How to Find a DBA Job (Interview with Brent Ozar) — 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.

7 Handy SQL Scripts for SQL Developers — "a few SQL scripts which have proven to be very useful for my daily job as a SQL developer.."

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.

BTrDB: Optimizing Storage System Design for Timeseries Processing — 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.

Module Hub: A Marketplace for Redis Modules — Last week we covered how Redis is gaining a loadable module system, and already a central repository for them has appeared.

BigQuery and Dataproc Shine in Independent Big Data Platform Comparison — Big data expert Mark Litwintschik benchmarks Google BigQuery, Hadoop, Spark, ElasticSearch, Presto and Google Cloud Dataproc with interesting results.

How to Add A New Keyword to SQL's Grammar in Postgres — A simple example of some low-level hacking on the Postgres source code.

Work on a Better Stack — 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.

Free 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.

OrientDB v2.2 Released: Improved Security, Performance, Ops and APIs

SqlSmash Now Has A Free Community Version — SqlSmash is a plugin for SQL Server Management Studio for writing SQL scripts.

SQL Vs. NoSQL: What's The Difference? — A brief, high level introduction. One for clients/bosses/etc.

Creating Activity Feeds in PostgreSQL 9.5 — A look at how to create modern activity feeds with Facebook-like grouping using only Postgres.

Hadoop Past, Present, and Future — It’s been a decade since Hadoop was first created as an Apache top-level project.

Apache's Wacky But Winning Recipe for Big Data Development

Why We Migrated Away From Librato to InfluxDB?

Time Series, The New Shiny?

InfluxDB Markedly Outperforms Elasticsearch in Time-Series Data & Metrics Benchmark

Explore your Redis memory usage with RedisGreen — RedisGreen's new memory map models your database, helping you track down problems and gain new insights.

Metabase: An Open Source Way to Share and Query Data Within A Company

pgsync: Sync Postgres Data to Your Local Machine — A handy utility inspired by Heroku’s pgtransfer for copying data from your production DB to a local instance.

qb: A Database Toolkit for Go