digoal/blog

pgbot is a read-only PostgreSQL observability and health-diagnosis tool for AI agents, applications, and operators. A static binary connects to PostgreSQL, reads the database's own statistics views, and produces deterministic, findings-first health reports, including a health score, critical/warning/note findings, verified healthy subsystems, and change information from local baselines. It provides focused commands for indexes, queries, tables, and vacuum, along with versioned JSON output for agents and scripts and an MCP mode. Its optional ask and explain commands add an AI interpretation of the same findings; inspection and database queries otherwise require no model key or external service. The project is in beta and uses a read-only pg_monitor role with session-level read-only, statement, and lock timeouts as additional safeguards.

Tiger Data is a PostgreSQL data platform for combining transactional and analytical workloads in one database. It uses hybrid row and columnar storage, compression, and continuous aggregates, and is positioned for time-series workloads at scale. Tiger Cloud provides a fully managed PostgreSQL service with separated reads and writes through replica sets, plus tiered SSD and S3 storage.

Postgres is an open-source relational database created by Mike Stonebraker and subsequently maintained and enhanced by a volunteer community and companies. It is presented as a widely used database whose open ownership contributed to its adoption and continued development.

A DataExpert-io GitHub repository that curates learning resources for data engineering. It organizes a 2024 career roadmap, free beginner and intermediate boot-camp materials, required software, hands-on projects, interview guidance, books, communities, newsletters, company and tool directories, engineering blogs, whitepapers, and data-engineering creator accounts. Its categorized references cover areas including orchestration, data lakes and clouds, warehouses, data quality, analytics, data integration, semantic layers, modern OLAP, LLM application libraries, real-time data, and data lineage.

DocsAlot is a documentation platform for publishing AI-readable help centers and developer documentation. The service provides hosted MCP and llms.txt support and tools to keep documentation current.