#​360 — June 25, 2021

Read on the Web

⚠️  This is the last issue you'll receive for a while. As previously mentioned, DB Weekly is going into hiatus for a while, but its future hasn't been entirely decided. We may come back with something simpler, disappear entirely, or even come back as usual after a while – the book is still open :-)

If you're a PostgreSQL user, we encourage you to come and join us on Postgres Weekly, you can follow me personally on Twitter @peterc, or see if any of our other newsletters catch your eye. Thanks for your support so far – it has been most appreciated 😊
__
Peter Cooper, editor

Database Weekly

Graph Databases: Why Are They Suddenly Popular? — Off the back of last week’s huge round of funding for Neo4j comes this piece (curiously from a director at Oracle) making a high level case for graph databases. I’m not too sure about the suddenly.. this trend has been growing nicely over the past several years. Could I resist leading with an item from Oracle in our final issue (for now) though? No 😆

Jeff Erickson (The New Stack)

Start Building with a SQL API in the Cloud — CockroachCloud is a transactional database available as a PostgreSQL API. It’s simple and ops-free. Just connect and instantly start building. Oh, and there is a forever-free plan. No credit cards, no commitments.

Cockroach Labs sponsor

Joining CSV and JSON Data with an In-Memory SQLite Databasesqlite-utils is a collection of Python utility functions for working with SQLite databases and the latest version lets you import CSV and JSON data into an in-memory database, combine and query it, then output the results as you wish.

Simon Willison

How to Build a Graph Application with Amazon Neptune and AWS Amplify — The coming years are only going to see even more ‘stitching together’ of various data services to meet data processing needs and this is a neat practical example of doing that with AWS’s managed graph database and Amplify for adding a GraphQL API to the mix.

Koizumi and Ishio (AWS)

IN BRIEF:

How Databases Handle 10 Million Devices in High-Cardinality Benchmarks — When you have lots of sensors (or similar IoT devices) pumping out information on a continuous basis, you end up with data sets with huge cardinality, even if the underlying data is quite small (e.g. a temperature and a time). This post focuses on how the QuestDB benchmark their database against such use cases.

Vlad Ilyushchenko (QuestDB)

Streaming Amazon DynamoDB Data into a Centralized Data Lake — The DynamoDB document database works great for serverless apps but what about when business teams want to plug in their BI tools and do analysis? You can use Kinesis Data Streams and Kinesis Data Firehose to pipe the data to S3 for use elsewhere.

Amazon Web Services

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — Learn how we help companies like Atlassian speed up their queries. We share our best practices for optimizing Postgres.

pganalyze sponsor

Leveraging BigQuery Public US Boundaries Datasets for Geospatial Analytics — A demonstration of joining first party data onto the BigQuery Public Boundaries Datasets for comprehensive geospatial analytics.

Leigha Jarett (Google Cloud)

Hosted Monitoring: Evaluating InfluxDB Cloud and Grafana Cloud — Experiences from someone who’s worked on self-hosted Grafana and InfluxDB setups but has explored the potential of managed cloud solutions.

PQVST

An Overview of Backup Approaches for Redis
Krzysztof Ksiazek

How to Migrate DynamoDB Tables from One AWS Account to Another with AWS Data Pipeline
Sodabathina and Gong (AWS)

Jobs

Find Data Engineering Jobs with Hired — Take 5 minutes to build your free profile & start getting interviews for your next job. Companies on Hired are actively hiring right now.
Hired

Till we meet again..