With new MySQL Shell 8.0.13 comes a new way to quickly load JSON
data sets very quickly. In a past blog and in several talks
I have shown how to use the shell with the Python mode to pull in
the data. But now there is a much faster way to load
JSON
Load JSON Quickly Start a copy of the new shell with
mysqlsh. Connect to your favorite server \c
dave@localhost and then create a new schema
session.createSchema('bulk'). Then point you session to
the schema just created with \use bulk. Version
8.0.13 has a new utility function named importJson that does the
work. The first argument is the path to the data set (here
the MongoDB restaurant collection) and the second allows you to
designate the schema and collection where you wish to have the
data stored. In this example the data set was in the
downloads directory of my laptop and I wanted to put it in the
newly created 'bulk' schema …
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.…
The MySQL Development team is proud to announce a new version of the MySQL Shell which in addition to the usual bug fixes and enhancements to the existing components, offers new features we expect are quite useful in your day to day work.…
Uber is committed to delivering safer and more reliable transportation across our global markets. To accomplish this, Uber relies heavily on making data-driven decisions at every level, from forecasting rider demand during high traffic events to identifying and addressing bottlenecks…
The post Uber’s Big Data Platform: 100+ Petabytes with Minute Latency appeared first on Uber Engineering Blog.
Someone once told me you can tell how healthy a software project
is by the number of new books each year. For
the past few years the MySQL community has been blessed with one
or two books each year. Part of that was the major shift with
MySQL 8 changes but part of it was that the vast majority of the
changes were fairly minor and did not need detailed explanations.
But this year we have been blessed with four new
books. Four very good books on new facets of MySQL.
Introducing the MySQL 8 Document Store is the
latest book from Dr. Charles Bell on MySQL. If you have
read any other of Dr. Chuck's book you know they are well written
with lots of examples. This is more than a simple
introduction with many intermediate and advanced concepts covered
in detail.
| … |
I wrote MySQL and JSON: A Practical Programming Guide
to help developers find their way around the MySQL JSON data type
and the supporting functions. The MySQL Documentation on the
subject is very good but I had to puzzle through the examples to
see how things worked. I might be a bit 'thick' but good
examples always make things easier. Others seem to have
similar difficulties.
| MySQL and JSON a Practical Programming Guide should be on your desk as a handy reference to MySQL's JSON data type. |
There was a recent post on …
This year again, the MySQL Team is eager to participate in the Oracle Open World conference. This is a great opportunity for our engineers and the entire MySQL Team to highlight what we’ve done, and also what we are working on. Another reason to be excited this year is our new participation to Code One, the Oracle developer focused conference. Oracle Code One will include a full track dedicated to MySQL.
This is very good news for everybody attending, from DBAs to developers, as we will offer even more great content ! This year, in both events, we will highlight how NoSQL+SQL=MySQL.
Our MySQL Engineers will deliver fantastic sessions about …
[Read more]JSON (JavaScript Object Notation) is a popular way for moving data between various systems, including databases. Starting with 5.7 MySQL implemented a native JSON data type and a set of JSON functions that allows you to perform operations on JSON values.
Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell.
MySQL Shell
This is the last component in the cluster and I love it. Oracle have created this tool to centralize cluster management, providing a friendly, command-line based user interface.
The tool can be defined as an advanced MySQL shell, which is much more powerful than the well known MySQL client. With the capacity to work …
[Read more]In the old days, when we wanted to strengthen our skills the only option was to buy a good book. Nowadays one can find a lot of resources on the Internet, however quality is often poor. Fortunately there are still some great people who are brave enough to write new books that will help a new generation of women and men to build modern applications with MySQL the world's most popular open source database. Let me introduce you 3 MySQL books : Introducing the MySQL 8 Document Store / MySQL and JSON: A Practical Programming Guide / Pro MySQL NDB Cluster