Here’s the behind-the-scenes story about how Uber Engineering’s Driver Team continues to develop our virtual onboarding funnel to get hundreds of thousands of driver-partners on the road earning money with Uber.
The Consequences of Scale for Driver-Partners
Our team cares …
The post How Uber Engineering Massively Scaled Global Driver Onboarding appeared first on Uber Engineering Blog.
I released version 3.5.6 of MyQuery, and there are quite a number
of new features and fixes in there. The #1 bugfix is that the
annoying access warnings that poped up from Windows when saving
to the registry are gone, as I have now moved the registry to a
more Windows 10 acceptable place. Among the new features
are:
As this is a version with many new features, I still
consider this a Beta. I have built it on Windows 10 and tested it
on Windows 10 and 7, 64-bit, although MyQuery itself is still a
32-bit windows application.
Happy SQL'ing
/Karlsson
In the previous blog post we explained how work with the collection CRUD operations. In this blog post we are going to explain other functions that are related to document management.
We already know how to create collections, as well as how to add, delete, update and retrieve documents from them. But, how can we add a new field to a document or documents that are in a collection?
The following code demonstrates how to do it:
var mysqlx = require('mysqlx');
mysqlx.getSession({
host: 'host',
port: '33060',
dbUser: 'root',
dbPassword: 'my pass'
}).then(function (session) {
var schema = session.getSchema('mySchema');
var coll = schema.getCollection('myColl');
var query = "$.name == 'NewField'";
var newDoc = { name: 'NewField', description: 'a new field',
extra: ['hello', 'world'] …[Read more]
Is it cheating? Is using MySQL without Structured Query Language (SQL) or putting all your data into one column proper? Impossible a year ago and probably thought as a poor/crazy practice until recently, this is a new type of MySQL usage. NoSQL has had a big impact in the SQL world with several relational products from vendors like MySQL, Microsoft, Postgresql and others offering NoSQL interfaces and JSON data types to their databases.
Several old timers have come to me asking if putting lots of data in a JSON column is cheating? After all data normalization is part of relational databases and the way to efficiency and speed is well organized data. This higgledy–piggledy fashion of putting an entire document in a column without breaking it down to its component sections does violate the first rule of data normalization. And that has …
[Read more]In the previous blog post we explained how to create schemas and collections. In this one we are going to explain how to work with collections: adding, updating and deleting documents.
The following code demonstrates how to add a single document to an existing collection:
var mysqlx = require('mysqlx');
mysqlx.getSession({
host: 'host',
port: '33060',
dbUser: 'root',
dbPassword: 'my pass'
}).then(function (session) {
var schema = session.getSchema('mySchema');
var coll = schema.getCollection('myColl');
var newDoc = { name: 'Test Name', description: 'Test Description' };
coll.add(newDoc).execute().then(function (added) {
console.log('Document(s) added: '
+ added.getAffectedItemsCount());
session.close();
})
.catch(function (err) {
console.log(err.message);
console.log(err.stack); …[Read more]
In a previous post we explained how to connect to a MySQL server configured as a document store using the new MySQL Connector/Node.js. In this post we are going to explain how to create a schema, create a collection and add documents to the collection.
Creating a new schema is very easy; the following code demonstrates how to do it:
var mysqlx = require('mysqlx');
mysqlx.getSession({
host: 'host',
port: '33060',
dbUser: 'root',
dbPassword: 'my pass'
}).then(function (session) {
session.createSchema('mySchema').then(function(schema){
console.log('Schema created');
session.close();
});
}).catch(function (err) {
console.log(err.message);
console.log(err.stack);
});
In the previous code example we created a connection and then used the XSession object to create a schema, finally we closed the connection.
The first …
[Read more]In this post we are going to explain how to connect a Node.js application to a MySQL server using the new MySQL Connector/Node.js; needless to say that we will be using the MySQL server as a document store.
There are two types of session that a connection can provide:
XSession and NodeSession.
An XSession encapsulates access to a single MySQL server running
the X Plugin or
multiple MySQL Cluster nodes; and the NodeSession serves as an
abstraction for a physical connection to exactly one MySQL server
running the X Plugin. To enable the XPlugin in the MySQL server
using the MySQL Client command line you need to use the root
account or an account with INSERT privilege to mysql.plugin
table:
Examples are a great way to learn new things. As many of you may or may not know we’ve added some new things to MySQL Server 5.7.12 and the ecosystem around it, extending it to allow you to use the MySQL as a Document Store. Meeting the challenge meant expanding Developer Interfaces and Database tools.
From the developer side the MySQL Document Store new APIs by …
[Read more]In this blog post, I’ll discuss how to use MySQL 5.7 Document Store to track data from Internet of Things (IoT) devices.
Using JSON in MySQL 5.7
In my previous blog post, I’ve looked into MySQL 5.7.12 Document Store. This is a brand new feature in MySQL 5.7, and many people are asking when do I need or want to use the JSON or Document Store interface?
Storing data in JSON may be quite useful in some cases, for example:
The MySQL Document Store introduced with version 5.7.12 allows developers to create document collections without have to know Structured Query Language. The new feature also comes with a new set of terminology. So let us create a collection and see what it in it (basically creating a table for us SQL speakin' old timers).
So start the mysqlsh program, connect to the server, change to the world-x schema (database) switch to Python mode, a create a collection (table).
What did the server do for us? Switching to SQL mode, we can use describe to see what the server has done for us.
We have a two column …
[Read more]
