php with mysql

Last time we looked at a simple example program using the X Devapi and Node.JS. This time lets look at the Python version. Well, not actually the same. This time instead of looking for the Canadian record, the program limits the query to the first two records found. Besides Python 2.7, you will need to install the Google Protobuf code plus the development release of the Python Connector and a recent version of MySQL 5.7. The Code import mysqlx session = mysqlx.get_session({ # Authenticate to server 'host': 'localhost', 'port': 33060, 'user': 'dstokes', 'password': 'S3cR3t%'}) # Connect to Schema 'world_x' schema = session.get_schema('world_x'); # Set collection to 'countryinfo' collection = schema.get_collection('countryinfo') # Ask for two records result = collection.find().limit(2).execute() docs = result.fetch_all() # Print requested records for...

I have chatting with others who want to use the new X Devapi Document Store features but have not been able to find simple example programs. Finding the bridge between 'Hello World' and something useful can often be discouraging. Example Code Here is a very short Node.JS Docstore example program that accesses the ' countryinfo ' collection. More on why Node.JS and what software you need below. But for now regard this code to get one specific record from the database. var mysqlx = require('@mysql/xdevapi'); mysqlx.getSession({ //Auth to server host: 'localhost', port: '33060', dbUser: 'root', dbPassword: 'password' }).then(function (session) { // use world_x.country.info var schema = session.getSchema('world_x'); var collection = schema.getCollection('countryinfo'); collection // Get row for 'CAN' .find("$._id =...