#204 — May 18, 2018
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.
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 Amplify — NGINX Amplify is a monitoring tool that now has a MySQL plugin.
Andrew Alexeev
Fun with SQL: Recursive CTEs in Postgres
Craig Kerstiens
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