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

Database Weekly 119   . 

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

[Database Weekly](http://dbweekly.com) Issue 119 — August 26, 2016     

Featured [Baidu Takes FPGA Approach to Accelerating SQL at Scale](http://www.nextplatform.com/2016/08/24/baidu-takes-fpga-approach-accelerating-big-sql/?utm_source=dbweekly&utm_medium=email) — Baidu sits on over an exabyte of data and processes around 100 petabytes per day so creative approaches to optimizing data intensive jobs are required. Nicole Hemsothstory [Forrester's Crowded NoSQL Wave Shows Abundant Options](https://www.datanami.com/2016/08/24/forresters-crowded-nosql-wave-shows-abundant-options/?utm_source=dbweekly&utm_medium=email) — A high level, commercial look at the increasingly crowded NoSQL database market, based on [an interesting report by Forrester](https://reprints.forrester.com/#/assets/2/361/'RES125643'/reports). Alex Woodienews [Building a Real-Time Recommendation Engine](https://neo4j.com/blog/real-time-recommendation-engine-data-science/?utm_source=dbweekly&utm_medium=email) — Learn how to build a real-time recommendation engine powered by social, similarity and cluster factors, all leveraging the power of advanced data science. Nicole Whitetutorial [Join us at DataLayer](https://datalayer.com/?utm_source=cooper&utm_medium=newsletter&utm_campaign=datalayer) — Hear speakers from GitHub, Adobe, ZenDesk many others as they discuss how their teams are optimizing the data layer to scale modern web and mobile apps. Reserve your seat now for this one day event on Sept. 28 in Seattle. Compose/DataLayersponsored [![\](https://copm.s3.amazonaws.com/5e602cec.png)](https://datalayer.com/?utm_source=cooper&utm_medium=newsletter&utm_campaign=datalayer) [The Road to CouchDB 2.0 Series](https://blog.couchdb.org/2016/08/23/check-out-the-road-to-couchdb-2-0-series/?utm_source=dbweekly&utm_medium=email) — A new major release for the CouchDB document database is on the way. This roundup includes numerous posts about what’s coming and when. CouchDBnews [VanillaDB: A Framework for Extensible Database System Prototypes](http://www.vanilladb.org/?utm_source=dbweekly&utm_medium=email) — A collection of simple, open source components designed to lower the barrier for prototyping new DB systems or learning DB internals. VanillaDBtools [ddldump: Dump A Clean Version of Your Tables' DDLs for Versioning](https://github.com/percolate/ddldump?utm_source=dbweekly&utm_medium=email) — Dump and version the schemas of your tables, while cleaning out things that would make it hard to version and check for differences. Percolatetools [What Datatype Should You Use to Represent Time in MySQL?](http://www.vertabelo.com/blog/technical-articles/what-datatype-should-you-use-to-represent-time-in-mysql-we-compare-datetime-timestamp-and-int?utm_source=dbweekly&utm_medium=email) — Whenever you need to save datetime data, a question arises about what MySQL type to use. Do you go with a native MySQL DATE type or use an INT field to store date and time info as a plain number? Francisco Clariatutorial Jobs [Find Your Perfect Company Match](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies. Hired.​com In brief [Open-Source Religion Won't Feed MariaDB](http://www.theregister.co.uk/2016/08/24/monty_interview/?utm_source=dbweekly&utm_medium=email) — “MySQL daddy Monty Widenius dismisses claims the MariaDB fork is veering away from open source.” Alexander J Martinnews [Bullish Forecast for Hadoop Despite Spark Hype](http://www.enterprisetech.com/2016/08/25/bullish-hadoop-forecast-despite-spark-hype/?utm_source=dbweekly&utm_medium=email) — 63% annual growth is expected for the Hadoop market over the next 5 years. EnterpriseTechnews [Analyzing San Francisco Crime Data with SQL](https://periscopedata.com/blog//safety-in-san-francisco.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [A Database Model to Manage Appointments and Organize Schedules](http://www.vertabelo.com/blog/technical-articles/manage-appointments-and-organize-schedules-with-this-database-model?utm_source=dbweekly&utm_medium=email) — The latest in Vertabelo’s database modelling series. Emil Drkušićtutorial [Using Apache Spark to Analyze Large Neuroimaging Datasets](https://blog.dominodatalab.com/pca-on-very-large-neuroimaging-datasets-using-pyspark/?utm_source=dbweekly&utm_medium=email) — Very complex but great to see applications like this. Sergul Aydore and Syed Ashrafullatutorial [Installing DreamFactory from source on Ubuntu 14.0.4 LTS](http://blog.dreamfactory.com/installing-dreamfactory-from-source-on-ubuntu-14.0.4-lts?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=ubuntu) — DreamFactory auto-generates a rich API platform from any database. Here’s a quick tutorial for a common Linux flavor. DreamFactorytutorial sponsored [Hadoop Deployment Cheat Sheet](http://jethro.io/hadoop-deployment-cheat-sheet/?utm_source=dbweekly&utm_medium=email) — Insider tips and tricks for successfully deploying Hadoop. Jethrotutorial [Writing SQL on Streaming Data with Amazon Kinesis Analytics](https://blogs.aws.amazon.com/bigdata/post/Tx2D4GLDJXPKHOY/Writing-SQL-on-Streaming-Data-with-Amazon-Kinesis-Analytics-Part-1?utm_source=dbweekly&utm_medium=email) Ryan Nienhuistutorial [A Practical Guide to PostgreSQL Optimizations](https://tech.lendinghome.com/practical-guide-to-postgresql-optimizations-d7b9c2ad6a22?utm_source=dbweekly&utm_medium=email) Omar Bohsalitutorial [How We Accidentally Over-Engineered Seeding Memcached with Python, Redis and Celery](https://goshippo.com/blog/loading-data-memcached-or-how-we-built-rube-goldberg-machine-python-redis-memcached-and-celery/?utm_source=dbweekly&utm_medium=email) Wissam Jarjouistory [Database Building 101: The Cost of Graph Storage](https://ayende.com/blog/175044/database-building-101-the-cost-of-graph-storage?Key=ddcde3eb-9203-4122-953c-85c0d8a8dcb2&utm_source=dbweekly&utm_medium=email) Oren Einistory [3 Ways Big Data Is Being Used in IT](https://www.datanami.com/2016/08/25/3-ways-big-data-used/?utm_source=dbweekly&utm_medium=email) Datanamistory [PostgreSQL vs Hadoop](http://ledgersmbdev.blogspot.co.uk/2016/08/postgresql-vs-hadoop.html?utm_source=dbweekly&utm_medium=email) Chris Traversopinion [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-24974#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-24974#sql-fingers) sqlprompttools sponsored [Bojack: A Non-Reliable In-Memory Key-Value Store for Crystal](https://github.com/marceloboeira/bojack?utm_source=dbweekly&utm_medium=email) — [Crystal](https://crystal-lang.org/) is a compiled language with Ruby-like syntax. Marcelo Boeiracode [ElasticPlusPlus: High-Level, Type-Safe ElasticSearch DSL for C++](https://github.com/charliewolf/elasticplusplus?utm_source=dbweekly&utm_medium=email) Charlie Wolfcode    

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