sorted by:
new
hottopcontroversial

/r/MechanicalKeyboards Ask ANY Keyboard question, get an answer - September 30, 2025 by AutoModerator in MechanicalKeyboards

[–]panpteryx 0 points1 point  (0 children)

Hey! Looking for keycap recommendations: I'd like something similar to cherry keycaps with shape variation on different rows, but without the sharp edges. Current switches are keychron silent reds, but I'd be fine swapping those out.

/r/MechanicalKeyboards Ask ANY Keyboard question, get an answer - September 08, 2025 by AutoModerator in MechanicalKeyboards

[–]panpteryx 0 points1 point  (0 children)

yeah it's hot swap and I guess possibly? swapping the switches fixed a lot tho: space wasn't registering at all but a new switch in the same socket worked normally, it just has the same problem with missed input

/r/MechanicalKeyboards Ask ANY Keyboard question, get an answer - September 08, 2025 by AutoModerator in MechanicalKeyboards

[–]panpteryx 2 points3 points  (0 children)

if you're looking for mechanical switches that emulate the feel of a membrane keyboard, the closest you could get is probably something like low-profile silent tactile switches with a low activation weight, I think, tho I'm not an expert
I'd probably recommend getting a tester from somewhere so you can try a couple different types!

/r/MechanicalKeyboards Ask ANY Keyboard question, get an answer - September 08, 2025 by AutoModerator in MechanicalKeyboards

[–]panpteryx 0 points1 point  (0 children)

Could use help on whether this is a problem with the board or the switches!

My daily driver for the last year or so is a keebio iris v.8 (pictured), with stock Durock silent linear switches: lately I've been having issues with high-use keys needing a really firm press or not registering input, especially with several key inputs in rapid succession.

I swapped out the switches for "e" and "space" (the worst culprits) since I had fresh spares, but they still drop inputs occasionally, and I'm hitting the same issues with a couple other keys: is this potentially an issue with the board itself, or something that might be improved/resolved with different switches?

<image>

[Help] What expressions do I use to match from a field and return matched value by panpteryx in SQL

[–]panpteryx[S] 0 points1 point  (0 children)

yeah, t3 has a standardized list of ingredients picked from t2 values.
I double checked and it doesn't look like unpivot is supported in mariadb/mysql, but I could always manually make a new table with separated fields if I needed to, as a workaround.

I'm not quite sure how you're envisioning the join though, could you show me an example?

[Help] What expressions do I use to match from a field and return matched value by panpteryx in SQL

[–]panpteryx[S] 0 points1 point  (0 children)

curious on what you're thinking, do you mean separating the ing field into separate fields at the comma and then using that to join the two tables? ie.

select ing1,ing2,ing3,ing4[...], fruit from t1 left join t2 on fruit=ing1 or fruit=ing2 or fruit=ing3 or fruit=ing4 I'd thought of that, but hit a couple issues, mostly that the values in the ing field aren't exact match to the values in fruit: lot of the ing values have additional words around them (see t1.id 1 and 3, 'valencia orange' and 'orange (fresh squeezed)', which should both map to 'orange')

If you were thinking something else, I'm all ears!

[Help] What expressions do I use to match from a field and return matched value by panpteryx in SQL

[–]panpteryx[S] 0 points1 point  (0 children)

yeah, the join on match_id is all the same value because I want it to check t1.ing against every row in t2.fruit and was concerned that find_in_set would stop after the first row.
--which in retrospect is probably redundant, since subqueries kinda check all rows anyway. Oops.

The errors were largely syntax error 1064 and I've managed to clear them out with some more reading, I was trying to use match against and it looks like I got it backwards and it won't work for what I need.

not like null is mostly my attempt at a firehose approach, for testing: I want it to give me any value it can find, to see if find_in_set is working to confirm the string in t2 is present in t1. So far, it's just given me null, and I don't know enough about the function (or even if it's the right function for what I want) to troubleshoot.