DEV Community

I turned the psql commands I keep forgetting into buttons (opens in new tab)

Discussed on DEV

You know the command exists. You've run it a dozen times. But every single time you need to see what's actually running on your database, you end up typing some variant of: SELECT pid, state, query, wait_event_type FROM pg_stat_activity WHERE state != 'idle' AND pid != pg_backend_pid(); …and then googling pg_stat_activity columns halfway through because you forgot whether it's wait_event or wait_event_type. I got tired of that. So I built cli2ui — a small web UI that turns the database CLI co...

Read the original article
Sign in to keep reading the full article.

Keyboard Shortcuts

Navigation

Next / previous post
j/k
Open post
oorEnter
Preview post
v

Post Actions

Love post
a
Like post
l
Dislike post
d
Undo reaction
u
Save / unsave
s

Recommendations

Add interest / feed
Enter
Not interested
x

Go to

Home
gh
Interests
gi
Feeds
gf
Likes
gl
History
gy
Changelog
gc
Settings
gs
Discover
gb
Search
/

General

Show this help
?
Submit feedback
!
Close modal / unfocus
Esc

Press ? anytime to show this help