Quads Database for tagtalking

For the record, this is the structure of the Quads database that i am working on to run tagtalking.net .  Work is progressing on jimbo's description form.  Note how i'm going to use the | character to break up operands in the object field.

source: MySql export

CREATE TABLE `quads` (
  `context` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `verbseq` char(10) default NULL,
  `verb` varchar(100) NOT NULL,
  `objectseq` char(10) default NULL,
  `object` varchar(5000) default NULL,
  `objecttype` tinytext,
  `id` int(11) NOT NULL auto_increment,
  `by` tinytext,
  `changeDate` datetime default NULL,
  `ip` char(20) default NULL,
  `protect` tinytext,
  PRIMARY KEY  (`id`),
  KEY `context` (`context`,`subject`,`verbseq`,`verb`),
  KEY `subject` (`subject`,`verbseq`,`verb`,`objectseq`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

...

Tags

  1. dev
  2. tagtalking.net
  3. quads
  4. item 12957

Comments

Seth says
This item is outdated by 13073

See Also

  1. Thought Getting a new emoticon at fastblogit with 66 viewings related by tag "dev".
  2. Thought An Event is something that the news reports on with 42 viewings related by tag "quads".
  3. Thought Thinking Domain Quads with 13 viewings related by tag "quads".
  4. Thought The Mentography of Rights with 9 viewings related by tag "quads".
  5. Thought Automating Selling on Amazon with 8 viewings related by tag "dev".
  6. Thought about: Open Mic with 6 viewings related by tag "tagtalking.net".
  7. Thought Why quads? Quads vs RDF with 6 viewings related by tag "quads".
  8. Thought The CSS font-size statement does not work on the MacAir in Chrome with 5 viewings related by tag "dev".
  9. Thought Linking fastblogit tags to other sites with 4 viewings related by tag "dev".
  10. Thought Quads with 3 viewings related by tag "quads".
  11. Thought mentography of items with 3 viewings related by tag "quads".
  12. Thought A sustainable fastblogit with 3 viewings related by tag "dev".
  13. Thought Everything ? with 3 viewings related by tag "quads".
  14. Thought about: Testing Spin To Win with 2 viewings related by tag "dev".
  15. Thought [title (18144)] with 2 viewings related by tag "dev".
  16. Thought Google SEO for speaktomecatalog.com with 1 viewings related by tag "dev".
  17. Thought Simplifying URLs with 1 viewings related by tag "dev".
  18. Thought upload from computer to cartoon stopped working with 1 viewings related by tag "dev".
  19. Thought Rooms and People ... Tags and Names with 1 viewings related by tag "tagtalking.net".
  20. Thought SQL for selecting triples inside of one field. with 1 viewings related by tag "dev".
  21. Thought A Gremlin on your items ? with 1 viewings related by tag "dev".
  22. Thought about: season's greetings for everyone with 1 viewings related by tag "dev".
  23. Thought items vs quads gives us forms with 0 viewings related by tag "quads".
  24. Thought Repeating Quads Structure on tagtalking dev blog with 0 viewings related by tag "dev".
  25. Thought dynamic cartoons with 0 viewings related by tag "dev".
  26. Thought Replacing live search with 0 viewings related by tag "dev".
  27. Thought Building stufftalks.com with 0 viewings related by tag "dev".
  28. Thought tagtalking feeds with 0 viewings related by tag "tagtalking.net".
  29. Thought form vs data with 0 viewings related by tag "quads".
  30. Thought Revision of our catalog request form with 0 viewings related by tag "dev".
  31. Thought Follow dev here with 0 viewings related by tag "dev".
  32. Thought quads table in the database with 0 viewings related by tag "quads".
  33. Thought Eliminating the large shopping cart ...... with 0 viewings related by tag "dev".
  34. Thought Making Cool URLs with 0 viewings related by tag "dev".
  35. Thought [title (18273)] with 0 viewings related by tag "dev".
  36. Thought about: Seasons Greetings for Everyone with 0 viewings related by tag "tagtalking.net".
  37. Thought about: Development at tagtalking with 0 viewings related by tag "dev".
  38. Thought Quads Factoring with 0 viewings related by tag "quads".
  39. Thought The server crashed with 0 viewings related by tag "dev".
  40. Thought Showing a YouTube video demo at speaktomecatalog.com with 0 viewings related by tag "dev".
  41. Thought about: five years, building a culture, and handing it off. - laughing meme with 0 viewings related by tag "dev".
  42. Thought about: tvos for developers - apple developer with 0 viewings related by tag "dev".
  43. Thought Permalinks now have a facebook share button on them. with 0 viewings related by tag "dev".
  44. Thought about: d'artagnan's code - code and plugins for everyone with 0 viewings related by tag "dev".
  45. Thought about: Quick Say at tagtalking.net with 0 viewings related by tag "tagtalking.net".
  46. Thought about: Voice on the Go Inc. with 0 viewings related by tag "tagtalking.net".
  47. Thought [title (19071)] with 0 viewings related by tag "dev".
  48. Thought My Objectives for with 0 viewings related by tag "tagtalking.net".
  49. Thought Seriously considering developing tagtalking.net based upon ... with 0 viewings related by tag "dev".
  50. Thought Feedback with 0 viewings related by tag "tagtalking.net".