Very much this. In fact, I had made a note about earning "professor points", in my (giant) blog post [0] describing my org-mode use...

   6. Professor Points: I also get intermediate tex output for free,
      which I don't need, but may please you if you are a professor
      (or said professor's hopelessly sleep derived grad students).

---

[0] Discussed here recently:

  Why and How I use “Org Mode” for my writing and more (2022) (evalapply.org)
  217 points by sebg | 6 months ago | 64 comments

https://news.ycombinator.com/item?id=43157672

Kudos to you, my biggest regret nowadays was not learning how to use orgmode (and org-roam) in college. As long as you set up a proper environment and have an org-publish config you barely need to bother with verbose LaTeX documents.

https://www.orgroam.com/

I had an amusing incident that was related, quite some years back as a CS undergrad. One prof had quite poor eyesight, so had a no-pencil rule for assignments. Typed was OK, neat pen was fine also. (My writing has always been atrocious, typed it is.) As it happened, I used LaTeX (and I knew she did also.)

She also had a rule about promptness of assignment delivery, meaning the start of class when she arrived. Fair enough!

On this one assignment, I had done all but the last question at home, and printed it off, with the hope that I could finish it at the lab and send it to a laser printer in another building. At the time, labs used shared, dot-matrix printers that were usually jammed. I got the last question done, sent it to the printer, then checked the queue. Apparently someone was printing a book, not going to get done before class.

I emailed her my .tex file, with the explanation that I'd hand in my incomplete printout in class, but would appreciate if she could mark the last section so I knew how I did. This was sent well before class, as the timestamp would show. The prof ended up printing, marking, and returning this version, and I received full marks!

I second that and would be interested in the sqlite-mode version of the tutorial.

You may be interested in PGmacs, a viewing/editing interface for PostgreSQL.

https://github.com/emarsden/pgmacs

(self-plug)

I also use: https://github.com/kostafey/ejc-sql for stuff not natively supported by sql-mode in emacs FWIW

    M-x sql-sqlite
    Then C-c C-c on paragraph you want to send/execute
    M-x sql-send- for the other commands
    The mode is called sql-interactive-mode

That's it.

I think even better to encrypt the password in ~/.authinfo.gpg, e.g.,

     machine my_db login my_usr password bla-bla-123

And then in the source block header, you can inject it into a variable

    :var pass=(auth-source-pick-first-password :host "my_db")

That's a built-in elisp function. Yes, you can call arbitrary functions to assign vars for org-mode source blocks. You can even assign shell command output, I often do things like:

    :var token=(shell-command-to-string "echo $MY_TOKEN")

What's crazy about this shit is that you can even pipe the content of the file back into itself:

     #+begin_src sh :pretty :var token=(shell-command-to-string (format "grep my_token %s" buffer-file-name))
        echo $token
     #+end_src
     

That's an absurd bananas degree of ingenious engineering that makes you question the sanity of programmers who deliberately abandon Emacs, even after experiencing such power.

>Especially now that you can get Claude to just explain the basics of Emacs configuration to you, which wasn't the case when I started

although also worth pointing out that Emacs often leads with the adjective self-documenting for a reason. Emacs has fantastic facilities built in to get information on virtually anything. Tutorials with C-h t, manuals with C-h r, apropos and describe- to search for any object etc. And pretty much any major extension like org has great documentation. Which btw I think is well worth reading or at least skimming to get an idea on how much you can do with it.

Orgmode has been on the back of my mind forever. Ive been working on implementing a system recently. My hesitation with orgmode is that I'd like to share calendar/todo list with my non technically minded spouse and I like Vim. Any suggestions?

I have been interested in trying emacs for a long time (I recently found an old emacs config file of mine from 2003) but I haven't actually used it until the last few months when I gave Spacemacs another shot. Coming from vim, and having some pretty great defaults out of the box, I wouldn't suggest anyone try anything else at this point.

That said, I'm still trying to wrap my head around how org-mode can work with my existing Obsidian vault. So far it's working pretty well, but I still feel like I'm missing some things to make it really all click together.