#313 — July 17, 2020

Read on the Web

Database Weekly

Google Unveils BigQuery Omni for Multi-Cloud Data AnalyticsBigQuery Omni lets you analyze data in Google Cloud (as BigQuery usually does) as well as AWS with Azure coming soon. It’s “multi-cloud data analytics for the modern age.”

Google Cloud Blog

Could Predictive Database Queries Replace Machine Learning Models? — There’s been a lot of buzz around ‘machine learning’ over the past few years and predictive queries provide an interesting twist on the idea.. where we ask databases not for concrete data that they store, but ML models or ML-powered databases for predictions.

Antti Rauhala

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — Learn how companies like Robinhood and Atlassian are able to speed up their queries by orders of magnitude. In this ebook, we share our best practices for optimizing Postgres performance.

pganalyze sponsor

TileDB Raises $15M Series A for 'First Universal Data Engine' — A claim that sounds slightly inflated but the idea behind TileDB is that it is truly universal in being able to bind any type of data on any data source to any compute system.

Stavros Papadopoulos (TileDB)

⚡️ Quick bytes:

  • Heroku user? mLab MongoDB, a commonly used MongoDB add-on, is also being removed from Heroku, so double check if you're using it.
  • Redis in Ruby is a in-progress attempt at writing a book about reimplementing a system like Redis with Ruby as a learning experience.
  • Oracle's Autonomous Database can now be used on-prem.
  • EDB (formerly EnterpriseDB) has a case study about how a wireless carrier migrated a 100TB Oracle database over to Postgres.
  • YugabyteDB 2.2 has been released.

A Crash Course on Using AWS CDK for Data Work — AWS’s Cloud Development Kit (CDK) makes it possible to define cloud infrastructure in code and provision it with CloudFormation. This article looks at the basics of using it to create a serverless app for querying different data systems.

Renato Byrro (Dashbird)

Recreating YikYak with PostgreSQL — YikYak was an anonymous social network that used your location to show you posts 5km around you (we can’t see how that could possibly cause problems.. 😂) and you can recreate the underlying principle of its operation using Postgres’s geographical coordinate support.

Adam Fallon

Why We Didn't Choose QLDB for A Healthcare App — Sometimes the reasons for not choosing a database are as interesting as why you did choose a database. So it goes with Yan’s explanation of why they didn’t move a healthcare app (that needed to meet HIPAA auditing requirements) to Amazon’s fully managed QLDB ledger database that offers cryptographically verifiable transaction logs.

Yan Cui

3 Lessons from 7 Years of Building a GUI for MongoDB — How do you build a tool for the whole team? Scratch, listen, then sweat the small stuff.

Studio 3T

Distributed SQL Beats Polyglot Persistence for Building Microservices — Polyglot persistence is the silent killer of release agility; distributed SQL is the answer for today’s multicloud era.

YugabyteDB sponsor

How TiDB's HTAP Makes Truly Hybrid Workloads Possible — This post introduces the design details of the HTAP architecture of TiDB, including the real-time updatable columnar engine, the multi-Raft replication strategy, and smart selection.

Shawn Ma (PingCAP)

Left for Dead, R Surges Again“Don’t look now, but R, which some had written off as a language in terminal decline in lieu of Python’s immense and growing popularity, appears to be staging a furious comeback.”


SQL LEFT JOIN - A Beginner's Guide — Learn how the SQL LEFT JOIN works and how you can use it to associate rows belonging to different tables and build a compound result set.

Vlad Mihalcea

💼 Job

DevOps Engineer at X-Team (Remote) — Join the most energizing community for developers and work on projects for Riot Games, FOX, Sony, Coinbase, and more.