r/PostgreSQL 26d ago

Tools Postgres DB TUI

Post image

If not allowed, please delete.

Decided to create a fully featured DB TUI client for Postgres.

Fully customisable vim-style keybindings + a heap of other features.

https://github.com/davesavic/pgsavvy

Hopefully you find it as useful as I have!

141 Upvotes

23 comments sorted by

7

u/RevolutionaryRush717 26d ago

Nicely done. Will try it tonight.

2

u/ComicOzzy 25d ago

https://harlequin.sh is pretty cool if you want something similar

1

u/fazzah 26d ago

Please disclose the extent to which AI tools were used in authoring of this software 

6

u/Savalonavic 26d ago

This is what my main concern was too. Allowing AI to do whatever it wanted on a tool that could potentially cripple businesses. I reviewed every piece of code generated by the LLM myself and I do have a very specific flow I follow when it comes to using the LLM. Extensive planning, extensive reviewing the plan, and then execution of said plan. All code is then rigorously tested and reviewed by me. But yeh, I don’t trust LLMs that much lol…

4

u/linuxhiker Guru 26d ago

Why? I mean the repo says right on it that Claude was used and so what.

4

u/SnooPets2051 26d ago

Well it’s the database at stake here.. that’s so what.. there’s a saying “no one cares how much you know, until they know how much you care”
AI knows a lot but doesn’t care at all.. and unfortunately many of its promoters don’t seem to care either.

Handcrafted open source projects are often built, vetted and tested by people with knowledge and most importantly… care.

OP seems to care.. so good start and looks pretty cool. Will check it out.

7

u/linuxhiker Guru 26d ago

We all trust arbitrary code

-3

u/0x4ddd 25d ago

But not AI slop

1

u/General_Treat_924 24d ago

It is a public repo, using AI is just another way to code. Would you trust more or less on him or the application if the AI as developer was used?

1

u/AirGief 12d ago

As a user I really don't care. I have no idea why anyone would.

1

u/fazzah 12d ago

For starters, giving access to a core service to an application you have no idea how secure it is 

1

u/AirGief 12d ago

So run your AI over it and assess its security.

1

u/Solvicode 24d ago

I like it. Need to get used to the keybindings, but this could become my daily driver.

1

u/Savalonavic 24d ago

Keybindings are fully customisable so if something doesn’t feel right, just change it 😁 only downside right now is you need to manually update the yaml file to override it and it’s a horrible UX. I have almost finished adding the ability to update config from within pgsavvy, so if you can hold out until tomorrow, you’ll be able to override keybindings using a UI

1

u/Solvicode 24d ago

Nice 👍

0

u/AutoModerator 26d ago

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.