We have some migrations coming up in which we’ll move some of the MySQL schemas to Singlestore. The tables in those schemas have JSON fields as well. From what I have found on the web till now, it looks like JSON in MySQL and Singlestore are quite similar. Both enforce utf8mb4 character set and utf8mb4_bin collation by default. Also, unlike MariaDB, both do not allow non JSON data and on multiple other fronts as well it looks similar. The only thing is seems to be the way to fetch the JSON data is different in MySQL and Singlestore.
Do you guys suggest anything else that we’ll need to take care of related to JSON when coming from MySQL to Singlestore? We’re in very early stages so looking to gather and work on as many issues as possible early.