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

This week's database news, issue 34

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

DB WeeklyIssue 34 — October 17, 2014

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://patshaughnessy.net/2014/10/13/following-a-select-statement-through-postgres-internals?utm_source=dbweekly&utm_medium=email)Pat ShaughnessyAn excellent explanation, complete with diagrams, of what happens when you run a standard SELECT query on Postgres. If you’re an end user and want to dig a little deeper, this walkthrough provides a great starting point.


[Building Scalable Search from Scratch with Elasticsearch](http://www.airpair.com/elasticsearch/posts/elasticsearch-robust-search-functionality?utm_source=dbweekly&utm_medium=email)AirPairA practical walkthrough of tying together a number of open source technologies around Elasticsearch to provide a flexible, high performance search system for a Web site.


[Another Patent Troll Slain. You Are Now Free To Rotate Your Smartphone.](http://www.rackspace.com/blog/another-patent-troll-slain-you-are-now-free-to-rotate-your-smartphone/?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-patent)RackspaceSponsoredLast year patent troll Rotatable sued Rackspace, claiming they owned a patent that covered the screen rotation technology that’s standard on just about every smartphone. Rackspace, continuing their streak of fighting such frivolous claims, challenged them on behalf of the entire industry and ultimately won. [Read more.](http://www.rackspace.com/blog/another-patent-troll-slain-you-are-now-free-to-rotate-your-smartphone/?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-patent)

[![Rackspace\](http://s3.amazonaws.com/nlga/uploads/item/image/28512/i.png)](http://www.rackspace.com/blog/another-patent-troll-slain-you-are-now-free-to-rotate-your-smartphone/?cm_mmc=managed-_-cloud-_-contentnam-_-dbweekly-patent)


[SQL for Marketers](https://www.periscope.io/blog/sql-for-marketers.html?utm_source=dbweekly&utm_medium=email)PeriscopeSQL isn’t the most friendly of languages but it can be incredibly powerful. The amount of valuable data that lies in relational databases continues to grow, so if you’re not a developer, here’s an awesome intro to SQL.


[The Weather Channel Forecasts Heavy NoSQL Ahead](http://www.pcworld.com/article/2833772/the-weather-channel-forecasts-heavy-nosql-ahead.html?utm_source=dbweekly&utm_medium=email)PCWorldThe Weather Channel found that it had to switch to a NoSQL MongoDB data store in order to more quickly develop apps and add features to its range of Internet-based weather information services.


[Why Redis Beats Memcached for Caching](http://www.infoworld.com/article/2825890/application-development/why-redis-beats-memcached-for-caching.html?utm_source=dbweekly&utm_medium=email)InfoWorldRedis is more powerful and more flexible and usually the right choice, but Memcached still has its place.


[DatabasePack Beta: Database-as-a-Service for Testing](http://www.databasefriends.co/2014/10/databasepack-beta-database-as-service.html?utm_source=dbweekly&utm_medium=email)Database FriendsMakes testing code on multiple database versions easier because they are already hosted and are available just a few clicks away.


[Preparing Your Enterprise for Big Data](http://www.databasejournal.com/features/db2/preparing-your-enterprise-for-big-data.html?utm_source=dbweekly&utm_medium=email)Database JournalBig data applications are now commonplace but ‘dropping’ them in amongst existing IT infrastructure can be tricky and companies need to prepare appropriately.


[Elasticsearch from the Top Down](https://www.found.no/foundation/elasticsearch-top-down/?utm_source=dbweekly&utm_medium=email)Alex BrasetvikA look at how Elasticsearch handles requests, particularly when distributed across a variety of nodes.


Jobs

In brief

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/34)

© 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)