This is the Hugo static site that powers the official blog of pgAssistant, a PostgreSQL-first assistant designed to improve query performance using LLMs.
📍 Live site: https://beh74.github.io/pgassistant-blog/
This blog shares use cases, tutorials, and articles around:
pgAssistantand how to use it effectively- PostgreSQL optimization techniques
- LLM Models
- Hugo — Static site generator
- PaperMod — Clean, responsive Hugo theme
- GitHub Pages — Hosting
- GitHub Actions — CI/CD for deployment
Make sure you have Docker installed.
git clone https://github.com/beh74/pgassistant-blog.git
cd pgassistant-blog
docker compose upFeel free to open an issue or submit a pull request if you’d like to suggest changes or improvements. Each blog post provides a “Suggest Changes” link that takes you directly to the GitHub source.
The site is automatically deployed to GitHub Pages using a GitHub Actions workflow. Any push to the main branch triggers a rebuild and redeploy.