Adam Kiss Posted December 29, 2022 Share Posted December 29, 2022 (edited) I _depended_ on the old Python 2 workflow for searching the Unicode database, and the only workflow I found was too slow for my taste, and not working properly, so I wrote my own. The most interesting part (other than it does exactly what I want - search the database and remember my most used characters) is that it's fully written in SQLite - it's a fts5 index of whatever Unicode database I found (nearly 33k records), and the alfred JSON is ALSO generated by SQLite. SQLite is amazing. The workflow is here: https://github.com/adamkiss/alfred-utf Edited December 29, 2022 by Adam Kiss I needed to add an empty line above the picture Link to comment Share on other sites More sharing options...
Adam Kiss Posted December 29, 2022 Author Share Posted December 29, 2022 Oh right, the "full window, no background and shadow" screenshot is here added in this post. Link to comment Share on other sites More sharing options...
vitor Posted December 29, 2022 Share Posted December 29, 2022 Welcome @Adam Kiss, It is supposed to have a shadow. The pinned post explains how to take a proper screenshot. Adam Kiss 1 Link to comment Share on other sites More sharing options...
Adam Kiss Posted December 29, 2022 Author Share Posted December 29, 2022 (edited) @vitor Thank you for the patience vitor. I swear I read the post, but read the bolded part as "no shadow and no background" That's what happens after 8 hours of programming workflows 🤗 Edited December 29, 2022 by Adam Kiss Replaced with PNG Link to comment Share on other sites More sharing options...
Adam Kiss Posted December 29, 2022 Author Share Posted December 29, 2022 arrow screenshot Link to comment Share on other sites More sharing options...
Adam Kiss Posted December 29, 2022 Author Share Posted December 29, 2022 and my favorite, in light mode Link to comment Share on other sites More sharing options...
vitor Posted December 29, 2022 Share Posted December 29, 2022 Tried it out but bumped into errors. They’ve already been reported by @suliveevil. Additionally, the titles in the Script Filters are confusing. Most people who’ll use this likely don’t know (or care) what sqlite is, so having the utf keyword be labeled Search sqlite3 is confusing. Suggestion: Have the title be Search Unicode Characters and the subtitle Begin with a colon to make a SQLite3 query. On the second one, have the title be Show 10 Most Used Unicode Characters. Could also make it utf9, which is the number of Alfred results. Link to comment Share on other sites More sharing options...
Adam Kiss Posted December 29, 2022 Author Share Posted December 29, 2022 (edited) Hey @vitor - Again, thank you The errors should now be fixed - there was a couple of issues that slipped by me when testing (and writing in external files and then copy pasting to alfred boxes). I also improved (I think) the messaging, but missed your message and did it my way - and utf 10 is still utf10 - but that's a quick update and I like the "9 items = 9 results" thingy going on. Edit: totally switched the `utf10` to `utf9`, because it's great idea. I kept the labels as they were (mine improved version), because honestly, the "color SQlite query" was mostly done because I could, and it probably can be fun to play with it, but I don't think it will be really used. Edited December 29, 2022 by Adam Kiss Link to comment Share on other sites More sharing options...
vitor Posted December 29, 2022 Share Posted December 29, 2022 3 hours ago, Adam Kiss said: it probably can be fun to play with it, but I don't think it will be really used. Agreed on both counts! Workflow is now working great! Adding to the Gallery. Just noticed a typo: in the description it says “Searh” (missing the “c”). Adam Kiss 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now