Announcing: TiddlyWiki for SQL users

[Scott_Sauyet]

@etardiff

I’m not a SQL user, but I took a look anyway out of simple curiosity and was able to reverse-engineer some SQL concepts by analogy to your filters

Oh, that’s an interesting use I never considered!

@etardiff

I’d say this is an excellent start, Scott!

Thanks. Great to hear it!

@etardiff

I imagine you’re trying to limit the number of constructions used, but it might be worth it to reduce the cognitive load.

On the contrary, I am looking for the simplest-to-grok, most TW-idiomatic means of doing these things. What’s there now are the first things I got working. At some point, I will probably create a number of posts asking how to do various examples better. And that extends to a few of the templates I’ve used as well. But I need first to decide if the whole project seems worthwhile. And I’ll need a little time away from it to make that decision.

@etardiff

A quick note on your non-functional Example/041 - your filter’s not working because an extra period crept in.

D’Oh! I stared at that for so long, and simply couldn’t see it. Thank you.

@etardiff

[tag[Supplier]] :filter[[USA,Japan,Germany].split[,]match{!!country}]
                                           ^ delete me!

Thanks for highlighting that particular technique, by the way. It’s so elegant, and yet it would never have occurred to me!

All thanks for that should go to @saqimtiaz, who showed it to me in response to a previous question.

(In any case, that issue is fixed, but anyone who wants to see what we were talking about can find it in the old version: https://crosseye.github.io/TW5-SQL_Playground/0.1.0/#Example%2F041.)