There have been several discussions recently that touched on the usage of TiddlyWiki as a small relational database. While I didn’t chime in on those, that is very much how I tend to use TW. I got to thinking that it would be useful to explain the techniques involved. So I started something. (Bo…

Sorry, just jumping in to add that you may also be interested in the optional :include/:exclude suffixes available to the fields operator . E.g. for my own wikis, I’ve defined a global variable, \define systemFields() draft.title draft.of title tags text type created creator modified modifier which…

[image] Charlie_Veniot: [image] Scott_Sauyet: I think this implementation would be a little brittle I don’t see it that way. Perhaps not. But I use the Tag Tiddlers a fair bit. I’d be afraid of limiting myself to only including fields in the Tag Tiddler that serve as record column na…

[image] etardiff: Sorry, just jumping in to add that you may also be interested in the optional :include/:exclude suffixes available to the fields operator . Thank you. I think I had seen that before and forgotten. This was one place I knew was going to need some refactoring. [image] eta…

All other details about the table, I’d keep in the text field for the “table”. As JSON data (I.e. maintained with edit field using “index” instead of field. So definition details about the table and the columns, the columns being the fields. The values in those fields being default values. Then …

Hmm, an interesting approach too. I’m going to have to think through this a bit. Thanks for your insight!

I have a new release out, 0.2.1. It has two main changes: With help from @saqimtiaz and @springer , I was able to add virtual tiddlers for countries. Now various other tiddlers link to missing tiddlers, which are handled by a simple template, and list the suppliers and customers addressed in th…

Hello Scott, Great work! Another suggestion for easier understanding: maybe use the same variable name in the WikiText version and the SQL version, Add inline html comment Some example below: For instance (from SQL Playground — five tables - do as you will ) : SQL SELECT CompanyName, ProductNa…

Hi Scott, Great content – Well worth experimenting with it and examine the underlaying code and templates. I think it can help users, which know SQL code to easier understand the TW filter-syntax, since they have a reference they know already.

[image] Eskha: Another suggestion for easier understanding: maybe use the same variable name in the WikiText version and the SQL version, I was looking at the very same example for the same reason, and definitely want to improve it, but have been vacillating on using the SQL names or their …

TiddlyWiki can export CSV files. There are software tools available for querying CSV files using SQL. This might be common knowledge. I’m just exhaustively listing possible solutions to the problem.

Talk TW

Announcing: TiddlyWiki for SQL users

showcase

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled