Tags, and Export (cave canem or whatever you might be in awe of)
Started by 22111
on 7/24/2022
22111
7/24/2022 1:30 pm
Today, I seriously tried to publish the following bona fide post in https://sqlite.org/forum/forum , but to no avail, some Pol-Pot-admirer obviously being the censor there, on Sunday(s) (text byte-by-byte), and obviously, in our current "PIM" / "outliner" situation, non-Apple, for the most part, you will have greatly to gain from my post, censored over there (and not, it was not by "anonymous, but by "22111ok", just "22111" being judged as "not long enough" by their software):
By anonymous on 2022-07-24 11:18:12 [source]
Awaiting Moderator Approval
SQLite being THE STANDARD sql flavor for "desktop" (i.e. non-"cloud") software for individuals and tiny work-groups, and for "mobile apps", many "outlining", "personal information managers (PIM)" or whatever you call them, rely on this wonderful albeit "non-corporate" sql tool, including its full text search (FTS) functionality.
Then, this FTS - as does SQLite - tries to be as effective and efficient as it gets, and thus, FTS discards most "regular", "special" signs, and thus, searches for, like:
#abc, .abc, +abc, 'abc, -abc (of course, and that applies to most ones of my other examples in this list!), _abc, ~abc, =abc, :abc, ;abc, &abc;, «c, $abc, ?abc, !abc, |abc, abc will just list all occurrences of "abc", whilst ¬abc even doesn't give any search result (in Ultra Recall at least, and in there, the search for *abc just returns results in the form of "something-abc").
On the other hand, you seem to have "missed" (?), in your "special char" exclusions, "treatin'em as spaces" effort, and among possible other chars, easily being available on "regular" keyboards,
°abc
§abc
¦abc
¢abc
so that simple (and automatically SQLite-indexed!) FullTextSearches for $something, ¦something, ¦§something, and especially °something will provide immediate (!: since indexed) search / "filter" results for possible user-specific "TAG"* searches / "filter" commands, in SQLite-backed "outliners" / "personal information managers" / other tools relying on SQLite's brilliant FTS functionality.
Let's be clear about these "exceptions to your rule": while some "
By anonymous on 2022-07-24 11:18:12 [source]
Awaiting Moderator Approval
SQLite being THE STANDARD sql flavor for "desktop" (i.e. non-"cloud") software for individuals and tiny work-groups, and for "mobile apps", many "outlining", "personal information managers (PIM)" or whatever you call them, rely on this wonderful albeit "non-corporate" sql tool, including its full text search (FTS) functionality.
Then, this FTS - as does SQLite - tries to be as effective and efficient as it gets, and thus, FTS discards most "regular", "special" signs, and thus, searches for, like:
#abc, .abc, +abc, 'abc, -abc (of course, and that applies to most ones of my other examples in this list!), _abc, ~abc, =abc, :abc, ;abc, &abc;, «c, $abc, ?abc, !abc, |abc, abc will just list all occurrences of "abc", whilst ¬abc even doesn't give any search result (in Ultra Recall at least, and in there, the search for *abc just returns results in the form of "something-abc").
On the other hand, you seem to have "missed" (?), in your "special char" exclusions, "treatin'em as spaces" effort, and among possible other chars, easily being available on "regular" keyboards,
°abc
§abc
¦abc
¢abc
so that simple (and automatically SQLite-indexed!) FullTextSearches for $something, ¦something, ¦§something, and especially °something will provide immediate (!: since indexed) search / "filter" results for possible user-specific "TAG"* searches / "filter" commands, in SQLite-backed "outliners" / "personal information managers" / other tools relying on SQLite's brilliant FTS functionality.
Let's be clear about these "exceptions to your rule": while some "
22111
7/24/2022 1:36 pm
(The title of that post, censored over there - they published third-party posts having been "submitted" in-between -, being:
To the dear and honorable developers of SQLite
And no, I haven't discarded a single char in-between: Thus, never try to post anything constructive to crap sites such as sqlite.org forum on Sundays...)
To the dear and honorable developers of SQLite
And no, I haven't discarded a single char in-between: Thus, never try to post anything constructive to crap sites such as sqlite.org forum on Sundays...)