The MySQL Document Store and X Devapi have a lot of very interesting features but right now my programming language of choice, PHP, is not yet supported. My Python is rusty and learning Node.JS is progressing. But the ability to search data from a database without knowing Structured Query Language (SQL) is going to appeal to many. Example One
import mysqlx[Read more]
import string
session = mysqlx.get_session({
'host': 'localhost',
'port': 33060,
'user': 'dstokes',
'password': 'Hell0Dave!'})
schema = session.get_schema('world_x');
collection = schema.get_collection('countryinfo')
print "Find three records***\n"
result = collection.find().limit(3).execute()
docs = result.fetch_all()
for i, data in enumerate(docs):
print "{iteration}: {data}".format(iteration = i, data=data)
print "Find USA***\n"
result = collection.find('_id = "USA"').execute()
row = …
