用 Go 写一个轻量的 PostgreSQL 交互式命令行工具，带语法高亮和自动补全
github.com/Balaji01-4D/pgxcl…
pgxcli 是 Go 写的 PostgreSQL 交互命令行工具，有语法高亮、关键字补全、命令历史和反斜杠命令支持。单二进制分发，启动快，TOML 配置。功能目前不如 pgcli 全，后续计划加流式结果、浏览器视图和多格式导出。
1
24
2,861
Day 3 of learning Data Engineering.
Today I built my first proper data pipeline.
It pulls data from the internet, preprocesses it, and loads it into PostgreSQL.
Here’s how it went 👇
I started by exploring the dataset in Jupyter Notebook using:
uv run jupyter notebook
That runs inside my project’s virtual environment, not my system Python.
In the notebook, I
• Installed SQLAlchemy
• Pulled data from the internet
• Cleaned and transformed it
• Loaded it into PostgreSQL in chunks
Seeing the data land in Postgres felt different.
After that, I converted the notebook into a proper Python script.
Then I dockerized the ingestion script.
And that’s where things got interesting.
The ingestion container couldn’t talk to the Postgres container.
Network errors everywhere and
that’s when Docker networking finally clicked for me.
Containers don’t automatically see each other.
They need to be on the same Docker network. I created docker network to solve the problem.
Instead of running everything manually, I used Docker Compose to define:
• PostgreSQL
• pgAdmin
• Shared network
• Persistent volumes
In one file.
One command.
Everything runs together.
After that, the ingestion container connected perfectly.
Finally, I checked the database using:
• pgcli (CLI access)
• pgAdmin (browser UI)
And the table was there.
End-to-end pipeline. Containerized. Networked. Working.
#DataEngineering #BuildInPublic #Docker #PostgreSQL #LearningInPublic
Day 2 of learning Data Engineering.
Today I learnt about virtual environment and finally understood what a virtual environment actually is.
Your system/host machine has a global Python.
So if you install packages there, every project you are building shares them and that’s dangerous.
Let's say One project needs pandas 2.0 and another needs pandas 1.5. Virtual environment enables you to run different versions of that pandas without conflict.
A virtual environment creates a small isolated Python world just for that project, its own packages, its own versions, its own everything.
When I ran commands like :
uv run python -v
uv add pandas
It wasn’t using my system Python.
It was using the project’s isolated environment.
That separation is powerful.
Still wrapping my head around Docker networking…
But today, virtual environments clicked.
#DataEngineering #Python #BuildInPublic
3
6
257
Feb 4
I got tired of copy/pasting between PGCLI and a chat session—and wanted to try vibing a TUI (it's crude!) so here's my talk-to-your-database spike...
3
4
349
Another open source bug fix!
You can now use the fantastic pgcli natively with the latest rails without having to enter your password every time!
github.com/mattbrictson/pgcl…
3
550
Yes pgcli has been nicee
29 Dec 2025
pgcli and mycli are wonderful upgrades from the default psql / mysql database clients.
Auto-completion, syntax highlighting, and just generally much better usability.
If you're connecting to your DB from the terminal, get these asap.
2
124
29 Dec 2025
For the next release of Data Engineering Zoomcamp, I'm updating the Docker module with new, hands-on content.
I've presented this updated material at a recent live workshop.
What you can learn from it:
🔸 How Docker fits into real-world data engineering workflows
🔸 Running PostgreSQL in a container and connecting from local tools
🔸 Querying data with pgcli and Jupyter
🔸 Loading and exploring the NYC Taxi dataset
🔸 Using the latest pgAdmin UI for database management
🔸 Converting notebooks into scripts and Dockerizing them
🔸 Building multi-container setups with Docker Compose
🔸 Understanding networking, ports, and volumes
If you missed the live session, watch the recording here: youtube.com/live/lP8xXebHmuE…
ALT Slide showing "Linux Ubuntu 24.08" with a gray box labeled "Ubuntu 20.04" containing command "rm -rf /", presenter visible in small webcam.
1
5
16
1,335
29 Dec 2025
pgcli and mycli are wonderful upgrades from the default psql / mysql database clients.
Auto-completion, syntax highlighting, and just generally much better usability.
If you're connecting to your DB from the terminal, get these asap.
26
74
847
57,663
5 Jul 2025
بعيدًا عن التلوث بتاع الـ AI اللي منتشر في كل حتة وفي كل مكان، لقيت أداة جميلة جدًا بديلة لـ psql اسمها pgcli وبتوفر auto-completion وsyntax highlighting. أنا بحب DataGrip جدًا لكن هو تقيل شوية وبقيت بستخدمه في الحاجات المعقدة اللي بتحتاج تكتب query كبيرة بس.
1
2
95
11 Apr 2025
Dear pgcli devs,
You've done awesome work! Love it. Really, the tab completion is excellent.
Also can we please have a not so passive agressive mode
2
6
580
10 Apr 2025
How did I only learn about pgcli now?
Like `psql` but with smart auto-complete and nice formatting / colors.
10 Apr 2025
pgcli, although psql works too
1
6
1,470
9 Feb 2025
Does anybody use tools for writing psql? I found pgcli but I'm wondering if there is anything else? Do most just use an ORM?
github.com/dbcli/pgcli
2
41
3 Sep 2024
pgcli is the most common one which is a python tool which has some pretty rich autocompletion.
Curious do you have much customized in your psqlrc?
1
2
175