Using JSON in a Relational Database Best Practices

Talk by Dave Stokes

Relational databases = strict data types and stored schema. JSON = free form but no data rigor. But what if you could reliably use JSON in your relational database to get performance, the processing power of SQL and reatain the flexibility JSON is know for. This talk will cover the best practices for using JSON in your realtional database, how to temporarily transform unstructured JSON to structured with JSON_TABLE() or permanently with generated columns. And how do you ensure that the JSON data has the proper format or is required before entry.