a curated list of database news from authoritative sources

October 12, 2022

Michael J. Swart - Database Whisperer

You Can Specify Two Indexes In Table Hint?

Yes, It turns out that you can specify two indexes in a table hint: SELECT Id, Reputation FROM dbo.Users WITH (INDEX (IX_Reputation, PK_Users_Id)) WHERE Reputation > 1000 And SQL Server obeys. It uses both indexes even though the nonclustered index IX_Reputation is covering: But Why? I think this is a solution looking for a problem. […]

The post You Can Specify Two Indexes In Table Hint? first appeared on Michael J. Swart.
by Michael J. Swart

October 11, 2022

October 07, 2022

PlanetScale Blog

Introduction to MySQL joins

Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL.

October 06, 2022

Michael J. Swart - Database Whisperer

The Tyranny Of Cumulative Costs (Save and Forget Build Up)

Using the right triangle above draw a vertical line separating the area of the triangle in to two parts with the same area. The triangle on the left is 70.7% of the width of the original triangle. Cumulative Storage Costs Think of this another way. The triangle above is a graph of the amount of […]

The post The Tyranny Of Cumulative Costs (Save and Forget Build Up) first appeared on Michael J. Swart.
by Michael J. Swart

October 05, 2022

Stack - Convex Blog

Build a Reactive Backend for a Web App

Convex is a JS-powered database and backend for web apps that’s reactive — you can use it to create endpoints and queries that update automatically when data changes. Tom Ballinger will teach us how.
Supabase Blog

Supabase Beta September 2022

We were too focused on clearing out the backlog so we didn't ship anything new last month... or did we?!

October 04, 2022

PlanetScale Blog

Indexing JSON in MySQL

Learn how to index JSON in MySQL with generated columns and functional indexes.

October 03, 2022