All posts by Paulo Jesus

About Paulo Jesus

Paulo Jesus is currently a Principal Software Developer at Oracle, working on MySQL InnoDB Cluster (MySQL Shell team). He received the BEng degree in systems and informatics in 2001, and the MSc degree in mobile systems in 2007, both from the University of Minho (Portugal). He obtained his Ph.D. degree in 2012, from the MAP-i doctoral program in computer science by the Universities of Minho, Aveiro, and Porto (Portugal). He has many years of professional experience as a software developer in relevant companies and taught informatics during 1 year. He is also an invited researcher at the HASLab / INESC TEC, University of Minho. His research interests include distributed algorithms, fault tolerance, and mobile systems. View all posts by Paulo Jesus →

Importing Data from MongoDB to MySQL: BSON Data Types

February 8, 2019DevOps, MySQL, ShellBSON, Import, JSON, MySQL ShellPaulo Jesus

The latest release of the MySQL Shell 8.0.14 (GA) improved the JSON import utility to support the conversion of more BSON data types from the strict mode representation of MongoDB Extended JSON. This removes a previous limitation regarding the import of more complex MongoDB data types to MySQL, making it more reliable.…

Importing Data from MongoDB to MySQL using Python

November 15, 2018MySQLPaulo Jesus

MySQL Shell 8.0.13 (GA) introduced a new feature to allow you to easily import JSON documents to MySQL. The basics of this new feature were described in a previous blog post. In this blog we we will provide more details about this feature, focusing on a practical use case of interest for to many: How to import JSON data from MongoDB to MySQL.…

Importing Data from MongoDB to MySQL using JavaScript

November 13, 2018MySQLPaulo Jesus

MySQL Shell 8.0.13 (GA) introduced a new feature to import JSON documents to MySQL in an easy way. The basics of this new feature were described in a previous blog post. Here, we provide more details about this feature, focusing on a practical use case that may be of interest for some readers: How to import JSON data from MongoDB to MySQL.…

Import JSON to MySQL made easy with the MySQL Shell

October 24, 2018DevOps, MySQL, ShellImport, JSON, MySQL ShellPaulo Jesus

The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features, for more information see the full changelog here: https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/mysql-shell-news-8-0-13.html. One of those features was the introduction of a convenient and easy way to import JSON documents to a MySQL Server database.…

MySQL Server Blog

News from the MySQL Server Team