Bozhidar Batsov, creator of Emacs Prelude and CIDER, writes tips, release notes, and tutorials on Emacs.
HN commenters recommend it for learning GNU Emacs and its techniques, and link its Emacs 29.1 release writeup and WSL2 guide.
In some of my programming environments, such as Emacs, I choose to prettify keywords to unicode characters such as 'function' (λ), 'lambda' (λ), 'forall' (∀) and others. It takes a bit getting used to, but it brings the focus where it needs to be: the code and data flow. The brain quickly adopts new pattern-matchable structures, so why bother with long keywords?
[1] http://emacsredux.com/blog/2014/08/25/a-peek-at-emacs-24-dot-4-prettify-symbols-mode/
I love these symbols because once you learn them you can instantly spot where all your loops are, it really make things compact, and reveals the structure of your code far more efficiently.
A solution to the problem if incomprehensibility is to use a plugin to replace the words. I use emacs prettify symbols:
https://emacsredux.com/blog/2014/08/25/a-peek-at-emacs-24-dot-4-prettify-symbols-mode/
I am not quite sure how this particular feature will look but Emacs can be already used as a SQL client. Here is a short demo https://www.youtube.com/watch?v=D97vDu_BhwA
Here is an introduction blog[1] and the related mode[2]
[1] https://emacsredux.com/blog/2013/06/13/using-emacs-as-a-database-client
[2] https://github.com/emacs-mirror/emacs/blob/master/lisp/progmodes/sql.el
I have found EmacsRedux informative for learning GNUemacs. The key for me was understanding that Emacs is command driven and that shortcuts are merely shortcuts to commands - i.e. M-x <command> invokes the <command> of which emacs has hundreds (+ lisp expressions). Unlike shortcuts, commands can be accessed with auto-complete.
http://emacsredux.com/
It is possible to use Emacs effectively with just M-, C- keybindings (20+ years experience). Super (windows key) is for desktop manipulation, so no loss on iPad. No idea what is hyper--you likely need to have 40+ years of experience to start with the space cadet keyboard https://emacsredux.com/blog/2022/06/01/the-space-cadet-keyboard/
Came here to say this. I'm starting Emacs only after a reboot, who cares if it takes 3s or 30s to launch (mine around 5 or so.)
Use emacsclient if you want to use it as $EDITOR.
https://emacsredux.com/blog/2014/12/23/uptime/