当前位置：网站首页>The database has a table in which JSON data is stored in one field. I need to parse this string when this table is updated, and then update the parsed JSON data to another table. What are the good sug

The database has a table in which JSON data is stored in one field. I need to parse this string when this table is updated, and then update the parsed JSON data to another table. What are the good sug

2022-04-21 09:05:00 【CSDN Q & A】

surface A When data is updated , Find the updated data , Analyze the json strand , Deposit table B.

I came up with two plans ：
1. Write a trigger , stay A When the data changes ,call Stored procedures , In stored procedure ,http Send to the interface for processing . But I don't know how to send... In a stored procedure http Access interface .
2. Parse in the database , use JSON_EXTRACT. When using this function , ordinary json That's all right. , complex json Will report a mistake .

I want to ask , Whether my plan is feasible , How to send data to the interface in the stored procedure ？ Or is there another good solution ？（ The database uses mysql）



Take the answer ：

It's best not to do it in the database , Can be based on message oriented middleware , Send the change and save it kafka, Then there is a separate program to process the logic after consumption , That is, send data to the interface

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204141800227852.html

边栏推荐

猜你喜欢

随机推荐