Post AYnFuZMUSBhfertnSS by roland@devdilettante.com
(DIR) More posts by roland@devdilettante.com
(DIR) Post #AYnFuZMUSBhfertnSS by roland@devdilettante.com
2023-08-16T05:32:11Z
0 likes, 1 repeats
I'm very proud of the datasette lite powered "search engine" :-) i made to search Thunderbird Support questions from TB115 release day July 11 to August 15, 2023. If you know SQLite you can do some fun things like search for all questions that I've replied to that are tagged `tb115` But that's too advanced :-) Here's a simple one: Search for all of `wsmwk`'s answers: https://lite.datasette.io/?csv=https://raw.githubusercontent.com/rtanglao/github-action-thunderbird-aaq/main/CSV_BY_TIME_PERIOD_USUALLY_BY_MONTH/thunderbird-desktop-questions-2023-07-11-2023-08-15.csv&csv=https://raw.githubusercontent.com/rtanglao/github-action-thunderbird-aaq/main/CSV_BY_TIME_PERIOD_USUALLY_BY_MONTH/thunderbird-desktop-answers-2023-07-11-2023-08-15.csv#/data?sql=select+rowid%2C+id%2C+question_id%2C+created%2C+updated%2C+content%2C+creator%2C+is_spam%2C+num_helpful%2C+num_unhelpful%2C+link+from+%5Bthunderbird-desktop-answers-2023-07-11-2023-08-15%5D+where+%22creator%22+%3D+%3Ap0+order+by+rowid+limit+101&p0=wsmwkBIG Thanks @simon for the fabulous datasette!
(DIR) Post #AYnFuqHRYCle88fVS4 by roland@devdilettante.com
2023-08-16T05:48:35Z
0 likes, 0 repeats
it appears elk.zone is transmogrifying :-) the ampersands to & so the above url won't work if you are using elk.zone. Just change & to & in the URL and it will work trust me :-)