Re: [tw5] Re: What if SQL statements could be used in TiddlyWiki?

[CJ Veniot]

Arg!  You are absolutely right.  I skipped handling empty fields.

I had imposed on myself a hard 10:30 PM  cutoff time on that first crack at
it, and had not gotten around to validating the result set.

First thing to fix when I get back at it tomorrow.

Thanks !

On Thu, Nov 24, 2022 at 11:39 PM Eric Shulman  wrote:

> This is some interesting stuff!
>
> I notice that in the PDF output, if a tiddler listed in "The record set"
> table doesn't have some fields (or the field value is blank, or two fields
> have exactly the same value), that row of the table omits the corresponding
> cell, rather than showing a blank placeholder cell (or a repeated value if
> two fields have matching values).  The result is that the cells for that
> tiddler don't align with the corresponding field name headings.
>
> Example 1:
> "Interactive Git Documentation by Devin Weaver" has a blank "type" field.
> The result is that the "url" field value is displayed under the "type"
> column heading
>
> Example 2:
> "Simple Zork-like Game by Jed Carty" has the same timestamp for "created"
> and "modified" (20141118143636664).
> The result is that the "modified" field value is omitted from the table,
> and the "text" field value is displayed under the "tags" column heading.
>
> Since I can't look at your code to see what you are doing, I can only
> guess at some possible workarounds for these issues.
>
> I assume you are using some filter syntax to iterate over the fields of a
> tiddler and using something like "get" to retrieve the values
> that are shown in the table cells.  If this is the case, you might try
> using something like "getelse[]", which would ensure that
> empty/missing fields are converted to blank text rather than being
> omitted.  For the duplicate value problem, you might try preceding the
> relevant filter run syntax with "=" to preserve duplicate values in the
> results.
>
> Hope this helps,
> -e
> On Thursday, November 24, 2022 at 6:29:38 PM UTC-8 cj.v...@gmail.com
> wrote:
>
>> select * from Examples
>>
>> Results (preceded by sanity-checks of steps towards result set) in
>> attached PDF.
>>
>> On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot wrote:
>>
>>> Working on:  select * from Examples
>>>
>>> Using TiddlyWiki.com
>>>
>>> The tag "Examples" being the table.
>>>
>>> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot wrote:
>>>
 As always, the question of "how would I do that/this in TiddlyWiki"
 just grabs me by the jugular (i.e. it gets all of my attention.)

 Proof of concept prototype pending ...

>>> --
> You received this message because you are subscribed to a topic in the
> Google Groups "TiddlyWiki" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/tiddlywiki/GWxH8tPzDn4/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> tiddlywiki+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/tiddlywiki/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com
> 
> .
>

-- 
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/CAMu8EfMt3pQqbV9tyhQN%2BOn%2BC-bYVT7vnygdG0wD75CU4%3D%2B61g%40mail.gmail.com.

[tw5] SQL Query

[Tech Lover]

Hi,

It would be GREAT if tiddly wiki provides some compatability with plugin for

1. SQL query execution to get the results
2. Build External Corpus for faster search

Thanks

-- 
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/3b7e1c8e-eac7-4962-a722-439325a68107n%40googlegroups.com.

[tw5] Log Search via Tiddlywiki

[Tech Lover]

Hi,

I know tiddly wiki is super fast in searching
Can someone help me how to import huge log files in tiddly wiki?
Does it support zip format to upload? any plugin to process zip version

Thanks

-- 
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/1197f440-df04-4079-896b-440984cc23c3n%40googlegroups.com.

[tw5] Re: What if SQL statements could be used in TiddlyWiki?

[Eric Shulman]

This is some interesting stuff!

I notice that in the PDF output, if a tiddler listed in "The record set" 
table doesn't have some fields (or the field value is blank, or two fields 
have exactly the same value), that row of the table omits the corresponding 
cell, rather than showing a blank placeholder cell (or a repeated value if 
two fields have matching values).  The result is that the cells for that 
tiddler don't align with the corresponding field name headings.

Example 1:
"Interactive Git Documentation by Devin Weaver" has a blank "type" field.
The result is that the "url" field value is displayed under the "type" 
column heading

Example 2:
"Simple Zork-like Game by Jed Carty" has the same timestamp for "created" 
and "modified" (20141118143636664).
The result is that the "modified" field value is omitted from the table, 
and the "text" field value is displayed under the "tags" column heading.

Since I can't look at your code to see what you are doing, I can only guess 
at some possible workarounds for these issues.

I assume you are using some filter syntax to iterate over the fields of a 
tiddler and using something like "get" to retrieve the values 
that are shown in the table cells.  If this is the case, you might try 
using something like "getelse[]", which would ensure that 
empty/missing fields are converted to blank text rather than being 
omitted.  For the duplicate value problem, you might try preceding the 
relevant filter run syntax with "=" to preserve duplicate values in the 
results.

Hope this helps,
-e
On Thursday, November 24, 2022 at 6:29:38 PM UTC-8 cj.v...@gmail.com wrote:

> select * from Examples
>
> Results (preceded by sanity-checks of steps towards result set) in 
> attached PDF.
>
> On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot wrote:
>
>> Working on:  select * from Examples
>>
>> Using TiddlyWiki.com
>>
>> The tag "Examples" being the table.
>>
>> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot wrote:
>>
>>> As always, the question of "how would I do that/this in TiddlyWiki" just 
>>> grabs me by the jugular (i.e. it gets all of my attention.)
>>>
>>> Proof of concept prototype pending ...
>>>
>>

-- 
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/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com.

[tw5] Re: What if SQL statements could be used in TiddlyWiki?

[Charlie Veniot]

And because Talk TiddlyWiki does not allow attachments, you'll have to find 
it in the Google Groups thread for these 
posts: https://groups.google.com/g/tiddlywiki/c/GWxH8tPzDn4

On Thursday, November 24, 2022 at 10:29:38 PM UTC-4 Charlie Veniot wrote:

> select * from Examples
>
> Results (preceded by sanity-checks of steps towards result set) in 
> attached PDF.
>
> On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot wrote:
>
>> Working on:  select * from Examples
>>
>> Using TiddlyWiki.com
>>
>> The tag "Examples" being the table.
>>
>> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot wrote:
>>
>>> As always, the question of "how would I do that/this in TiddlyWiki" just 
>>> grabs me by the jugular (i.e. it gets all of my attention.)
>>>
>>> Proof of concept prototype pending ...
>>>
>>

-- 
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/3c2a22ff-d080-4c54-b280-5abc1121bff4n%40googlegroups.com.

[tw5] Re: What if SQL statements could be used in TiddlyWiki?

[Charlie Veniot]

select * from Examples

Results (preceded by sanity-checks of steps towards result set) in attached 
PDF.

On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot wrote:

> Working on:  select * from Examples
>
> Using TiddlyWiki.com
>
> The tag "Examples" being the table.
>
> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot wrote:
>
>> As always, the question of "how would I do that/this in TiddlyWiki" just 
>> grabs me by the jugular (i.e. it gets all of my attention.)
>>
>> Proof of concept prototype pending ...
>>
>

-- 
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/0c16d153-73eb-4488-adf7-9127bd9a9302n%40googlegroups.com.


select _ from Examples.pdf
Description: Adobe PDF document

[tw5] Re: What if SQL statements could be used in TiddlyWiki?

[Charlie Veniot]

Working on:  select * from Examples

Using TiddlyWiki.com

The tag "Examples" being the table.

On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot wrote:

> As always, the question of "how would I do that/this in TiddlyWiki" just 
> grabs me by the jugular (i.e. it gets all of my attention.)
>
> Proof of concept prototype pending ...
>

-- 
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/83f56d53-3fdc-4d80-b64c-bd5c06d0e1bfn%40googlegroups.com.

[tw5] What if SQL statements could be used in TiddlyWiki?

[Charlie Veniot]

As always, the question of "how would I do that/this in TiddlyWiki" just 
grabs me by the jugular (i.e. it gets all of my attention.)

Proof of concept prototype pending ...

-- 
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/e38fbf85-44a7-4829-b5b0-5ffe77e4af24n%40googlegroups.com.