[tw5] Re: TW "Tiddler DB" Strategy

2019-11-24 Thread TonyM
Q,

I reread your origtinal post. If you want your sentral DB in TW to have a 
database that you export part of for another application I would recommend 
the field based approach of Marks however if you really want to export with 
even this field not in the export you can take two approaches,


   - Develop a custom export process that does not include that field.
   - Use another way to select tiddlers. A Button or select appearing on 
   all tiddlers (using the view template) could allow you to add the 
   currentTiddler to a datatiddler as a list. The export filter would them 
   select all tiddlers in the data tiddler for export, so the organising list 
   has nothing within the selected tiddlers, it sits to the side in the data 
   tiddler. So for example you could have a tiddler projectname-tiddlers 
   containing tiddlers belonging to that project name. The view template could 
   also look up which projects the current tiddler is named in and display 
   this only in your central tiddler.. 

The beauty of tiddlywiki is it can accommodate more database models than 
you could design.

Regards
Tony

On Wednesday, November 20, 2019 at 11:59:48 AM UTC+11, Qalisto wrote:
>
> Hello, I am new to TW.
>
> It seems, I should have discovered it long ago.  (I had been using an app 
> for Windows called *ConnectedText.  *But, it lacks the killer feature of 
> TW which is single HTML distribution.*)*
>
> I have a question about the strategy for rational and flexible access to 
> Tiddlers.
>
> It seems to me that for Core Business interests that it may be wise to 
> just create Tiddlers as "info Lego blocks" into a "Core Bus. TW" as Tiddler 
> repository.
>
> Then, by using the correct coding or Tagging strategy, to be able to 
> extract a list of Tiddlers which one may wish to include in ... say 
> "Project A" (while the same Tiddlers may *also* be employed in "Project B".
>
> So, given the bewildering set of system, user, shadow Tiddlers, I am 
> wondering if anyone more experienced has a system which will:
>
> (1) Enable a single Tiddler to be coded in a way that will identify it as 
> in the family of say "Project A" and also "Project B" if it is a common 
> info bit.
>
> (2) Hide that multi-project coding since I will want to compile the family 
> of Tiddlers as a business presentation and leave the content "tidy"
>
> (3) And be able to order the extracted Tiddlers from the Core TW File in 
> the desired order of presentation
>
> Of course creating an "NY Public Library" of Tiddlers may be unwise.  I 
> don't know at what point a TW file becomes too fat and thus unwieldy. But, 
> I plan to create distinct ones where possible.
>
> There seems to be multiple solutions spread about various user URLs.  And 
> I am sure I could divine this with hours of research and trial and error.  
>
> I just wonder if someone *has been where I want to go *and can kindly 
> *share* a shortcut.
>
> Thanks for any help. ## Q ##
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/831b78ac-fb69-426d-a7b8-a6b0a719feef%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-20 Thread Donald Coates
I will try to make a list of some links but this is really the way to go.  
I play dwarf fortress and have been working with TW and I have found 
working with fields to be extremely powerful and flexible.  There are a lot 
of widgets that allow you to work with info searched for in fields as well 
so I would suggest really concentrating your 'learning curve ops' by 
searching and reading about fields and the widgets that allow you to work 
with them.  Mark's explanation here is really spot on.

On Tuesday, November 19, 2019 at 8:51:50 PM UTC-5, Mark S. wrote:
>
> There are many ways to put things together in TW. It kind of depends on 
> how monolithic the structure 
> you're attempting to create is.
>
> Here's one way.
>
> In terms of traditional relational databases, you can think of all 
> tiddlers that have the same tag
> as being rows in a table. The fields of each such tiddler are the fields 
> of the "table". The title
> should be thought of as an ID field, and not, unfortunately,as a title. 
> Use "caption" and "description"
> as the actual title fields. 
>
> Tag/Tables can form parent-child relations via reference fields. So you 
> might have several items
> tagged as "Project". Then you might have several tiddlers tagged as 
> "Tasks". Each tiddler tagged
> as "Task" can contain a reference back to the original project tiddler. 
> For instance, you might
> have a field "projid" that contains the name of the "parent" tiddler that 
> is tagged with "Project".
>
> Using nested list widgets, you can present the information in the Projects 
> and child Tasks
> much the way you would in various report tools.
>
> Project A
>Task A1
>Task  A2
> Project B
>   Task B1
>   Task B2
>
> The display doesn't have to show the tags or the reference fields that are 
> structuring the data.
>
> There are other people that would tag each task with the "parent" tiddler, 
> but that quickly leads to 
> tag pollution.
>
> So, there's one approach. It really depends a lot on what you are trying 
> to accomplish. I'm sure others
> will chime in with their thoughts.
>
>
> On Tuesday, November 19, 2019 at 4:59:48 PM UTC-8, Qalisto wrote:
>>
>> Hello, I am new to TW.
>>
>> It seems, I should have discovered it long ago.  (I had been using an app 
>> for Windows called *ConnectedText.  *But, it lacks the killer feature of 
>> TW which is single HTML distribution.*)*
>>
>> I have a question about the strategy for rational and flexible access to 
>> Tiddlers.
>>
>> It seems to me that for Core Business interests that it may be wise to 
>> just create Tiddlers as "info Lego blocks" into a "Core Bus. TW" as Tiddler 
>> repository.
>>
>> Then, by using the correct coding or Tagging strategy, to be able to 
>> extract a list of Tiddlers which one may wish to include in ... say 
>> "Project A" (while the same Tiddlers may *also* be employed in "Project B".
>>
>> So, given the bewildering set of system, user, shadow Tiddlers, I am 
>> wondering if anyone more experienced has a system which will:
>>
>> (1) Enable a single Tiddler to be coded in a way that will identify it as 
>> in the family of say "Project A" and also "Project B" if it is a common 
>> info bit.
>>
>> (2) Hide that multi-project coding since I will want to compile the 
>> family of Tiddlers as a business presentation and leave the content "tidy"
>>
>> (3) And be able to order the extracted Tiddlers from the Core TW File in 
>> the desired order of presentation
>>
>> Of course creating an "NY Public Library" of Tiddlers may be unwise.  I 
>> don't know at what point a TW file becomes too fat and thus unwieldy. But, 
>> I plan to create distinct ones where possible.
>>
>> There seems to be multiple solutions spread about various user URLs.  And 
>> I am sure I could divine this with hours of research and trial and error.  
>>
>> I just wonder if someone *has been where I want to go *and can kindly 
>> *share* a shortcut.
>>
>> Thanks for any help. ## Q ##
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/01325482-17f2-4398-b6a4-432b831585e8%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-20 Thread Qalisto
Thank you Mark and Luis ... will employ "learning curve ops"

On Wednesday, November 20, 2019 at 7:46:35 AM UTC, Luis Gonzalez wrote:
>
> *Notes:*
>
>- Usually a tiddler for the Project A is tagged with "Project A" tag.
>- A tiddler for both projects is tagged with "Project A" and "Project 
>B"
>- To have a list of the tasks for Project A you will write {{{ 
>[tag[Project A]] }}}. This is a filter, so you have to study filters.
>- To sort the tasks of Project A create a tiddler, "Project A" and put 
>the ordered list of tasks in the field "list" of this tiddler.
>- Tiddlywiki can do this automatically with the widget 
>list-links-draggable.
>- Create a new tiddler, Project B and add this code:
>!Tasks
>{{{ [tag[Project B]] }}}
>
>!Reorder tasks
><>
>- At first the "Reorder tasks" will be empty. Drag a task of the top 
>"Tasks" list under the "!Reorder tasks" to sort them. Add all tasks and 
>sort them dragging them.
>- Widgets are very powerful, you should check them.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/26b34e31-7022-45e8-90d5-3f905fe50eeb%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-19 Thread Luis Gonzalez


El miércoles, 20 de noviembre de 2019, 8:46:35 (UTC+1), Luis Gonzalez 
escribió:
>
> *Notes:*
>
>- Usually a tiddler for the Project A is tagged with "Project A" tag.
>- A tiddler for both projects is tagged with "Project A" and "Project 
>B"
>- To have a list of the tasks for Project A you will write {{{ 
>[tag[Project A]] }}}. This is a filter, so you have to study filters.
>- To sort the tasks of Project A create a tiddler, "Project A" and put 
>the ordered list of tasks in the field "list" of this tiddler.
>- Tiddlywiki can do this automatically with the widget 
>list-links-draggable.
>- Create a new tiddler, Project B and add this code:
>!Tasks
>{{{ [tag[Project B]] }}}
>
>!Reorder tasks
><>
>- At first the "Reorder tasks" will be empty. Drag a task of the top 
>"Tasks" list under the "!Reorder tasks" to sort them. Add all tasks and 
>sort them by dragging them.
>- Widgets are very powerful, you should check them.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/9641bd9b-eb95-408c-a6f2-daab034259a3%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-19 Thread Luis Gonzalez


El miércoles, 20 de noviembre de 2019, 8:46:35 (UTC+1), Luis Gonzalez 
escribió:
>
> *Notes:*
>
>- Usually a tiddler for the Project A is tagged with "Project A" tag.
>- A tiddler for both projects is tagged with "Project A" and "Project 
>B"
>- To have a list of the tasks for Project A you will write {{{ 
>[tag[Project A]] }}}. This is a filter, so you have to study filters.
>- To sort the tasks of Project A create a tiddler, "Project A" and put 
>the ordered list of tasks in the field "list" of this tiddler.
>- Tiddlywiki can do this automatically with the widget 
>list-links-draggable.
>- Create a new tiddler, Project B and add this code:
>!Tasks
>{{{ [tag[Project B]] }}}
>
>!Reorder tasks
><>
>- At first the "Reorder tasks" will be empty. Drag a task of the top 
>"Tasks" list under the "!Reorder tasks" to sort them. Add all tasks and 
>sort them by dragging them.
>- Widgets are very powerful, you should check them.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/3587f46c-b9ac--bb25-1dbee656cce4%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-19 Thread Luis Gonzalez
*Notes:*

   - Usually a tiddler for the Project A is tagged with "Project A" tag.
   - A tiddler for both projects is tagged with "Project A" and "Project B"
   - To have a list of the tasks for Project A you will write {{{ 
   [tag[Project A]] }}}. This is a filter, so you have to study filters.
   - To sort the tasks of Project A create a tiddler, "Project A" and put 
   the ordered list of tasks in the field "list" of this tiddler.
   - Tiddlywiki can do this automatically with the widget 
   list-links-draggable.
   - Create a new tiddler, Project B and add this code:
   !Tasks
   {{{ [tag[Project B]] }}}
   
   !Reorder tasks
   <>
   - At first the "Reorder tasks" will be empty. Drag a task of the top 
   "Tasks" list under the "!Reorder tasks" to sort them. Add all tasks and 
   sort them dragging them.
   - Widgets are very powerful, you should check them.

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/3fdfe908-8bf3-49d0-b8cb-0cf99116c8eb%40googlegroups.com.


[tw5] Re: TW "Tiddler DB" Strategy

2019-11-19 Thread 'Mark S.' via TiddlyWiki
There are many ways to put things together in TW. It kind of depends on how 
monolithic the structure 
you're attempting to create is.

Here's one way.

In terms of traditional relational databases, you can think of all tiddlers 
that have the same tag
as being rows in a table. The fields of each such tiddler are the fields of 
the "table". The title
should be thought of as an ID field, and not, unfortunately,as a title. Use 
"caption" and "description"
as the actual title fields. 

Tag/Tables can form parent-child relations via reference fields. So you 
might have several items
tagged as "Project". Then you might have several tiddlers tagged as 
"Tasks". Each tiddler tagged
as "Task" can contain a reference back to the original project tiddler. For 
instance, you might
have a field "projid" that contains the name of the "parent" tiddler that 
is tagged with "Project".

Using nested list widgets, you can present the information in the Projects 
and child Tasks
much the way you would in various report tools.

Project A
   Task A1
   Task  A2
Project B
  Task B1
  Task B2

The display doesn't have to show the tags or the reference fields that are 
structuring the data.

There are other people that would tag each task with the "parent" tiddler, 
but that quickly leads to 
tag pollution.

So, there's one approach. It really depends a lot on what you are trying to 
accomplish. I'm sure others
will chime in with their thoughts.


On Tuesday, November 19, 2019 at 4:59:48 PM UTC-8, Qalisto wrote:
>
> Hello, I am new to TW.
>
> It seems, I should have discovered it long ago.  (I had been using an app 
> for Windows called *ConnectedText.  *But, it lacks the killer feature of 
> TW which is single HTML distribution.*)*
>
> I have a question about the strategy for rational and flexible access to 
> Tiddlers.
>
> It seems to me that for Core Business interests that it may be wise to 
> just create Tiddlers as "info Lego blocks" into a "Core Bus. TW" as Tiddler 
> repository.
>
> Then, by using the correct coding or Tagging strategy, to be able to 
> extract a list of Tiddlers which one may wish to include in ... say 
> "Project A" (while the same Tiddlers may *also* be employed in "Project B".
>
> So, given the bewildering set of system, user, shadow Tiddlers, I am 
> wondering if anyone more experienced has a system which will:
>
> (1) Enable a single Tiddler to be coded in a way that will identify it as 
> in the family of say "Project A" and also "Project B" if it is a common 
> info bit.
>
> (2) Hide that multi-project coding since I will want to compile the family 
> of Tiddlers as a business presentation and leave the content "tidy"
>
> (3) And be able to order the extracted Tiddlers from the Core TW File in 
> the desired order of presentation
>
> Of course creating an "NY Public Library" of Tiddlers may be unwise.  I 
> don't know at what point a TW file becomes too fat and thus unwieldy. But, 
> I plan to create distinct ones where possible.
>
> There seems to be multiple solutions spread about various user URLs.  And 
> I am sure I could divine this with hours of research and trial and error.  
>
> I just wonder if someone *has been where I want to go *and can kindly 
> *share* a shortcut.
>
> Thanks for any help. ## Q ##
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to tiddlywiki+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/b601d620-77e5-4bab-842a-6fdeb7b36e7c%40googlegroups.com.