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 ;
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
- dev
- tagtalking.net
- quads
- item 12957
See Also
- Thought Getting a new emoticon at fastblogit with 72 viewings related by tag "dev".
- Thought An Event is something that the news reports on with 42 viewings related by tag "quads".
- Thought Thinking Domain Quads with 13 viewings related by tag "quads".
- Thought The Mentography of Rights with 11 viewings related by tag "quads".
- Thought Quads with 8 viewings related by tag "quads".
- Thought about: Open Mic with 8 viewings related by tag "tagtalking.net".
- Thought Automating Selling on Amazon with 8 viewings related by tag "dev".
- Thought dynamic cartoons with 6 viewings related by tag "dev".
- Thought Why quads? Quads vs RDF with 6 viewings related by tag "quads".
- Thought [title (18144)] with 6 viewings related by tag "dev".
- Thought Google SEO for speaktomecatalog.com with 5 viewings related by tag "dev".
- Thought Feedback with 5 viewings related by tag "tagtalking.net".
- Thought group quads project with 5 viewings related by tag "quads".
- Thought about: Tag room: avatars with 5 viewings related by tag "tagtalking.net".
- Thought The CSS font-size statement does not work on the MacAir in Chrome with 5 viewings related by tag "dev".
- Thought Using FastBlogIt with Agile Processes with 5 viewings related by tag "quads".
- Thought Draft for UNIVERSAL DATA ACCESS syntax with 5 viewings related by tag "quads".
- Thought Linking fastblogit tags to other sites with 4 viewings related by tag "dev".
- Thought SQL for selecting triples inside of one field. with 4 viewings related by tag "dev".
- Thought mentography of items with 3 viewings related by tag "quads".
- Thought about: Quick Say at tagtalking.net with 3 viewings related by tag "tagtalking.net".
- Thought items as quads with 3 viewings related by tag "quads".
- Thought Designing the URL for with 3 viewings related by tag "dev".
- Thought A sustainable fastblogit with 3 viewings related by tag "dev".
- Thought Everything ? with 3 viewings related by tag "quads".
- Thought [title (18273)] with 2 viewings related by tag "dev".
- Thought Me represented in the Linked Data Cloud with 2 viewings related by tag "quads".
- Thought about: Testing Spin To Win with 2 viewings related by tag "dev".
- Thought A Gremlin on your items ? with 2 viewings related by tag "dev".
- Thought Simplifying URLs with 1 viewings related by tag "dev".
- Thought upload from computer to cartoon stopped working with 1 viewings related by tag "dev".
- Thought Repeating Quads Structure on tagtalking dev blog with 1 viewings related by tag "dev".
- Thought Rooms and People ... Tags and Names with 1 viewings related by tag "tagtalking.net".
- Thought Follow dev here with 1 viewings related by tag "dev".
- Thought Making Cool URLs with 1 viewings related by tag "dev".
- Thought about: Voice on the Go Inc. with 1 viewings related by tag "tagtalking.net".
- Thought about: season's greetings for everyone with 1 viewings related by tag "dev".
- Thought items vs quads gives us forms with 0 viewings related by tag "quads".
- Thought Replacing live search with 0 viewings related by tag "dev".
- Thought Building stufftalks.com with 0 viewings related by tag "dev".
- Thought tagtalking feeds with 0 viewings related by tag "tagtalking.net".
- Thought form vs data with 0 viewings related by tag "quads".
- Thought Revision of our catalog request form with 0 viewings related by tag "dev".
- Thought quads table in the database with 0 viewings related by tag "quads".
- Thought Eliminating the large shopping cart ...... with 0 viewings related by tag "dev".
- Thought about: Seasons Greetings for Everyone with 0 viewings related by tag "tagtalking.net".
- Thought about: Development at tagtalking with 0 viewings related by tag "dev".
- Thought Quads Factoring with 0 viewings related by tag "quads".
- Thought The server crashed with 0 viewings related by tag "dev".
- Thought Showing a YouTube video demo at speaktomecatalog.com with 0 viewings related by tag "dev".