Conference Talk: Attacking (and defending) Apache Kafka
Kafka Connect sink to OpenSearch/ElasticSearch: how to sink unix timestamps
When sinking unix timestamps from Apache Kafka to OpenSearch/ElasticSearch using the dedicated connector, they are not recognized by default as timestamp in the target tech.
Consume Apache Kafka® messages via REST APIs
Current 2023: From Batch to Streaming Data Pipeline Evolution
How to tabulate a JSON document in MySQL
You can tabulate a JSON document (retrieve it as a row) in MySQL with the JSON_TABLE
function.
How to remove a field in a JSON document in MySQL
You can remove a field from JSON document in MySQL with the JSON_REMOVE
function.
How to insert a field in a JSON document in MySQL
You can insert a field in a JSON document in MySQL with the JSON_INSERT
function.
How to edit a JSON document in MySQL
You can edit a JSON document in MySQL with:
- The
JSON_SET
function that will replace values for JSON paths that exists and add values for the ones that don’t exist. - The
JSON_REPLACE
function that will replace values for JSON paths that exists and ignore the ones that don’t exist.
How to merge JSON documents in MySQL
You can merge two JSON documents in MySQL with:
- the
JSON_MERGE_PRESERVE
function to concatenate the document values - the
JSON_MERGE_PATCH
function to keep the latest value for each key