Skip to content

Add postgres support#441

Merged
cschleiden merged 7 commits intocschleiden:mainfrom
vr009:vr009/add-postgres-backend
Oct 31, 2025
Merged

Add postgres support#441
cschleiden merged 7 commits intocschleiden:mainfrom
vr009:vr009/add-postgres-backend

Conversation

@vr009
Copy link
Contributor

@vr009 vr009 commented Oct 2, 2025

This PR adds PostgreSQL backend support, providing an additional database option alongside MySQL, Redis, SQLite, and in-memory backends.

What’s done

  • Implemented a full PostgreSQL backend with database migrations, connection management, and workflow orchestration support
  • Added including backend tests and end-to-end tests with database isolation
  • Updated samples and bench scripts to align with the existing ones

Implementation notes

  • The implementation follows the MySQL backend as closely as possible, with PostgreSQL-specific adjustments required by the driver and SQL semantics (for example, see removeFutureEvent in postgres/events.go)

I noticed the guidance in issue #199 rather late that this repository aims to keep only a minimal/basic backend implementation. If preferred, I can publish the postgres-based backend as a separate third-party package that implements the backend interface

@cschleiden cschleiden mentioned this pull request Oct 10, 2025
Copy link
Owner

@cschleiden cschleiden left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for this contribution! 🚀 Looks great at first glance, but I want to test it a bit more and review 👀

@vr009 vr009 requested a review from cschleiden October 24, 2025 22:11
cschleiden
cschleiden previously approved these changes Oct 29, 2025
Copy link
Owner

@cschleiden cschleiden left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Just two small comments, after that this should be ready to merge, nice work!

@cschleiden
Copy link
Owner

@vr009 Can you merge latest main or rebase? I'll merge this then

vr009 and others added 7 commits October 31, 2025 11:32
This change introduces full postgres support and aligns SQL, migrations, and
diagnostics with postgres conventions. The implementation is based on the existing
mysql backend, with small fixes and adjustments required by the postgres
connector and Postgres semantics. It also adds integration tests and updates
tooling and samples to run against Postgres.
Co-authored-by: Christopher Schleiden <cschleiden@live.de>
Co-authored-by: Christopher Schleiden <cschleiden@live.de>
@vr009 vr009 force-pushed the vr009/add-postgres-backend branch from 19fd6d3 to c0b483e Compare October 31, 2025 09:40
@vr009
Copy link
Contributor Author

vr009 commented Oct 31, 2025

@vr009 Can you merge latest main or rebase? I'll merge this then

Done - rebased on main

@cschleiden cschleiden merged commit e065cb2 into cschleiden:main Oct 31, 2025
5 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants