PL/php is a procedural-language handler that lets you write database functions in PHP, stored and executed inside PostgreSQL. You get the convenience of PHP's standard library with the full power of a native PostgreSQL function — plain functions, set-returning functions, triggers, event triggers, and procedures with transaction control.
The Open Source Approach: Building Production-Ready AI Apps with Postgres
Multigres: One stop PostgreSQL Management and Scaling
Community, I have been working on a dashboard for my Victron + JBD setup and have reached a point where I would like to share. You can find it here:
https://github.com/ChronicallyJD/solar_dashboard
I would love some feedback. I wanted something dumb simple and it grew from there. It supports:
Victron BMV Victron Inverters Victron MPPT
JBD based batteries.
Runs locally, as a web server, as a TUI and has an API and MCP Server. It can also use SQLLite to store historical data.
It is free and BSD licensed. Enjoy!
Community, I and my bro Claude having been working on an Open Source project to monitor our solar infrastructure. I know a lot of us run Victron and JBD based stuff. If you do, I am looking for your feedback (also considering adding Ecoflow). You can find the project here:
https://github.com/ChronicallyJD/solar_dashboard/
This is what it currently looks like (web and console):
I know there are a lot of options out there for a Solar Dashboard but I wanted something dumb simple that just gave me the information I was looking for with minimal setup. So, over the last 24 hours... I learned how Claude works and built a dashboard. It supports JBD based BMS batteries and Victron.
It is free and Open Source (BSD License).
Running stateful applications can provide many of the same advantages as stateless applications. In this talk, Stephen will share some thoughts on managing stateful applications as part of a CD Pipeline so that applications - and the application's data - can be versioned and deployed safely and repeatedly. This talk will discuss managing structural changes to a PostgreSQL database as part of a CD process. The talk will dive into automation approaches and tooling for managing data migrations between environments and running database schema migrations within a CI/CD pipeline. The talk will feature real-world examples where we discuss specific schema migrations, their possible performance impacts and downtime implications. We will demonstrate how a complex migration can be done with 0 downtime. With AI and CI/CD we can provide something better than before: A more testable, repeatable, and open way to deploy stateful applications. This talk features a practical demo of how CD tooling can empower users to automate data schema migrations within Kubernetes.
I am sure there is more but...
I was considering Calhoun and Forstag.
I can't do that.
That's dumb
Group Swim is a PostgresWorld offering that offers free round table expert advice on PostgreSQL. The May 14th meeting is on Schema Design:
Looking for practical database support without the cost? Group Swim: PostgreSQL Edition – Schema Design is your space to discuss database design decisions with Postgres experts and peers. We’ll cover best practices, common trade-offs, and patterns that help schemas scale, evolve, and remain maintainable.
You may RSVP for free here.
Over 800 people giving to the community on over 80 projects. This does not include the branches of Clinton and Bitteroot.
What an amazing show of community.
https://volunteer.serve406.org/agency/detail/?agency\_id=179584
