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 — 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 Sanfilippo news
A Beginner's Guide to the True Order of SQL Operations — "The SQL language is very intuitive. Until it isn’t." A thorough tour of how the order of operations in SQL matters.
jOOQ tutorial
Google BigQuery, and Why Big Data is About to Have its GMail Moment — "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 Rittman opinion
Building OHLC (open, high, low, close) Data in PostgreSQL — 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.
Compose sponsored
7 Things Learned About Aurora at AWS re:Invent 2016 — Some of Brent Ozar’s favorite takeaways about Amazon Aurora, Amazon’s homegrown relational database with MySQL compatibility.
Brent Ozar opinion
Record Query: A Tool for Doing Record Analysis and Transformation — Fills a similar niche to tools like awk or sed, but works with structured (record) data instead of text.
David Flemström tools
30x Faster Elasticsearch Queries — "we achieved a 30x performance improvement in Elasticsearch queries by switching from millisecond timestamps to seconds"
Cameron Price-Austin story
PostGraphQL: PostgreSQL Meets GraphQL — GraphQL 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 — 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.
Datanami news
The Wide World of Data Science with Jessica Kirkpatrick — 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 — Why job hunt like it's the 90s? Try Hired today to get in front of thousands of innovative companies.
Hired
In brief
Dejan Sarka news
Jonathan Sacramento tutorial
Brent Ozar tutorial
Catalin Besleaga tutorial
Improving Search Speed with PostgreSQL Trigram Indexes — How Trigram indexes work and how they can be used to speed up queries using LIKE conditions.
Yorick Peterse tutorial
Rafał Kuć and Radu Gheorghe video
Channel 9 video
Setting Up RavenDB on the Raspberry PI — An open source database for .NET.
Adi Avivi video
Burak Emre opinion
Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for 20ドル credit
linode tools sponsored
HQbird 2017 Released: An Advanced Distro of FirebirdSQL — With native replication, optimization tools, automatic backups, and monitoring.
IBSurgeon tools
50+ of the Best Online Educational Resources to Learn SQL — Including books, interactive courses, video lessons, bootcamps, articles, and references.
Hacker Lists tools
Microsoft code
CapacitorSet code