php with mysql

Indexing and the MySQL Document Store The MySQL Document Store allows developers who do not know Structured Query Language (SQL) to use MySQL as a high efficient NoSQL document store. It has several great features but databases, NoSQL and SQL, have a problem searching through data efficiently. To help searching, you can add an index on certain fields to go directly to certain records. Traditional databases, like MySQL, allow you to add indexes and NoSQL databases, for example MongoDB, lets you add indexes. The MySQL Document Store also allows indexing. So lets take a quick look at some simple data and then create an index. mysql-js> db.foo.find() [ { "Name": "Carrie", "_id": "888881f14651e711940d0800276cdda9", "age": 21 }, { "Name": "Alex", "_id": "cc8a81f14651e711940d0800276cdda9", "age": 24 }, { "La...

Opps! I admit my JavaScript skills are rusty and dusty. Plus I am new to Node.JS. So yesterdays blog drew some very helpful comments from two of MySQL's best. Johannes Schlüter and Rui Quelhas let me know there was a better way to code the example. Much thanks to them. Better Example // Simple example to grap one record and print it const mysqlx = require('@mysql/xdevapi'); const options = { host: 'localhost', port: 33060, // should be a number dbUser: 'root', dbPassword: 'Hell0Dave!' }; mysqlx .getSession(options) .then (session => { var schema = session.getSchema('world_x'); //equivilent of SELECT doc FROM countryinfo where _id = 'USA' var coll = schema.getCollection('countryinfo'); var query = "$._id == 'USA'"; // Print doc return Promise.all([ coll.find(query).execute(function (doc) { console.log(doc); }), session.close() ]); ...

JavaScript and MySQL Last time I looked at using the new MySQL Shell in JavaScript mode to access documents. I promised that I would look at indexes this time but a few folks wanted to see how to use the MySQL Document Store with Javascript -- the language not the MySQL Shell mode-- specifically with the Node.JS connector. And they ask for a very simple example. So Indexes in the future, Node.JS now. So this is a simple on using the MySQL Document Store from Node.JS. Install Download the Node.JS connector and then follow the very simple installation instructions. And use your OS's instictions for installing Node.JS. The documentation on using the Node.JS Connector with the XDevAPI is not written for folks just starting with either the API or Node.JS. Example const mysqlx = require('@mysql/xdevapi'); mysqlx.getSession({ // Create session host: 'localhost', port: '33060', dbUser: 'root', dbPassword: 'Hell0Dave!' ...

MySQL's new NoSQL database is quite a big change for all used to using a SQL speaking relational database. The Document Store makes use of the new MySQL Shell, the new X Protocol, and the new X Devapi to provide a NoSQL document storage service. This provides a way for developers to have a schema-less, NoSQL data store to build services and applications is a quick fashion without having to design a schema, normalize data, develop queries in SQL, or any of the rest of the overhead needed to create a relational databases. Behind the scenes and invisible to the developer is that the schema-less data is stores in a JSON type column in a MySQL instance. Please note that I am using JavaScript Mode (instead of SQL or Python) for these examples. No special reason. First Step The new MySQL Shell is a separate install from the server software. Once installed it will provide the ability to use MySQL as a document store. The db object is how we can communicate to the server and the world_x...