#204 — May 18, 2018

Read on the Web

Database Weekly

Prisma Raises $4.5M to Build the GraphQL Data Layer for All Databases — News from the company behind Prisma, an open-source GraphQL layer that essentially brings GraphQL support to any backend database. It’ll be interesting to see what happens when/if other databases bring such functionality in-house.

Prisma

TimescaleDB vs MongoDB for Storing Time-Series Data — TimescaleDB is a Postgres extension focused on time-series data, so it may come as no surprise it’s faster at the task.

Rob Kiefer

Free Database Migration and Upgrading Planner — Running an older version of MongoDB? We understand the upgrade process can seem daunting at first, so we've put together this template to help you plan out your upgrade process.

mongodb sponsor

Big Data File Formats Demystified — An explanation of three optimized file formats well suited to Hadoop for long-term efficient data processing: Optimized Row Columnar (ORC), Avro, and Parquet.

Datanami

Redis vs. Memcached: In-Memory Data Storage Systems — Redis and memcached are both popular in-memory data storage systems, though Redis brings a lot more to the table data structure wise.

Alibaba Cloud

Selecting all Columns Except One in PostgreSQL — Google’s BigQuery has EXCEPT and REPLACE keywords for removing or replacing column results mid-query. Here’s a look at emulating such functionality on Postgres.

Lukas Eder

Algorithms Behind Modern Storage Systems — One for the more CS-oriented among you with a close look at two storage system design approaches used in a majority of modern databases.

Alex Petrov

'I Wrote My First Stored Procedure Today, But I'm Not Sure How to Feel About It..' — An interesting discussion about using stored procedures in a way that doesn’t tread on the toes of other team members.

Reddit

MemSQL Gains Traction and New Investors — MemSQL has announced a $30 million funding round led by the former Google Ventures.

Datanami

Oracle Buys DataScience.com — DataScience.com is essentially an enterprise-focused platform of data science tools.

Oracle

Inventor of Scrum to Keynote Postgres Vision in Boston

Postgres Vision 2018 sponsor

Monitoring MySQL with NGINX AmplifyNGINX Amplify is a monitoring tool that now has a MySQL plugin.

Andrew Alexeev

Fun with SQL: Recursive CTEs in Postgres

Craig Kerstiens

How Disney Built a Pipeline for Streaming Analytics

Datanami

Complete This Survey to Influence the Future of Tools & Tech — Get your report, discover your sci-fi character and enter a draw for tech prizes, including an iPhone X.

Developer Economics sponsor

▶  Azure SQL and SQL Server Sessions from Build 2018 — Microsoft’s Build 2018 conference happened last week and here are all the Azure SQL and SQL Server talks in one place.

Denis Gobo

Tidis: A Distributed NoSQL Database That Supports the Redis Protocol — Uses tikv (a distributed, transactional key/value store) as a backend.

Yongman

mongo-query-to-postgres-jsonb: Converts MongoDB Queries to Postgres Queries for JSONB Fields

Thomas Hansen