Once again I find myself searching through a giant table on Wikipedia. And again I think: it would be so much better if I could just query it with SQL or something. Wish someone made a browser extension for that!..

Aaand now I did. Here is the source code: https://codeberg.org/aka_dude/tableq. And here you can get it for your Firefox. Except this uses PRQL because it is much better that SQL. Here is an example:

Source (Wikipedia)
File system Block journaling Metadata-only journaling Case-sensitive Case-preserving File Change Log XIP
APFS ? ? Optional Yes ? ?
NTFS No Yes (2000) Yes Yes Yes ?
ext4 Yes Yes Yes, optional Yes No Yes

The Q? button over upper-left corner activates the extension. Upon activation, column names are renamed to snake_case and a PRQL prompt appears. Try writing the following there and see what happens!

from t0
filter (file_change_log == 'Yes')

Note that the table still contains original HTML, e.g. the links are still there.

Some caveats:

  • The extension doesn’t do anything with column duplicates, so underlying DB (sqlite) will have a problem with that.

  • Since content is stored as HTML in the DB, operations over text will work with it, not rendered representation. This may lead to weird results when sorting or searching through rich text.

All caveats should (and maybe will) be taken care of, but current functionality is enough for me.