--- title: "This week's database news, issue 133" publication: "DB Weekly" issue: 133 published_at: "2016-12-12" canonical_url: "https://dbweekly.com/issues/133" --- Database Weekly 133 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/133) [Database Weekly](http://dbweekly.com) Issue 133 — December 12, 2016 Featured Apologies for the odd day of delivery. We've been experimenting with our email system. Everything back to normal from this Friday :-) [The First Release Candidate of Redis 4.0 is Out](http://www.antirez.com/news/110?utm_source=dbweekly&utm_medium=email) — The superfast data structure server is close to another big step forward. 4.0 includes support for custom modules, a new replication system, and more. Salvatore Sanfilipponews [A Beginner's Guide to the True Order of SQL Operations](https://blog.jooq.org/2016/12/09/a-beginners-guide-to-the-true-order-of-sql-operations/?utm_source=dbweekly&utm_medium=email) — _“The SQL language is very intuitive. Until it isn’t.”_ A thorough tour of how the order of operations in SQL matters. jOOQtutorial [Google BigQuery, and Why Big Data is About to Have its GMail Moment](https://medium.com/mark-rittman/google-bigquery-and-why-big-data-is-about-to-have-its-gmail-moment-39f3c6308d55?utm_source=dbweekly&utm_medium=email) — _“the petabyte-scale of event-based customer interaction records means that it’s easier, cheaper and far less work to hand this sort of workload off to Google”_ Mark Rittmanopinion [Building OHLC (open, high, low, close) Data in PostgreSQL](https://compose.com/articles/building-ohlc-data-in-postgresql/?utm_source=cooper&utm_medium=newsletter&utm_content=db) — This article illustrates the power of PostgreSQL's aggregate and date functions to analyze financial data, and shows you how to display the results in a web browser using TechanJS. Composesponsored — [![\](https://copm.s3.amazonaws.com/fe16b3a9.png)](https://compose.com/articles/building-ohlc-data-in-postgresql/?utm_source=cooper&utm_medium=newsletter&utm_content=db) [7 Things Learned About Aurora at AWS re:Invent 2016](https://www.brentozar.com/archive/2016/12/7-things-learned-aurora-aws-reinvent-2016/?utm_source=dbweekly&utm_medium=email) — Some of Brent Ozar’s favorite takeaways about Amazon Aurora, Amazon’s homegrown relational database with MySQL compatibility. Brent Ozaropinion [Record Query: A Tool for Doing Record Analysis and Transformation](https://github.com/dflemstr/rq?utm_source=dbweekly&utm_medium=email) — Fills a similar niche to tools like awk or sed, but works with structured (record) data instead of text. David Flemströmtools [30x Faster Elasticsearch Queries](https://mixmax.com/blog/30x-faster-elasticsearch-queries?utm_source=dbweekly&utm_medium=email) — _“we achieved a 30x performance improvement in Elasticsearch queries by switching from millisecond timestamps to seconds”_ Cameron Price-Austinstory [PostGraphQL: PostgreSQL Meets GraphQL](https://www.compose.com/articles/postgraphql-postgresql-meets-graphql/?utm_source=dbweekly&utm_medium=email) — [GraphQL](https://facebook.github.io/react/blog/2015/05/01/graphql-introduction.html) is a data query language originally built at Facebook. PostGraphQL is a library that maps Postgres schemas to GraphQL ones that can then be queried against. Compose [Graph Query Engine Claims Performance Record](https://www.datanami.com/2016/12/09/graph-query-engine-claims-record/?utm_source=dbweekly&utm_medium=email) — Cambridge Semantics claimed a record this week with a load and query of 1 trillion ‘triples’ on the Google Cloud Platform in under 2 hours. Datanaminews [The Wide World of Data Science with Jessica Kirkpatrick](http://data.heapanalytics.com/the-analyst-podcast-episode-1-what-is-data-science?utm_source=dbweekly&utm_medium=email) — The Analyst is a new podcast about how to use data to solve problems, in business and beyond. Sarah Siwak Jobs [Want Multiple Job Offers? - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-dbweekly) — Why job hunt like it's the 90s? Try Hired today to get in front of thousands of innovative companies. Hired In brief [Supporting R in SQL Server 2016](http://www.vertabelo.com/blog/technical-articles/supporting-r-in-sql-server-2016?utm_source=dbweekly&utm_medium=email) Dejan Sarkanews [Writing Clean SQL](http://jonathansacramento.com/posts/20161119_clean_sql.html?utm_source=dbweekly&utm_medium=email) Jonathan Sacramentotutorial [Date Math In The WHERE Clause](https://www.brentozar.com/archive/2016/12/date-math-clause/?utm_source=dbweekly&utm_medium=email) Brent Ozartutorial [Storing and Manipulating IPv6 Addresses in MySQL 8.0](http://mysqlserverteam.com/mysql-8-0-storing-ipv6/?utm_source=dbweekly&utm_medium=email) Catalin Besleagatutorial [Improving Search Speed with PostgreSQL Trigram Indexes](https://sweetcode.io/fast-search-using-postgresql-trigram-indexes/?utm_source=dbweekly&utm_medium=email) — How Trigram indexes work and how they can be used to speed up queries using LIKE conditions. Yorick Petersetutorial [Running Solr in Docker: How and Why](https://sematext.com/blog/2016/12/05/docker-solr/?utm_source=dbweekly&utm_medium=email) Rafał Kuć and Radu Gheorghevideo [Planet-Scale NoSQL with Azure DocumentDB](https://channel9.msdn.com/Shows/Azure-Friday/Planet-Scale-NoSQL-with-DocumentDB?utm_source=dbweekly&utm_medium=email) Channel 9video [Setting Up RavenDB on the Raspberry PI](https://www.youtube.com/watch?v=DPxCVDOUlT8&utm_source=dbweekly&utm_medium=email) — An open source database for .NET. Adi Avivivideo [SQL Is Still Superior for Big-Data Analytics](https://blog.rakam.io/why-sql-superior-for-analytic-queries-comparison-with-mixpanels-jql-ec9935f292bd?utm_source=dbweekly&utm_medium=email) Burak Emreopinion [Put your DB into overdrive on Linode’s SSD servers.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-sponsored) — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for $20 credit linodetools sponsored [HQbird 2017 Released: An Advanced Distro of FirebirdSQL](https://ib-aid.com/en/news/hqbird-2017-is-released/?utm_source=dbweekly&utm_medium=email) — With native replication, optimization tools, automatic backups, and monitoring. IBSurgeontools [50+ of the Best Online Educational Resources to Learn SQL](https://hackerlists.com/learn-sql-online/?utm_source=dbweekly&utm_medium=email) — Including books, interactive courses, video lessons, bootcamps, articles, and references. Hacker Liststools [PDD: Advanced Bloom Filter Based Algos for Efficient Data De-Duplication in Streams](https://github.com/jparkie/PDD?utm_source=dbweekly&utm_medium=email) Jacob Parkcode [SQL Server Test Data Generator in SQL](https://code.msdn.microsoft.com/SQL-Server-Test-Data-637b2a5d?utm_source=dbweekly&utm_medium=email) Microsoftcode [Rebridge: A Transparent JavaScript Interface to Redis](https://github.com/CapacitorSet/rebridge?utm_source=dbweekly&utm_medium=email) CapacitorSetcode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/133) [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