Warning: Table './oots/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:164:\"Table './oots/comments' is marked as crashed and last (automatic?) repair failed\nquery: SELECT COUNT(*) FROM comments c WHERE c.nid = 170 AND c.status = 0\";s:5:\"%file\";s:44:\"/var/www/oots/modules/comment/comment.module\";s:5:\"%line\";i:991;}', 3, '', 'http://www.outoftheslipstream.com/node/170', '', '54.156.32.80', 1503060205) in /var/www/oots/includes/database.mysql.inc on line 135

Warning: Table './oots/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:432:\"Table './oots/comments' is marked as crashed and last (automatic?) repair failed\nquery: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 170 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50\";s:5:\"%file\";s:44:\"/var/www/oots/modules/comment/comment.module\";s:5:\"%line\";i:991;}', 3, '', 'http://www.outoftheslips in /var/www/oots/includes/database.mysql.inc on line 135
M/DB:X now morphs into a JSON/XML Hybrid Database | Out of the Slipstream
Home » Blogs » rob.tweed's blog
  • user warning: Table './oots/comments' is marked as crashed and last (automatic?) repair failed query: SELECT COUNT(*) FROM comments c WHERE c.nid = 170 AND c.status = 0 in /var/www/oots/modules/comment/comment.module on line 991.
  • user warning: Table './oots/comments' is marked as crashed and last (automatic?) repair failed query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 170 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50 in /var/www/oots/modules/comment/comment.module on line 991.

M/DB:X now morphs into a JSON/XML Hybrid Database

Submitted by rob.tweed on Fri, 07/03/2009 - 18:48

The new Build 4 of M/DB:X transforms it into something very exciting and wholly unique. M/DB:X is now not only a Native XML Database. By now also supporting JSON strings as inputs and optionally outputting its responses as JSON strings instead of XML, M/DB:X is now a JSON/XML hybrid database.

What's the significance of this? Well there are several important consequences:

If you feed a JSON string into M/DB:X's Parse Action, it will convert the JSON object into a corresponding XML DOM and store it. Now in XML DOM format, all the standard M/DB:X XML DOM API methods can be used to modify and manipulate what was originally a Javascript object, and the XML DOM can be searched using XPath. This is a very cool capability and extremely powerful.

The DOM can be returned in JSON format: M/DB:X will convert any XML DOM into a corresponding JSON object.

This now places M/DB:X in esteemed company: for example CouchDB and Persevere. JSON is increasingly being used as the lingua franca for describing objects, not just Javascript objects.

And unlike CouchDB which is still an alpha-grade Apache project, M/DB:X is underpinned by the tried and tested GT.M database with its solid commercial pedigree in the demanding banking industry.

The M/DB:X documentation will be updated to reflect the new JSON capability as soon as possible, but Build 4 is available for immediate download and use.

Watch this space for the next step which will be a mechanism for requesting a temporary secure token to allow restricted access to M/DB:X directly from a browser. This will allow M/DB:X to act as a persistent Javascript object store without the need for an intermediate proxy layer (except to make the authenticated request for a token). This is what CouchDB is aspiring to be but they're still struggling, it seems, with the security layer!

Oh and just for good measure, if you add the name/value pair OutputFormat=JSON to M/DB, it too will output its responses as JSON rather than the standard Amazon SimpleDB format XML !

See http://www.mgateway.com/mdbx.html for full details and documentation.

Furthermore, renowned XML database guru Ronald Bourret has added M/DB:X to his definitive list of Native XML Databases.