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

This week's database news, issue 62

This week's database news, supported by Rackspace[Read this e-mail on the Web](http://dbweekly.com/issues/62)

DB WeeklyIssue 62 — June 19, 2015

Supported by [![\](http://dbweekly.com/images/rackspacetrans.png)](http://rackspace.com/?utm_source=dbweekly&utm_medium=email)

[Following a SELECT Statement Through Postgres Internals](http://blog.codeship.com/following-a-select-statement-through-postgres-internals/?utm_source=dbweekly&utm_medium=email)Pat ShaughnessyHere’s a continued very deep dive into what happens under the covers of Postgres when you run a select statement. If you’ve ever been curious about the internals of Postgres this is a great primer.


[LinkedIn Fills Another SQL-on-Hadoop Niche with Pinot](http://www.javaworld.com/article/2934743/data-storage/linkedin-fills-another-sql-on-hadoop-niche.html?utm_source=dbweekly&utm_medium=email)JavaWorldPinot is a realtime distributed OLAP datastore used at LinkedIn to deliver scalable real time analytics with low latency. It’s designed to scale horizontally and is open source.


[Database Training and Fundamentals Video](https://www.microsoftvirtualacademy.com/en-US/training-courses/database-fundamentals-8243?utm_source=dbweekly&utm_medium=email)Microsoft Virtual AcademyA professionally filmed 29 minute ‘getting started with databases’ video.


[10 Quick Tips for Redis](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter)ObjectRocketSponsoredRedis has come a long way from being a small personal project from Antirez, to being an industry standard for in memory data storage. With that comes a set of best practices that most people can agree upon for using Redis properly. [Check out](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter) 10 quick tips on using Redis correctly.

[![ObjectRocket\](http://s3.amazonaws.com/nlga/uploads/item/image/37407/i.png)](http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/?cm_mmc=data_nosql_Redis-tips_dbweekly-newsletter)


[Heroku PostgreSQL vs. Amazon RDS for PostgreSQL](http://blog.codeship.com/heroku-postgresql-versus-amazon-rds-postgresql/?utm_source=dbweekly&utm_medium=email)Barry JonesIf you want to use Postgres, but not run and maintain it yourself, Heroku or AWS are two compelling options. This is a thorough rundown of what you can expect from each.


[4 Reasons Not To Use MySQL For Analysis](https://periscope.io/blog/reasons-not-to-use-mysql.html?utm_source=dbweekly&utm_medium=email)Periscope“If you’re choosing a database for analysis purposes and you stumble across this post, read on and learn why MySQL is the wrong choice.”


[Natural Language Processing With Neo4j: Mining Paradigmatic Word Associations](http://www.lyonwj.com/2015/06/16/nlp-with-neo4j/?utm_source=dbweekly&utm_medium=email)William LyonHow we can use the Neo4j graph database to help model a text corpus as a graph and implement a simple paradigmatic relation mining algorithm.


[Don’t Let Your Data Out of the Database](http://patshaughnessy.net/2015/6/18/dont-let-your-data-out-of-the-database?utm_source=dbweekly&utm_medium=email)Pat Shaughnessy“Don’t let your data out of the database until you need to… until you have just the values your application really needs.” Pat Shaughnessy looks at the benefits of letting your database take the strain instead of your programming language.


[Fashion Is Hard. PostgreSQL Is Easy [video\]](https://tech.zalando.com/blog/watch-fashion-is-hard-postgresql-is-easy/?utm_source=dbweekly&utm_medium=email)ZalandoZalando’s Head of Data Engineering, Valentine Gogichashvili, shares their experiences with PostgreSQL and how it fared scaling up to 100 million visitors per month.


Jobs

- [Database Administrator (Blacksburg, VA)](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job?utm_source=dbweekly&utm_medium=email)Rackspace is seeking a Senior Database Administrator in our Blacksburg, VA office. The Senior DBA will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. [Learn More.](https://uscareers-rackspace.icims.com/jobs/11568/database-administrator/job)
Rackspace

In brief

- [SQL Server 2016: Always Encrypted](http://www.infoq.com/news/2015/06/SQL-Server-Always-Encrypted?utm_source=dbweekly&utm_medium=email) news 
SQL Server 2016 seeks to make encryption easier via its new ‘Always Encrypted’ feature. InfoQ
- [Cloudera Hub Adds VoltDB as 'Fast Data' Front End](http://www.datanami.com/2015/06/09/cloudera-hub-adds-voltdb-as-fast-data-front-end/?utm_source=dbweekly&utm_medium=email) news Datanami
- [ERPScan Claims SAP Hana Riddled with SQL Injection Vulnerabilities](http://www.computing.co.uk/ctg/news/2414035/sap-hana-riddled-with-encryption-and-sql-injection-vulnerabilities-claims-security-company?utm_source=dbweekly&utm_medium=email) news 
SAP Hana is SAP’s in-memory database. Computing
- [A First Look at System-Versioned Temporal Tables in SQL Server 2016](http://sqlmag.com/sql-server/first-look-system-versioned-temporal-tables-part-1-creating-tables-and-modifying-data?utm_source=dbweekly&utm_medium=email) news SQL Server Pro
- [MongoDB 3.0.4 Released](http://blog.mongodb.org/post/121688438048/mongodb-3-0-4-is-released?utm_source=dbweekly&utm_medium=email) news MongoDB Blog
- [Understanding Your App and Its Users with The Power of Neo4j](https://www.airpair.com/logging/posts/understanding-our-app-with-neo4j?utm_source=dbweekly&utm_medium=email) tutorial Ognjen Bubalo
- [How to Install, Configure and Secure MySQL/MariaDB on Linux](http://www.linuxveda.com/2015/06/17/install-mysql-mariadb-secure-configure/?utm_source=dbweekly&utm_medium=email) tutorial LinuxVeda
- [Querying Your Database from Millions of Fibers (Rather than Thousands of Threads)](http://blog.jooq.org/2015/06/16/querying-your-database-from-millions-of-fibers-rather-than-thousands-of-threads/?utm_source=dbweekly&utm_medium=email) tutorial 
jOOQ is a great way to do SQL in Java and Quasar fibers bring much improved concurrency. Java, SQL and jOOQ
- [Painless Microsoft SQL Server with Node.js and seriate](http://developer.leankit.com/painless-sql-server-with-nodejs-and-seriate/?utm_source=dbweekly&utm_medium=email) tutorial David Neal
- [On Selecting a Shard Key for MongoDB](https://www.mongodb.com/blog/post/on-selecting-a-shard-key-for-mongodb?utm_source=dbweekly&utm_medium=email) tutorial Bryan Reinero
- [Using RethinkDB with ExpressJS](https://www.airpair.com/javascript/posts/using-rethinkdb-with-expressjs?utm_source=dbweekly&utm_medium=email) tutorial Craig Walsh
- [Best Practices for Upgrading to MongoDB 3.0](https://www.mongodb.com/presentations/webinar-best-practices-for-upgrading-to-mongodb-3-0?utm_source=dbweekly&utm_medium=email) video Richard Kreuter
- [Ask HN: What Are The Best Tools for Analyzing Large Bodies of Text?](https://news.ycombinator.com/item?id=9733883) opinion Hacker News
- [Why XML-in-RDBMS != MongoDB](https://www.mongodb.com/blog/post/why-xml-in-rdbms-is-not-mongodb?jmp=twitter) opinion 
Why the XML-as-column approach comes with a large set of gotchas. MongoDB
- [Connecting Neo4j to Any SQL Tool with the Power of Postgresql](http://www.bsimard.com/Connecting-Neo4j-to-any-SQL-tool-with-the-power-of-Postgresql?utm_source=dbweekly&utm_medium=email) tools 
A Python and Multicorn-based foreign data wrapper that brings together Neo4j and Postgres. Benoît Simard
- [SheetDB: Connect Remote SQL Databases with a Google Sheet](https://github.com/Xuefeng-Zhu/SheetDB?utm_source=dbweekly&utm_medium=email) code tools 
Allows you to connect to a remote SQL server and load data into Google Sheet directly. Xuefeng Zhu

Curated by [Peter Cooper](http://twitter.com/peterc) and published by [Cooper Press](https://cooperpress.com/) for [Rackspace](http://www.rackspace.com/?utm_source=dbweekly&utm_medium=email).
Send feedback by simply replying to this mail.
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q4.pdf)
Want to post a job? E-mail us or [use our self-serve system.](https://cooperpress.com/jobs)

[Unsubscribe](*|UNSUB|*) : [Change email address](*|UPDATE_PROFILE|*) : [Read this issue on the Web](http://dbweekly.com/issues/62)

© Cooper Press Ltd. Office 30, Lincoln Way, Louth, LN11 0LS, UK
[Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)