#350 — April 16, 2021
Database Weekly
Introducing OpenSearch: AWS's Fork of Elasticsearch and Kibana — Back in January, Elastic announced a contentious licensing change to its Elasticsearch and Kibana projects, and Amazon decided to fork them into its own ‘community driven’ project, now called OpenSearch.
Amazon Web Services
AQUA (Advanced Query Accelerator): A Speed Boost for Amazon Redshift Queries — When Jeff Barr writes a launch post for AWS, you know it’s going to be something good (he launched S3 after all). This isn’t as fun as S3 but if you’re using their Redshift data warehouse system this is an accelerator that can boost query performance by up to 10x at no extra cost.
Jeff Barr (AWS)
Identify Slow-Running Queries Quickly Using Datadog — Improve database performance in real-time by visualizing and identifying errors using customizable, OOTB dashboards in Datadog. Reduce MTTR leading to lower operating costs and better collaboration among teams. Try Datadog free.
Datadog sponsor
Quick Bits
- A developer ponders on the idea of using SQL more in front-end development. Hacker News then discussed the point further.
- DigitalOcean has extended its managed database service to working on '100% dedicated vCPU' droplets for more guaranteed and level performance.
- A 40-minute ▶️ show about graph databases and identifying good use cases for them. Seems appropriate given yesterday was Global Graph Celebration Day, apparently!
- Some best practices for writing SQL queries.
- Rockset has announced new integrations for MySQL and Postgres for running sub-second, high concurrency analytics on data from those systems in real time.
- RedisLabs has a virtual Redis hackathon on the go until May 15. There are prizes, so if you're looking for something to do...
End-to-End Serverless ETL Orchestration with AWS — Building your first end to end data orchestration and data pipeline could be overwhelming. Here’s one potential approach.
Rittika Jindal
💰 Analyzing Cryptocurrency Trends: Step-by-Step Tutorial — Learn how to explore crypto prices over time, complete with a sample dataset & 5 queries to jumpstart your analysis.
Timescale sponsor
Getting Started with QGIS, Postgres and PostGIS — A quick introduction to setting up PostGIS and QGIS, a desktop app for viewing, editing and analyzing geospatial data, to view OpenStreetMap data.
Hans-Jürgen Schönig
Jobs
Workday - PostgreSQL Database Engineer / Administrator — We’re looking for an engineer to help us build for the future, revamp our persistence architecture, and ensure our systems are operating flawlessly 24/7. We’re one of the largest SaaS companies globally growing rapidly in Europe.
Workday
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
🔧 Code & Tools
Apache AGE 0.4: A Graph Extension for Postgres — An extension that provides graph database functionality to Postgres and was inspired by AgensGraph. The latest release (0.4.0) adds a variety of small syntax level features. GitHub repo.
Apache Foundation
SQLRite: An SQLite Clone From Scratch in Rust — I’ve seen a few projects trying to bring SQLite under the wing of Rust’s safety but this is an attempt at a clone asking "What would SQLite look like if written in Rust?" It’s a brave effort but SQLite’s head start certainly makes it a challenge to catch up.
João Henrique Machado Silva
PostgreSQLite: Use PostgreSQL 'Like SQLite' — A neat little idea that’s orchestrated by a straightforward 30 line shell script. Docker does most of the heavy lifting, though.
Felix Dietze
CloudBeaver: A Cloud-Based Database Manager — A tool available in both commercial and community (Apache 2.0 licensed) for working with data, diagramming schemas, building SQL queries, etc. AWS integration is one of their big selling points.
CloudBeaver
SQLPad 6.6: A Web-Based SQL Editor to Run In Your Private Cloud — If you want something more broadly open source than the above. SQLPad also supports a vast array of systems from standard RDBMS to things like BigQuery, Cassandra, and Apache Pinot.
Rick Bergfalk