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 Database — sqlite-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)

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