Uber Engineering
Uber’s mission is transportation as reliable as running water, everywhere, for everyone. Last time, we talked about the foundation that powers Uber Engineering. Now, we’ll explore the parts of the stack that face riders and drivers, starting …
The post The Uber Engineering Tech Stack, Part II: The Edge and Beyond appeared first on Uber Engineering Blog.
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 January I wrote my first post about node.js and MariaDB . In February I continued with a second post about using jQuery and some GIS calculations. Now it is time for the third and this time the main focus is not so much on GIS functionality, but instead on the capabilities MariaDB has for handling piles of unstructured data. In this case I’ll be focusing on crunching a pile of XML files without importing the XML data itself.
MariaDB 10.0, which had its GA launch in early April, includes the Connect engine. It has been developed to dynamically access all …
[Read more]I’ve continued building on my MariaDB GIS and node.js example application that I wrote about two weeks back, https://blog.mariadb.org/node-js-mariadb-and-gis/. The application shows how to load GPX information into MariaDB, using some MariaDB GIS functionality, and making use of the node.js platform together with MariaDB’s non-blocking client.
With the GPX data converted into GIS points in the MariaDB database, I wanted to further expand a little on both the GIS aspect and also look at how some additional data could be shown in the application by using jQuery’s Ajax calls to update a piece of the web based application UI.
To start with, an interesting thing to do when you have a bunch of GIS points in a …
[Read more]The availability of the node.js binding for MariaDB’s non-blocking client library together with the GIS capabilities of MariaDB inspired me to make an example of using node.js and MariaDB to import so-called GPX tracks to a MariaDB database and then show them on a map. GPX tracks are what are stored by many GPS devices including running watches and smartphones.
My project makes use of MariaDB’s non-blocking client library together with the node.js platform and on top of that uses the GIS functionality found in MariaDB 5.5 and 10.0.
To start with let’s go through the software and components I’m using:
On Thursday 12th September I co-presented a webinar on how MySQL Cluster delivers the key benefits of NoSQL Data Stores without having to give up the features that people rely on from relational databases (consistency, SQL etc.). There was a particular focus on how to use the new node.js JavaScript API which was recently released as part of MySQL Cluster 7.3. If you weren’t able to attend the live event then the webinar replay is available here. If you scroll down to the bottom of this post you’ll see a summary of the Questions and Answers from the session.
The new MySQL JavaScript Connector for Node.js is designed to deliver simplicity and high performance for JavaScript users.
Enables end-to-end JavaScript development, from the …
[Read more]Note that the webinar replay + transcript of the Questions and Answers is now available from here.
On Thursday 12th September I’ll be co-presenting a free webinar on how MySQL Cluster delivers the key benefits of NoSQL Data Stores without having to give up the features that people rely on from relational databases (consistency, SQL etc.). There will be particular focus on how to use the new node.js JavaScript API which was recently released as part of MySQL Cluster 7.3. As usual the webinar is free but you should …
[Read more]What programming languages and platforms do you use for large-scale projects in your organization?
If something is missing from the list please leave a comment and share your story. Thanks!
Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
The post Poll: What programming languages and platforms do you use? appeared first on MySQL Performance Blog.
