Searching JSON Data

 A post on the MySQL forums caught my eye today. The distilled question was why was an index not being used to search JSON data.  The poster (in blue) had done most of the steps needed almost correctly but just missed the crucial steps. 

Suppose we have this table with an index on a virtual generated column as JSON attribute index pattern

```
CREATE TABLE applications (
id BINARY(16) PRIMARY KEY,
data JSON NOT NULL,
) ENGINE=InnoDB;
CREATE INDEX idx ON applications ((CAST(data->>"$.name" AS CHAR(10))));

MySQL & Friends FOSDEM Dev Room

 FOSDEM has become one of the biggest shows on the calendar of the MySQL Community Team.  FOSDEM itself, until this year, is barely contained chaos at a university in Brussels with no pre-enrollment for any of the dozens of themed rooms and no head count.  This year the event is virtual so you do not have to get to Belgium.

The MySQL and Friends Developer Room is Sunday and starts at 10:00am  Belgium time with a retrospective of the first twenty five years of MySQL. This is followed 15 other talks of about 25 minutes on everything from ARM to user management. 

TITLE	SPEAKER	START	END
25 years of MySQL – A Retrospective	Dave Stokes	10:00	10:20
Open Source Database Infrastructure with Vitess	Shlomi Noach	10:30	10:55
From single MySQL instance to HA The journey to InnoDB Cluster	Frédéric Descamps	11:00	11:25
Group Replication: Best Practices for Network Deploy	Aníbal Pinto	11:30	11:55
Review of the Percona Operator from a DBA prospective	Marco Tusa (the Grinch)	12:00	12:25
MySQL Router REST API	Frédéric Descamps	12:30	12:55
Better User Management under MySQL 8.0	Dave Stokes	13:00	13:25
Running MySQL on ARM	Krunal Bauskar	13:30	13:55
Making MySQL-8.0 XA transaction processing crash safe The key to use MySQL as storage nodes for distributed databases	Wei Zhao	14:00	14:25
Passing query attributes through the MySQL protocol Extension to the wire format to allow data/metadata	Joro Kodinov	14:30	14:55
Linux /proc filesystem for MySQL DBAs Sampling /proc content for troubleshooting	Valerii Kravchuk	15:00	15:20
Rewrite Your Complex MySQL Queries for Better Performance	Øystein Grøvlen	15:30	15:55
Automatic Asynchronous Replication Connection Failover	Hemant Dangi	16:00	16:25
Sure you can run your database in kubernetes Successfully run your MySQL NDB Cluster in kubernetes	Bernd Ocklin	16:30	16:55
18 Things To Do When You Have a MySQL Bottleneck	Peter Zaitsev	17:00	17:25
Hitchhiker’s Guide to MySQL Don’t panic.	Liz van Dijk	17:30	17:55