How to extract an item from an array in a JSON object in MySQL
To extract an item from an array in MySQL you need to use the -> operator and the [item_number] JSON Path Syntax.
How to extract a field from a JSON object in MySQL
Mysql® offers three main ways to extract fields from a JSON document:
- the
->operator to extract the field as JSON - the
->>operator to extract the field as text - the
JSON_EXTRACTfunction
Both operators use the JSON Path Syntax
How to load JSON data in MySQL?
To load JSON data into a MySQL column you need to include it as string.
How to JSON in MySQL
This series covers how to solve common problems on JSON datasets with MySQL and it includes (links will appear once the target pages are up):
Pros and Cons of Multi Step Data Platforms
In the modern world, it’s rare to have the data in the same shape and platform from the beginning till the end of its journey. Yes, some technologies can achieve quite a good range of functionalities but sometimes at the expense of precision, developer experience or performance. Therefore, to achieve better or faster results, people might select a new tool for a precise task and start an implementation and integration process to move the data around.
So… what does a Staff Developer Advocate do?
So… what does a Staff Developer Advocate do, and how is it different from the Senior Developer Advocate role you were doing before?
I got this question three times in the last two weeks after my promotion from Senior to Staff (🎉🎉🎉🎉), from various people in my network.
Conference Talk: Boost Apache Kafka with Schema Registry
How and Why using Schema Registry with Apache Kafka
Custom event: Learn PostgreSQL JSON with Pizza
A talk about JSON handling in PostgreSQL: from data loading to query to indexing.
Pg Day Paris 2023: Fix Your Strings!
Strings are one of the most used types in databases; they can store pretty much any data and don’t enforce any rules on the inserted input. This talk showcases the risk of using strings and how to mitigate them to ensure data quality.
How to load JSON data in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB. This doc showcases how to load JSON data into a column.
