EdgeDB 1.0 Alpha 1: A Database Attempting to Bridge the NoSQL/SQL Divide — Originally announced a year ago, EdgeDB is an open-source object-relational database that bakes in support for working with semi-structured data in an attempt at bringing the simplicity of NoSQL to the relational world.

PostgreSQL is used under the hood with Edge’s own SQL-esque query language (EdgeQL) compiled to SQL behind the scenes, and this post is a great introduction to EdgeQL and how it works from a developer’s perspective.

Yury Selivanov and Elvis Pranskevichus

Stop Managing 100’s of DB Credentials and Keys — Extend your SSO to manage database and server access with strongDM. Every server. Every database (yes, even Druid). Any environment. See how it works.

strongDM sponsor

Which AWS Technology Should You Use for Your Open Source Database? — Databases are a key part of deploying apps to the cloud and AWS (in)famously has a lot of options in this regard. Here are some of the reasons you might choose between the various options.

The New Stack

The Difference Between SQL's JOIN .. ON Clause and the WHERE Clause — Are ON and WHERE really the same thing? “They are when you run an inner join. But they are not when you run an outer join.”

Lukas Eder

Scylla Cloud: The Fastest NoSQL Database as a Managed Service — ScyllaDB is a real-time, big data database heavily influenced by Apache Cassandra. This cloud version is AWS only for now, but Azure and GCP are to follow.

ScyllaDB

Cloud Native, 'Chaos-Tolerant' FaunaDB Adds Support for SQL, GraphQL, and CQL — FaunaDB, created by a former, early Twitter employee, is a sort of ‘all-in-one’ database for polyglot persistence.

George Anadiotis (ZDNet)

pganalyze eBook: How to Get a 3x Performance Improvement on Your Postgres Database — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x.

pganalyze sponsor

How To Improve The Performance of COUNT(*) — Using count(*) is often quite slow in Postgres. This article explores a variety of options to make counting rows faster using approximations and other tricks.

Laurenz Albe

rediSQL: Redis Module Providing an SQL Database Inside Redis — We first linked the alpha version two years ago but it’s just hit 1.0 :-)

Simone Mosciatti

Full Stack, Mobile & Infrastructure Engineers — Joining our team means you will be working in our fast paced environment and you are fearless of our next big challenge.

Expensify

Find A DB Job Through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started.

Vettery