#316 — August 7, 2020

Read on the Web

Database Weekly

What Every Developer Should Know About Database Consistency — As a Distributed Systems Engineer at Microsoft you’d expect Roberto to know a bit about consistency, and he does a good job of explaining the basics at a high level here.

Roberto Vitillo

Scientists Rename Human Genes to Stop Excel From Misreading Them As Dates — If you’ve spent more than 5 seconds with a spreadsheet, you’ll have encountered some sort of data formatting or detection snafu, and biochemists working with human genes aren’t immune to this either. I always find it interesting to see the inadvertent effects software and database design decisions can have on the real world.

James Vincent

Free O’Reilly eBook Excerpt: Architecting for Scale — In this practical guide written by a distributed systems expert, learn how to build apps that scale to handle unpredictable traffic with zero downtime for customers.

Cockroach Labs sponsor

Postgres Weekly: Our Sister PostgreSQL Newsletter — We do a bad job of promoting our other newsletters because we often get emails from people asking for newsletters we’ve been running for years 😂 So if you’re a Postgres user, we wanted to make sure you’re familiar with Postgres Weekly which has been going for seven years now! Here’s the latest issue.

Cooperpress

Big Data Apps Wasting Billions in the Cloud — Where there are big budgets and huge amounts of data, there’s going to be wasted capacity, and Pepperdata has dug into just how much.

Datanami

Direct Lambda Resolvers: AWS AppSync GraphQL APIs without VTL — AWS AppSync is a managed serverless GraphQL service for building APIs. VTL (Velocity Template Language) is used to translate GraphQL requests into queries for an underlying data source.. but these are now optional when integrating AppSync with Lambda due to Direct Lambda Resolvers which let you create resolver logic in any runtime supported by Lambda.

Ed Lima (AWS)

Use NATURAL FULL JOIN to Compare Two Tables in SQLNATURAL JOIN is syntax sugar for joining using all the shared column names of the two tables, and the FULL JOIN makes sure we can retrieve also the columns that are not matched by the join predicate.”

Lukas Eder

DZone’s Latest Report on Distributed Databases, Sponsored by Yugabyte — A new trend report by DZone dives into real-world usage of SQL and NoSQL databases across a variety of organizations.

YugabyteDB sponsor

How Subqueries Were Implemented in a Go-Powered SQL Engine — There’s a few moving parts here, but basically Dolt is like Git for data and the underlying SQL engine is go-mysql-server, a MySQL wire protocol compatible SQL server and engine.

Zach Musgrave

Pretending to Have a SQL Database with RStudio — How you can support a person who loves SQL (e.g. a data analyst) without setting up a SQL server.

Jacqueline Nolis

▶  The Top 10 Developer Mistakes That Won't Scale on Microsoft SQL Server — If you’re a C# or Java developer using SQL Server, you should find this valuable to help you avoid some common pitfalls.

Brent Ozar

TreSQL: A Shorthand SQL/JDBC Wrapper Language — A query language built on top of SQL that can select data into hierarchical JSON objects. Written in Scala on top of JDBC.

Martins Rumkovskis

Monstache 6.7: A Daemon That Syncs MongoDB to Elasticsearch in Realtime

Ryan Wynn

💼 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.

X-Team