I also like https://learnxinyminutes.com for when I need to understand some code in an unfamiliar language. That site also accepts contributions from anyone via pull request on GitHub.
Learn X in Y Minutes is also my go to site for dealing with code in an unfamiliar language. It's managed to get me through learning Ruby and Coffeescript on the job, as well as learning PHP for university.
It's a pity that nobody has done one for SQL yet, I would've thought it would be in high demand.
It's good to quickly grasp basic syntax so you can read code in unfamiliar language. However, I don't think that it's a good resource to properly learn language.
You will often miss learning the philosophy of the language (the $language_name way of doing it), the different way of thinking about the problems that the language provides and similar details, which are often not necessary to read a snippet of code, but you want to understand it in order to properly learn the language and make the most of it.
SQL is a good example of it. It might be trivial to explain the syntax of most common SQL queries, but thinking in relations and tables is not natural to most people so there's not much you can do with basic syntax.
If you like this sort of thing (and have a Mac), you'll probably enjoy Dash. It's particularly great to load up on anything you feel you might need before heading towards flaky international internet access for a while.
https://zealdocs.org/ was the one I tried, but the main problem is that it didn't support zip/tar files and Windows (explorer.exe mainly) gets very slow when there are >10 000 files in one path.
Pretty neat, but the first thing I looked for was how to open a file in Python and it wasn't there. I'm guessing it's because the "File" column only displays methods on the file object, and open is a built-in function. I can see how this might be useful when context-switching between different programming languages.
Also the "Array" section refers to array.array objetcs, but, as there's no sepparate section for "Lists", they can be confused. Worst thing about this is that .byteswap would seem to be a list method (I know it isn't, but someone who's just beggining may be confused as to way the list doesn't have a bytewap() method!)
Back in the day when I actually had a desk and walls on which to pin things, I printed out and stuck cheat sheets from the 4 languages in effective use in my context: SAS, R, python and C.
The lag/effort was/is far less than google if the info is right there, and I personally found I kept having brain farts where I'd temporarily forget what language the thought I was having was actually in, and could quickly touch base again by referencing the cheat sheet without bringing up the (often distracting) web browser...
Working in a fully offline environment, I have git repository with only documentation for everything I may need. In this situation, a cheat sheet or a searchable doc can save my day.
I think both are useful depending on the situation. Maybe a better question is why I'd want a potentially outdated list of cheat sheets instead google. I bookmarked it anyway.
Would be sweet if you could customize the options in your printed sheets. Example: I know how to preform basic git operations, but sometimes I need a reminder of how to push a local branch to a remote with a different branch name.
A lot of the sheets are incomplete. The guitar sheet could use a basic chords sheet, that would be handy when you need to take a break from the computer.