Repeating Quads Structure on tagtalking dev blog

About: Quads Database for tagtalking

Here is the structure of the quads database that worked quite well …
 
source: data structure

CREATE TABLE `quads` (
  `context` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `verbseq` char(10) NOT NULL,
  `verb` varchar(100) NOT NULL,
  `objectseq` char(10) NOT NULL,
  `object` varchar(5000) NOT NULL,
  `objecttype` tinytext NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  `by` tinytext NOT NULL,
  `changeDate` datetime NOT NULL,
  `ip` char(20) NOT NULL,
  `protect` tinytext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `context` (`context`,`subject`,`verbseq`,`verb`),
  KEY `subject` (`subject`,`verbseq`,`verb`,`objectseq`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=221 ;
 
Each quad is supposed to be unique (there may only be one one) for each context+subject+verb+objectseq.  That will be enforced by the update code.
 ( what if someone updates the page_definitions directly with a duplicate ?) 
In most cases the quads are unique for context+subject+verb because in most cases objectseq is blank; but there needs to be multiples on things like page_definitions right_column, see bozo directory.

Tags

  1. item 12957
  2. quads
  3. dev
  4. tagtalking.net
  5. unique keys

See Also

  1. Thought Getting a new emoticon at fastblogit with 74 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 11 viewings related by tag "quads".
  5. Thought Quads with 8 viewings related by tag "quads".
  6. Thought about: Open Mic with 8 viewings related by tag "tagtalking.net".
  7. Thought Automating Selling on Amazon with 8 viewings related by tag "dev".
  8. Thought dynamic cartoons with 6 viewings related by tag "dev".
  9. Thought Why quads? Quads vs RDF with 6 viewings related by tag "quads".
  10. Thought [title (18144)] with 6 viewings related by tag "dev".
  11. Thought Google SEO for speaktomecatalog.com with 5 viewings related by tag "dev".
  12. Thought Feedback with 5 viewings related by tag "tagtalking.net".
  13. Thought group quads project with 5 viewings related by tag "quads".
  14. Thought about: Tag room: avatars with 5 viewings related by tag "tagtalking.net".
  15. Thought The CSS font-size statement does not work on the MacAir in Chrome with 5 viewings related by tag "dev".
  16. Thought Using FastBlogIt with Agile Processes with 5 viewings related by tag "quads".
  17. Thought Draft for UNIVERSAL DATA ACCESS syntax with 5 viewings related by tag "quads".
  18. Thought Linking fastblogit tags to other sites with 4 viewings related by tag "dev".
  19. Thought SQL for selecting triples inside of one field. with 4 viewings related by tag "dev".
  20. Thought mentography of items with 3 viewings related by tag "quads".
  21. Thought about: Quick Say at tagtalking.net with 3 viewings related by tag "tagtalking.net".
  22. Thought items as quads with 3 viewings related by tag "quads".
  23. Thought Designing the URL for with 3 viewings related by tag "dev".
  24. Thought A sustainable fastblogit with 3 viewings related by tag "dev".
  25. Thought Everything ? with 3 viewings related by tag "quads".
  26. Thought [title (18273)] with 2 viewings related by tag "dev".
  27. Thought Me represented in the Linked Data Cloud with 2 viewings related by tag "quads".
  28. Thought about: Testing Spin To Win with 2 viewings related by tag "dev".
  29. Thought A Gremlin on your items ? with 2 viewings related by tag "dev".
  30. Thought Simplifying URLs with 1 viewings related by tag "dev".
  31. Thought upload from computer to cartoon stopped working with 1 viewings related by tag "dev".
  32. Thought Rooms and People ... Tags and Names with 1 viewings related by tag "tagtalking.net".
  33. Thought Follow dev here with 1 viewings related by tag "dev".
  34. Thought Making Cool URLs with 1 viewings related by tag "dev".
  35. Thought about: Voice on the Go Inc. with 1 viewings related by tag "tagtalking.net".
  36. Thought about: season's greetings for everyone with 1 viewings related by tag "dev".
  37. Thought items vs quads gives us forms with 0 viewings related by tag "quads".
  38. Thought Replacing live search with 0 viewings related by tag "dev".
  39. Thought Building stufftalks.com with 0 viewings related by tag "dev".
  40. Thought tagtalking feeds with 0 viewings related by tag "tagtalking.net".
  41. Thought form vs data with 0 viewings related by tag "quads".
  42. Thought Revision of our catalog request form with 0 viewings related by tag "dev".
  43. Thought quads table in the database with 0 viewings related by tag "quads".
  44. Thought Eliminating the large shopping cart ...... with 0 viewings related by tag "dev".
  45. Thought about: Seasons Greetings for Everyone with 0 viewings related by tag "tagtalking.net".
  46. Thought about: Development at tagtalking with 0 viewings related by tag "dev".
  47. Thought Quads Factoring with 0 viewings related by tag "quads".
  48. Thought The server crashed with 0 viewings related by tag "dev".
  49. Thought Showing a YouTube video demo at speaktomecatalog.com with 0 viewings related by tag "dev".
  50. Thought about: five years, building a culture, and handing it off. - laughing meme with 0 viewings related by tag "dev".