Postgres Full Text Search vs the rest
Comparing one of the most popular Postgres features against alternatives
October 14, 2022
October 12, 2022
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.A database without dynamic memory allocation
This is an external post of mine. Click here if you are not redirected.
October 11, 2022
Optimizing queries in arewefastyet
Learn how we detected and optimized two slow queries in arewefastyet using PlanetScale Insights.
We launched an open source ClickHouse Knowledge Base
ClickHouse is an incredible database. We want to help our community learn how to better use it for realtime analytics.
We launched an open source ClickHouse Knowledge Base
ClickHouse is an incredible database. We want to help our community learn how to better use it for realtime analytics.
October 07, 2022
Introduction to MySQL joins
Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL.
October 06, 2022
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.The Data Journey: Unlocking data for the right now
We're all in the middle of a multi-step process to consolidate, model, and operationalize our data. Here's where we're getting stuck, and what to do about it.
October 05, 2022
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 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
Indexing JSON in MySQL
Learn how to index JSON in MySQL with generated columns and functional indexes.
You can now explore and analyze time series data in Tinybird
Visualize and analyze in real time any data source with a timestamp using SQL WHERE, GROUP BY, and HAVING filters.