SQLite Forum

Timeline
Login

6 forum posts by user hatfinch

2020-04-03
14:35 Reply: Natural sort order (artifact: 51f6f9dbe3 user: hatfinch)

Wouldn't it work anyway, because you'd only be comparing numbers of the same fixed length? (xxxxx or xxxxx-yyyy)

2020-04-01
15:59 Reply: Anonymous posting should be disabled on SQLite Forum (artifact: 3c2f2aa2b0 user: hatfinch)

Let's make creating pseudonyms easier. Then someone who wants anonymity in the sense you describe can simply create a new pseudonym each time they post ;)

10:34 Reply: Anonymous posting should be disabled on SQLite Forum (artifact: 7baeba8c01 user: hatfinch)

i'm admittedly utterly flabbergasted by the anti-anonymous sentiment

The point has been made several times that pro-pseudonymous does not mean anti-anonymous.

10:06 Reply: Anonymous posting should be disabled on SQLite Forum (artifact: 161c314993 user: hatfinch)

I agree with everything ddevienne says here.

2020-03-27
16:45 Reply: Natural sort order (artifact: a02ab91c95 user: hatfinch)

Both of these seem like a good idea to me.

On the naming of "dictionary sort order", though, I couldn't find any definition by that name in a brief online search, and the Wikipedia entry for lexicographical ordering lists it as a synonym, which might be confusing.

2020-03-19
11:48 Reply: ESCAPE '%' (artifact: 5d7a3813f0 user: hatfinch)

I’m just trying to construct a prefix query. It’s useful to be able to use the percent character as the escape character because then I can just replace % with %% and _ with %_ in the string I’m substituting, and simply add a % at the end.

I can use a different character, but then I also have to escape that character as well as the percent and underscore.

No big deal, just struck me as odd because the latter paragraph is addressing how to escape the characters denoted as special by the former paragraph, but doesn’t mention any constraints on the escape character. I would read that as allowing what I’m trying to do, but as ddevienne says, it’s underspecified.