The latest articles on DEV Community by bertrand HARTWIG (@bertrand_hartwig_309d1958). https://dev.to/bertrand_hartwig_309d1958 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1915824%2Fb0620e35-b10d-46de-9781-576785aba401.jpg https://dev.to/bertrand_hartwig_309d1958 en bertrand HARTWIG Sat, 01 Feb 2025 13:09:19 +0000 https://dev.to/bertrand_hartwig_309d1958/pgassistant-v17-released-3309 https://dev.to/bertrand_hartwig_309d1958/pgassistant-v17-released-3309 <p>I'm excited to share that we just released <strong>pgAssistant</strong> v1.7.</p> <p>PGAssistant is an open-source tool designed to help <strong>developers</strong> gain deeper insights into their PostgreSQL databases and optimize performance efficiently.</p> <p>It analyzes database behavior, detects schema-related issues, and provides actionable recommendations to resolve them.</p> <p>One of the goals of PGAssistant is to help developers optimize their database and fix potential issues on their own before needing to seek assistance from a DBA.</p> <p>🚀 <strong>AI-Powered Optimization:</strong> PGAssistant leverages AI-driven language models like ChatGPT, Claude, and on-premise solutions such as Ollama to assist developers in refining complex queries and enhancing database efficiency.</p> <p>🔗 <strong>GitHub Repository:</strong> <a href="https://github.com/nexsol-technologies/pgassistant" rel="noopener noreferrer">PGAssistant</a></p> <p>🚀 <strong>Easy Deployment with Docker:</strong> PGAssistant is Docker-based, making it simple to run. Get started effortlessly using the provided <a href="https://github.com/nexsol-technologies/pgassistant/blob/main/docker-compose/docker-compose.yml" rel="noopener noreferrer">Docker Compose file</a>.</p> <p>I’d love to hear your feedback! If you find PGAssistant useful, feel free to contribute or suggest new features. Let’s make PostgreSQL database easy for dev Teams !</p> postgres postgressql productivity ai bertrand HARTWIG Mon, 12 Aug 2024 05:00:03 +0000 https://dev.to/bertrand_hartwig_309d1958/pgassistant-postgesql-tool-4-dev-16cp https://dev.to/bertrand_hartwig_309d1958/pgassistant-postgesql-tool-4-dev-16cp <p>I wrote this small tool because I noticed that our young developers were struggling to understand the behavior of their PostgreSQL database, and therefore had even more difficulty optimizing their databases. </p> <p>Gradually, developers started using it, and the tool helped the development teams become much more autonomous, and me much less solicited. </p> <p>Feel free to use it and give me your feedback. </p> <p>I try to enhance the application whenever time allows.</p> <p>You can find it there : <a href="https://github.com/nexsol-technologies/pgassistant" rel="noopener noreferrer">https://github.com/nexsol-technologies/pgassistant</a></p>