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 = 173 AND c.status = 0\";s:5:\"%file\";s:44:\"/var/www/oots/modules/comment/comment.module\";s:5:\"%line\";i:991;}', 3, '', 'http://outoftheslipstream.org/node/173', '', '54.156.67.122', 1508581926) 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 = 173 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://outoftheslipstrea in /var/www/oots/includes/database.mysql.inc on line 135
NoSQL at FOSDEM 2010 | Out of the Slipstream
  • user warning: Table './oots/comments' is marked as crashed and last (automatic?) repair failed query: SELECT COUNT(*) FROM comments c WHERE c.nid = 173 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 = 173 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50 in /var/www/oots/modules/comment/comment.module on line 991.

NoSQL at FOSDEM 2010

FOSDEM is a large Free and Open Source Developers' conference. This year it was at the Université libre de Bruxelles (ULB) and was attended by about 5,000 developers.

One of the tracks was NoSQL which embraces all of the Non-SQL databases that have emerged in the last couple of years. It appears to have been one of the most popular topics at the conference with standing room only for many of the presentations.

Rob Tweed and I both gave talks about some of the things we've been doing with GT.M. Rob talked about M/DB and M/DB:X while I talked about the XAPI service that GT.M provides for OpenStreetMap.

Judging from the questions at the end of my talk, I was impressed that at least some people in the room actually understood the most technical part of my talk. Geospatial indexing and the benefit that key compression in globals gives in this context.

Slides from both talks are available here:

http://www.slideshare.net/george.james/mdb-mdbx
http://www.slideshare.net/george.james/fosdem-2010-gtm-and-openstreetmap

And really good quality videos with synchonized slides are available here:
George's talk: http://www.parleys.com/#st=5&sl=1&id=1873
Rob's talk: http://www.parleys.com/#st=5&sl=9&id=1872