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

Database Weekly 109   . 

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

[Database Weekly](http://dbweekly.com) Issue 109 — June 17, 2016     

Featured [ClickHouse: Open-Source Distributed Column-Oriented DBMS](https://clickhouse.yandex/?utm_source=dbweekly&utm_medium=email) — An open-source column-oriented database management system that allows generating analytical data reports in real time. Yandextools [pickaxe: An SQL-Based DSL Web Scraper/Screen Scraper](https://github.com/bitsummation/pickaxe?utm_source=dbweekly&utm_medium=email) — A C# / Mono based Web scraper that takes a novel approach of letting you scrape the Web by building special SQL queries. There are lots of examples to look at. bitsummationtools [Elasticsearch-Based Image Search using RGB Signatures](http://sujitpal.blogspot.co.uk/2016/05/elasticsearch-based-image-search-using.html?utm_source=dbweekly&utm_medium=email) — An interesting technique to be able to use Elasticsearch to provide image searching functionality. Sujit Paltutorial [DreamFactory 2.2 released, includes important API changes](http://blog.dreamfactory.com/dreamfactory-2-2-release?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=2-2) — Our API automation platform keeps getting better with new streamlined commercial packages. DreamFactorysponsored [![\](https://copm.s3.amazonaws.com/c91662e0.png)](http://blog.dreamfactory.com/dreamfactory-2-2-release?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=2-2) [The Guts n’ Glory of Database Internals: B+Tree](https://ayende.com/blog/174402/the-guts-n-glory-of-database-internals-b-tree?Key=d51798d4-af8e-4f40-8bc4-04576d502b7e&utm_source=dbweekly&utm_medium=email) — _“The absolute worst thing about B+Trees is their name. It is like someone maliciously considered all the possible names and then selected the most confusing one.”_ Ayende Rahientutorial [VisualAlchemist: A Web-Based Database Diagramming Tool](https://github.com/prahladyeri/VisualAlchemist?utm_source=dbweekly&utm_medium=email) — An open-source Web-based database diagramming tool that’s under active development and looking for contributors - check out [the online demo.](http://visualalchemist.prahladyeri.com/) Prahlad Yericode [PostgreSQL Exercises](https://pgexercises.com/?utm_source=dbweekly&utm_medium=email) — If you’re looking for a way to practice your SQL skills some PG Exercises offers some good example data and exercises to hone your skills. pgexercises.​com [10 Reasons to Migrate to MariaDB (If Still using MySQL)](https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql?utm_source=dbweekly&utm_medium=email) — A better ecosystem, increased popularity, more storage engines, and potential for future data incompatibility are pressing reasons, says Seravo. Seravo Oyopinion Jobs [Hired is the best place to find engineering jobs.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=bestplace&utm_campaign=q2-16-dbweekly&utm_location=us) — Bored at work? Want to try a new stack? Find 3500+ great tech companies on Hired who will compete to hire you. [Try it today.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=bestplace&utm_campaign=q2-16-dbweekly&utm_location=us) Hired.​com In brief [PGDay UK 2016 (London, July 5)](http://www.pgconf.uk/?utm_source=dbweekly&utm_medium=email) — The UK’s only dedicated PostgresSQL annual user conference returns next month. PostgreSQL UK Usergroupnews [MemSQL Introduces New Enterprise Security Capabilities](http://www.datanami.com/this-just-in/memsql-introduces-new-enterprise-security-capabilities/?utm_source=dbweekly&utm_medium=email) Datanaminews [SQL Server 2016 Developer Image Now in The Azure Gallery](https://azure.microsoft.com/en-us/blog/announcing-sql-server-2016-developer-image-in-the-azure-gallery/?wt.mc_id=WW_ABG_MAPPS_OO_SCL_TW&Ocid=C%20E%20Social%20FY16_Social_TW_SQLServer_20160614_493864158&utm_source=dbweekly&utm_medium=email) — A free licensed version of SQL Server that you can use to develop and test SQL Server applications. Luis Vargasnews tools [Considering migration to PostgreSQL? Get help from the experts](http://2ndquadrant.com/en/services/postgresql-deployment/migrate/?utm_source=dbweekly&utm_medium=email) — From initial migration assessments and migration assistance, to training and 24/7 technical support, turn to the PostgreSQL professionals for the most comprehensive service. 2ndQuadrant.​comsponsored [How to Lock Down Elasticsearch, Kibana, and Logstash and Maintain Security](https://qbox.io/blog/how-to-lock-down-elasticsearch-kibana-logstash-maintain-security?utm_source=dbweekly&utm_medium=email) Adam Vanderbushtutorial [An Introduction to Data Models for MMO Games](http://www.vertabelo.com/blog/technical-articles/mmo-games-and-database-design?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [Advanced MySQL Basics](http://www.bigeng.io/advanced-mysql-basics/?utm_source=dbweekly&utm_medium=email) Tim Ellistutorial [Scaling Out MySQL with PostgreSQL and Citus](https://www.citusdata.com/blog/1907-eren-ba%C5%9Fak/419-scaling-out-mysql-postgresql-and-citus?utm_source=dbweekly&utm_medium=email) — How PostgreSQL and Citus can help to scale out existing MySQL data. Eren Başaktutorial [Copying Data from Postgres to Redshift](https://www.toothrot.net/2016/06/13/postgres-to-redshift-announce.html?utm_source=dbweekly&utm_medium=email) Alexander Rakoczytutorial [Efficient Color Similarity Searching with Postgres](http://zejn.net/b/2016/06/10/postgresql-tutorial-color-similarity-search/?utm_source=dbweekly&utm_medium=email) — A novel example of what you can do with Postgres and computing similarity. Gašper Žejntutorial [PG Casts: Postgres Screencasts](https://www.pgcasts.com/?utm_source=dbweekly&utm_medium=email) Jack Christensenvideo [What If Apache Spark Was Also The Database?](http://www.snappydata.io/blog/what-if-apache-spark-was-also-the-database?utm_source=dbweekly&utm_medium=email) Pierce Lambopinion [Is Spark Overhyped?](http://www.datanami.com/2016/06/16/is-spark-overhyped/?utm_source=dbweekly&utm_medium=email) — _“The Apache Spark phenomena has taken the big data world by storm. But can the technology actually deliver according to the tremendous hype that is accompanying it, or has it been oversold?”_ Alex Woodieopinion [Why SQL Injection Vulnerabilities Still Exist](https://dzone.com/articles/why-sql-injection-vulnerabilities-still-existy?utm_source=dbweekly&utm_medium=email) Dan Kuykendallopinion [Have you got SQL fingers?](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24850#sql-fingers) — Try SQL Prompt and you’ll be able to write, refactor, and reformat SQL effortlessly in SSMS and Visual Studio. [Find out more.](http://www.red-gate.com/products/sql-development/sql-prompt/?utm_source=dbweekly&utm_medium=displayemail&utm_content=sqlfingers_v2&utm_campaign=sqlprompt&utm_term=email-24850#sql-fingers) Red Gatetools sponsored [pg_view: Get A Detailed, Real-time View of Your PostgreSQL Database and System Metrics](https://github.com/zalando/pg_view?utm_source=dbweekly&utm_medium=email) Zalando SEtools [Microsoft SQL Server 2014 Express in a Docker Container](https://hub.docker.com/r/microsoft/mssql-server-2014-express-windows/?utm_source=dbweekly&utm_medium=email) Docker Hubtools    

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