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

Database Weekly 104   . 

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

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

Featured [Redis 3.2.0 Released with Lots of New Features](http://antirez.com/news/104?utm_source=dbweekly&utm_medium=email) — Redis, an in-memory, high performance ‘data structure server’, is a key piece of many apps now. 3.2 introduces a new ‘GEO’ API for indexing lat/long points, a BITFIELD command, and more. Salvatore Sanfilipponews [Spark 2.0 Technical Preview: Easier, Faster, and Smarter](https://databricks.com/blog/2016/05/11/spark-2-0-technical-preview-easier-faster-and-smarter.html?utm_source=dbweekly&utm_medium=email) — Spark 2.0 (the large scale data processing engine) has greatly improved SQL support and faster query times. The final release is a few weeks away but you can get early access to its features now. Reynold Xinnews [Discussing SQLite with Richard Hipp](https://changelog.com/201/?utm_source=dbweekly&utm_medium=email) — An hour long talk with Richard Hipp, creator of SQLite, the most widely deployed DB engine in the world. The Changelog [Connecting Hadoop and EDB Postgres to Shrink Big Data Challenges](http://www.enterprisedb.com/postgres-plus-edb-blog/ahsan-hadi/connecting-hadoop-and-edb-postgres-shrink-big-data-challenges?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016HadoopBigData) — By combining data stored in Hadoop clusters with its transactional information, EDB and Hortonworks provide a seamless view of information that will empower organizations to engage in a deeper analysis of corporate data and find new efficiencies for customer-driven revenue programs. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/7158d17c.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/ahsan-hadi/connecting-hadoop-and-edb-postgres-shrink-big-data-challenges?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016HadoopBigData) [An Open Source Tour de Force at Apache: Big Data 2016](http://www.datanami.com/2016/05/11/open-source-tour-de-force-apache-big-data-2016/?utm_source=dbweekly&utm_medium=email) — A look at how open source projects are driving big data, particularly those being incubated by Apache. Datanamistory [Realm Xamarin: A New Reactive Database for .NET Developers](https://realm.io/news/introducing-realm-xamarin/?utm_source=dbweekly&utm_medium=email) — A mobile DB built specifically for Xamarin that offers easy object persistence and full query capabilities. Realmtools [PostgreSQL Scalability: Towards 1 Million TPS](http://akorotkov.github.io/blog/2016/05/09/scalability-towards-millions-tps/?utm_source=dbweekly&utm_medium=email) — While Postgres becomes more usable with every release, it’s also made big performance improvements. Take a look at how close Postgres is to hitting one million transactions per second. Alexander Korotkovnews Jobs [The Easiest Way to Find a Job](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=easiest&utm_campaign=q2-16-dbweekly&utm_location=us) — Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. [Try it today.](https://hired.com/?utm_source=newsletters=petercooperpress=cat-tech-database=easiest=q2-16-dbweekly=us) Hired.​com In brief ['Great to see that my name still causes SQL errors..'](https://twitter.com/gintveld/status/730317679886794752?utm_source=dbweekly&utm_medium=email) Twitternews [Spark 2.0 Will Be Faster, Easier for App Development, and Tackle Streaming Data](https://www.linux.com/news/spark-20-will-be-faster-easier-app-development-and-tackle-streaming-data?utm_source=dbweekly&utm_medium=email) Linux.​comnews [Redis Gaining a Loadable Module System](http://www.antirez.com/news/106?utm_source=dbweekly&utm_medium=email) — The potential use cases for Redis could explode from this. Salvatore Sanfilipponews [On-demand Webinar: Turbocharge Your SQL Queries In-Memory with Apache® Ignite™](http://go.gridgain.com/Webinar-TurbochargeSQL-DBWeekly.html) — Learn how to boost performance 1,000X and scale to over 1 billion transactions per second with your SQL-based applications. GridGain In-Memory Data Fabrictutorial sponsored [How to Create a Redis Module in 15 Lines of Code](https://gist.github.com/dvirsky/83fc32366d5ad82fc3dca47ed2704377?utm_source=dbweekly&utm_medium=email) — Based on the news that Redis is gaining a module system (above). Dvir Volktutorial [A Quick Guide to Redis 3.2's Geo Support](https://www.compose.io/articles/a-quick-guide-to-redis-3-2s-geo-support/?utm_source=dbweekly&utm_medium=email) Composetutorial [The Basics of Database Transactions](http://rajeevrastogi.blogspot.com/2016/04/basic-of-transaction.html?utm_source=dbweekly&utm_medium=email) Kumar Rajeev Rastogitutorial [Seldom Used Postgres Functions: bool_or and bool_and](http://neovintage.org/2016/05/04/the-bool-aggregate-functions/?utm_source=dbweekly&utm_medium=email) Rimas Silkaitistutorial [From SQL to Microservices: Integrating AWS Lambda with Relational Databases](http://blogs.aws.amazon.com/bigdata/post/Tx3IRFXZW1YRIVW/From-SQL-to-Microservices-Integrating-AWS-Lambda-with-Relational-Databases?utm_source=dbweekly&utm_medium=email) Amazontutorial [SQLUnplugged Chat About SQL Server 2016 GA and SQL on Linux](https://channel9.msdn.com/Shows/SQL-Unplugged/SQLUnplugged-Episode-13-SQL-Server-2016-GA--SQL-on-Linux?utm_source=dbweekly&utm_medium=email) Channel 9video [Bridging NoSQL Databases Into Open Data Science Initiatives](http://www.ibmbigdatahub.com/blog/bridging-nosql-databases-open-data-science-initiatives?utm_source=dbweekly&utm_medium=email) IBM Big Data and Analytics Hubopinion [Stop building APIs](https://www.dreamfactory.com/signup/dont-build-rest-apis?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=dont) — DreamFactory auto-generates APIs from nearly any database, instantly. Out of the box support for V8 (JS), Node.js, PHP, and Python for custom scripting. DreamFactorytools sponsored [6 Unsung Apache Big Data Projects That Aren't Spark](https://www.linux.com/news/rise-six-unsung-apache-big-data-projects?utm_source=dbweekly&utm_medium=email) Linux.​comtools [Teleport: A Trigger-Based Postgres Replicator Written in Go](https://github.com/pagarme/teleport?utm_source=dbweekly&utm_medium=email) — A trigger-based replicator that performs DDL migrations by diffing schema changes and replicating real-time data changes based on DML triggers. No special permissions required, so it’s suitable for AWS RDS. Pagar.​metools [membership.db: SQL Boilerplate for User Accounts, Roles & Auth Tokens for Webapp Use](https://github.com/membership/membership.db/tree/master/sqlite?utm_source=dbweekly&utm_medium=email) Membership Database Starter Kitcode    

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