DB Weekly Issue 109: June 17, 2016

ClickHouse: Open-Source Distributed Column-Oriented DBMS — An open-source column-oriented database management system that allows generating analytical data reports in real time.

pickaxe: An SQL-Based DSL Web Scraper/Screen Scraper — 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.

Elasticsearch-Based Image Search using RGB Signatures — An interesting technique to be able to use Elasticsearch to provide image searching functionality.

DreamFactory 2.2 released, includes important API changes — Our API automation platform keeps getting better with new streamlined commercial packages.

The Guts n’ Glory of Database Internals: B+Tree — "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."

VisualAlchemist: A Web-Based Database Diagramming Tool — An open-source Web-based database diagramming tool that’s under active development and looking for contributors - check out the online demo.

PostgreSQL Exercises — 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.

10 Reasons to Migrate to MariaDB (If Still using MySQL) — A better ecosystem, increased popularity, more storage engines, and potential for future data incompatibility are pressing reasons, says Seravo.

Hired is the best place to find engineering jobs. — 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.

PGDay UK 2016 (London, July 5) — The UK’s only dedicated PostgresSQL annual user conference returns next month.

MemSQL Introduces New Enterprise Security Capabilities

SQL Server 2016 Developer Image Now in The Azure Gallery — A free licensed version of SQL Server that you can use to develop and test SQL Server applications.

Considering migration to PostgreSQL? Get help from the experts — From initial migration assessments and migration assistance, to training and 24/7 technical support, turn to the PostgreSQL professionals for the most comprehensive service.

How to Lock Down Elasticsearch, Kibana, and Logstash and Maintain Security

An Introduction to Data Models for MMO Games

Advanced MySQL Basics

Scaling Out MySQL with PostgreSQL and Citus — How PostgreSQL and Citus can help to scale out existing MySQL data.

Copying Data from Postgres to Redshift

Efficient Color Similarity Searching with Postgres — A novel example of what you can do with Postgres and computing similarity.

PG Casts: Postgres Screencasts

What If Apache Spark Was Also The Database?

Is Spark Overhyped? — "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?"

Why SQL Injection Vulnerabilities Still Exist

Have you got 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.

pg_view: Get A Detailed, Real-time View of Your PostgreSQL Database and System Metrics

Microsoft SQL Server 2014 Express in a Docker Container