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:
| 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.