#359 — June 18, 2021 |
✍️ This newsletter is taking an extended break in two weeks, so we've been shaking the issues up a bit, and I hope you enjoyed last week's Data Processing Tools special edition. This week we're going with a mix of news and some perennially useful guides that have been popular over the years - we've marked them with a trophy emoji 🏆 :-) |
Database Weekly |
|
|
Neo4j Announces $325 Million Series F Investment — Representing what they claim is the “largest investment in a private database company” ever, the company maintaining the popular Neo4j graph database system is now valued at over $2bn. Neo4j Inc. |
|
🏆 The Database of Databases — An online encyclopedia of 748, and counting, database systems from Carnegie Mellon University. It also includes a leaderboard of stats showing the most common countries of origin (US is #1 unsurprisingly), programming language used (C++, Java, C, and Go take the top four spots), and more. Database of Databases |
Scale Low Latency MySQL Apps, Globally — Distributed just like a CDN, PolyScale intelligently distributes and caches MySQL data to the edge. Implement in minutes without writing code or deploying servers. PolyScale sponsor |
|
IN BRIEF:
|
|
Do You Need Redis? Postgres Does Queuing, Locking, and Pub/Sub.. — I’m a huge Redis fan and while it’s common to have a mainstream database (like Postgres) and Redis running side by side, you could potentially just use Postgres for things like job queues or locks. Chris Farber |
|
▶ The Rise of 'Data Services' with Patrick McFadin — Developers increasingly want to think less about ‘databases’ and more about data being handled by managed, immediately available cloud services. Serverless Chats Podcast podcast |
|
🤔What’s Time-Series Data Compression and Why Does It Matter? — Learn how compression algorithms work, how to use TimescaleDB to store 100TB of data in 10TB of space, and more 🔥 Timescale sponsor |
|
Exploring Performance Differences Between Amazon Aurora and 'Vanilla' MySQL — Aurora is a managed database service provided by AWS in both MySQL and Postgres flavors but with a totally different performance and scale oriented architecture under the hood. Michael Troute |
|
🏆 Select Star SQL: An Interactive SQL Tutorial — Want to get a bit better at SQL? This interactive online guide will give you some practical experience and is oriented, perhaps a bit morbidly, around querying a dataset of death row inmates.. Zi Chong Kao |
|
🏆 A SQL Style Guide — A handy SQL style guide to ensure legible and maintainable queries. Simon Holywell |
|
|
▶ On Postgres's Optimizer Methodology — EDB’s Robert Haas, a long time major contributor to Postgres, gave an hour long talk about two key parts of Postgres’s query optimizer: join planning and statistics. This is technical stuff, but Robert does a great job of making reasonably opaque processes accessible and knowing this stuff will really up your Postgres game. Robert Haas |
|
Scheduling Amazon RDS Stops and Starts with AWS Lambda — Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud and in situations where you might only want an instance running on a schedule (e.g. a test setup during work hours) Lambda can help out. Tanamala, Lingareddy, Mahajan (AWS) |
|
Exploring Serverless Patterns for Amazon DynamoDB — Learn about some different DynamoDB patterns used in serverless applications and how to lean on the Serverless Patterns Collection to configure DynamoDB as an event source for AWS Lambda functions. Talia Nassi (AWS) |
|
rqlite 6.0: The Evolution of a Distributed Database Design — rqlite is a database system that uses SQLite under the hood. This announcement focuses on a new leader-finding approach for nodes and the options considered for the problem. Philip O'Toole |