this post was submitted on 27 Feb 2025
490 points (96.4% liked)

linuxmemes

24872 readers
75 users here now

Hint: :q!

Sister communities:

Community rules (click to expand)

1. Follow the site-wide rules

2. Be civil
  • Understand the difference between a joke and an insult.
  • Do not harrass or attack users for any reason. This includes using blanket terms, like "every user of thing".
  • Don't get baited into back-and-forth insults. We are not animals.
  • Leave remarks of "peasantry" to the PCMR community. If you dislike an OS/service/application, attack the thing you dislike, not the individuals who use it. Some people may not have a choice.
  • Bigotry will not be tolerated.
    • 3. Post Linux-related content
  • Including Unix and BSD.
  • Non-Linux content is acceptable as long as it makes a reference to Linux. For example, the poorly made mockery of sudo in Windows.
  • No porn, no politics, no trolling or ragebaiting.
    • 4. No recent reposts
  • Everybody uses Arch btw, can't quit Vim, <loves/tolerates/hates> systemd, and wants to interject for a moment. You can stop now.
    • 5. πŸ‡¬πŸ‡§ Language/язык/Sprache
  • This is primarily an English-speaking community. πŸ‡¬πŸ‡§πŸ‡¦πŸ‡ΊπŸ‡ΊπŸ‡Έ
  • Comments written in other languages are allowed.
  • The substance of a post should be comprehensible for people who only speak English.
  • Titles and post bodies written in other languages will be allowed, but only as long as the above rule is observed.
    • 6. (NEW!) Regarding public figuresWe all have our opinions, and certain public figures can be divisive. Keep in mind that this is a community for memes and light-hearted fun, not for airing grievances or leveling accusations.
  • Keep discussions polite and free of disparagement.
  • We are never in possession of all of the facts. Defamatory comments will not be tolerated.
  • Discussions that get too heated will be locked and offending comments removed.
    •  

    Please report posts and comments that break these rules!

    Important: never execute code or follow advice that you don't understand or can't verify, especially here. The word of the day is credibility. This is a meme community -- even the most helpful comments might just be shitposts that can damage your system. Be aware, be smart, don't remove France.

    founded 2 years ago
    MODERATORS
    poopsmith@lemmy.world
    zephyr@lemmy.world
    rtxn@lemmy.world
    490
    VI is love, VI is life (jlai.lu)
    submitted 2 months ago by hylobates@jlai.lu to c/linuxmemes@lemmy.world
    141 comments fedilink hide all child comments
     
    you are viewing a single comment's thread
    view the rest of the comments
    [–] Earflap@reddthat.com 23 points 2 months ago (1 children)

    The last one should be

    SQL queries? Believe it or not vi

    Yes, this is my preferred SQL client!

    [–] hylobates@jlai.lu 6 points 2 months ago (1 children)

    Ah, nice one! Didn't realize it could even be done.

    [–] Earflap@reddthat.com 5 points 2 months ago

    It isn't as dumb as it sounds, honestly! I used to use DBeaver and it is a fantastic project, but I really wanted Vim keybinds to construct my queries as they can sometimes be quite large. There used to be a plugin that added the functionality but it stopped working on my machine. This Vim plugin is essentially a wrapper for the CLI SQL client (psql in my case), so using it actually kind of makes sense, I think.

    The biggest issue I faced was exporting the results, but I just created a function in my ~/.vimrc that copies all the text of the results to a new tab and formats it however I want. CSV, HTML, JSON, XML, Markdown, whatever I need is all there and predefined. All I have to do is call :ExportToMarkdown and off I go.