A little appreciation for TiddlyWiki filtering

[Charlie Veniot]

G'day,

I just wanted to lob a bit of appreciation for filtering in TiddlyWiki, and the fantastic thoughtful design behind it all.

The mechanics of filtering in TiddlyWiki matches the way I code SQL: a series of transformations.  I profoundly like this.

Start simple, transform transform transform (or tweak tweak tweak, or incrementally iterate incrementally iterate incrementally iterate) from something basic/raw towards some end result.

Although I could write many things in one line of SQL, I found that a pain in the rear to maintain/debug (i.e. the series of transformations are not visible.)  I much prefer visible layers of transformations.

So all of my SQL usually took the form:

SELECT ....

  FROM any_number_of_join_tables_and/or subqueries,

       (SELECT ...

          FROM (SELECT ...

                  FROM any_number_of_join_tables, some_base_table

                 WHERE some_conditions)

         WHERE ...

         GROUP BY ...

         HAVING ...)

 WHERE ...

 GROUP BY ...

 HAVING ...

 ORDER BY ...

  

Realizing this similarity between TiddlyWiki filtering and my approach to SQL writing, it has been subconsciously simmering in me sponge for a bit (i.e. there's something I'm liking here, but I can't quite put my finger on it),  and my Gazoo moment ("hey, dumb dumb, this is what it is.)

All of that along with this insta-thought out of nowhere:

Everywhere I look, I see Tiddlers.  They don't even know their Tiddlers... 

This brain-fart episode brought to you by me (writing "out loud").

[PMario]

On Saturday, February 27, 2021 at 3:54:24 PM UTC+1 cj.v...@gmail.com wrote:

G'day,

Hi,

Nice write up. Thanks!

...

Realizing this similarity between TiddlyWiki filtering and my approach to SQL writing, it has been subconsciously simmering in me sponge for a bit (i.e. there's something I'm liking here, but I can't quite put my finger on it),  and my Gazoo moment ("hey, dumb dumb, this is what it is.)

....

I like those moments ;)

-mario