Hello hello Claudio and all. I am feeling 'at home' here concerning this idea. Before I go on, have you blokes seen CouchApp and CouchDB?
* http://books.couchdb.org/relax/ It uses a jQuery framework to serve up 'text' based on some namespace (table) and name hash (index column). No offence intended with such gross over-simplifications. One thing I thought of, might be to use 'couchdb' with TiddlyWiki to fabricate a shared. distributed REST-ful TiddlyWiki style wiki. Everything is the 'same', but everyone involved has their tiddlers replicated (shadowed) in a couchDB back-end (foundation? store -- For want of a better name). Returning specifically to the database theme (but). A little while ago, I wanted to use TiddlyWiki for a prototype engine to demonstrate web site models 'fast'. And the database functionality came up when considering that idea. Mostly because Most web sites of enough complexity depend on a way to change stuff and personalise/customise the rendered pages. The idea I had for mock-ups was to use transclusions to bring in rows. Yes, I concede it was quick and dirty. It had the advantage of making a Tiddler =0= one table. I made the 'rows' were like a primary key, using a heading. Example: Table_one | col 1 | col 2 | col 3 | <<tiddler [[Table_one##key=001]]>> <<tiddler [[Table_one##key=002]]>> <<tiddler [[Table_one##key=003]]>> ----------------------- Table_one_cols !key=001 |col_01 | col_02| col_03 | !key=002 |col_01 | col_02| col_03 | !key=003 |col_01 | col_02| col_03 | !(end) Alas, it didn't quite work out, and I was reduced to making mock-up via one table in Table_one. As an alternative, you can transclude cell contents -- In that scheme (which was too specific for my needs) ... You can have one table transcluding cells via naming conventions for 'rows' and 'columns', viz. Table_one | col 1 | col 2 | col 3 | |<<tiddler [[tmp##row=001,col=001]]>> |<<tiddler [[tmp##row=001,col=002]]>> |<<tiddler [[tmp##row=001,col=003]]>> | |<<tiddler [[tmp##row=002,col=001]]>> |<<tiddler [[tmp##row=002,col=002]]>> |<<tiddler [[tmp##row=002,col=003]]>> | |<<tiddler [[tmp##row=003,col=001]]>> |<<tiddler [[tmp##row=003,col=002]]>> |<<tiddler [[tmp##row=003,col=003]]>> | ---- tmp !row=001,col=001 (1,1) !row=002,col=001 (2,1) !row=003,col=001 (3,1) !row=001,col=002 (1,2) !row=002,col=002 (2,2) !row=003,col=002 (3,2) !row=001,col=003 (1,3) !row=002,col=003 (2,3) !row=003,col=003 (3,3) !(end) I thought you can have a tiddler per cell, this way at least all of the table lives in one tiddler. Harking back to the couchdb model, if you succeeded with that, I thought each cell's contents could be 'couchdb document' indexed by row/column tuples. Intuitively I think there's probably a more elegant way to go. Like generating the cell name dynamically (via a macro or function). This is more or less a 'thunk' such that you can call-up a tiddler (cell) "by name" or "by reference". Hopefully that's food for thought. I have one question in return. Most of the time I found databases need to be operated on -- Search/ Filter/Join or Combine/etc and basic set algebra operations -- To be really helpful. Otherwise they just become mere tables. I'm wondering how much functionality will your use-cases need from the Tiddler-based-database? Cheers, Will On Aug 18, 4:36 pm, Claudio <[email protected]> wrote: > > To imitate this good app (http://www.thepapertiger.com/), here're > something I want to try. > > 1. Append "serial number" to a custom field so that when I add a > tiddler, it will be labeled 001, and subsequent tiddlers 002, > 003....,etc. Better if this field is not user-editable. > > 2. Optionally display tiddlers as rows, with a "preview" column that > displays the first few lines of the content. > |Serial|Title|Tag|Content|Last Modified|Custom Field 1|Custom Field 2| > |023|Test Tiddler|This is a testing tiddler that...|2010-08-08|CF1| > CF2| > > Click on a title displays the tiddler the standard way. -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.
