What's Changed

Remove dsn defaults by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/57
Cleanup linting gha by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/60
Add supervisor by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/58
Doc updates by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/59

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.6...v0.5.7

pgqueuer - v0.5.6

Published by janbjorge 3 months ago

What's Changed

enqueue returning job-ids by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/56
basic fastapi integration test by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/55

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.5...v0.5.6

pgqueuer - v0.5.5

Published by janbjorge 3 months ago

What's Changed

Bugfix: psycopg notify blocked due to lock by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/53
Enable psycopg benchmarking by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/50
Update discord link by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/54

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.4...v0.5.5

pgqueuer - v0.5.4

Published by janbjorge 3 months ago

What's Changed

Drop fetchval on db-driver protocol by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/51

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.3...v0.5.4

pgqueuer - v0.5.3

Published by janbjorge 4 months ago

What's Changed

cli dsn and docker build by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/41
Remove superfluous dns func by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/43
Clean conftest, lower sync sleep by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/45
psycopg driver named parameters by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/46
Use tqdm in benchmark.py by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/47
Supress cancelled error by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/48
While evnets attempt to flush by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/49

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.2...v0.5.3

pgqueuer - v0.5.1

Published by janbjorge 4 months ago

What's Changed

Remove superfluous lambda args packing by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/39
Add test event listener by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/40

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.1...v0.5.2

pgqueuer - v0.5.1

Published by janbjorge 4 months ago

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/v0.5.0...v0.5.1

pgqueuer - v0.5.0

Published by janbjorge 4 months ago

Release Notes

Breaking

Simplified Database Connection: The system no longer requires a connection pool. Instead, a single database connection is now used.

Major

Database Abstraction Layer: Introduction of db.py to provide database driver abstractions, supporting both AsyncPG and Psycopg drivers for PostgreSQL.
Performance Boost: Introducing the JobBuffer class has significantly increased job processing performance, now handling up to 18,000 jobs per second, up from 5,000 jobs per second.
Buffer Management: The JobBuffer class to handle job accumulation and flushing based on capacity or timeout, improving job processing efficiency.

Minor

Dependency Management: Adjustments in pyproject.toml to include and better manage dependencies such as asyncpg and psycopg.
Queue Manager Updates: Significant enhancements in QueueManager to integrate the new JobBuffer, optimizing job handling and logging.
CLI Improvements: Enhancements to cli.py to support the new driver implementations and streamline command execution.
Benchmarking: Updates to benchmarking scripts for better performance tracking and configuration options.

These changes aim to enhance performance, improve code maintainability.

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/0.4.1...v0.5.0

pgqueuer - 0.4.1

Published by janbjorge 5 months ago

What's Changed

Add missing if not exists by @janbjorge in https://github.com/janbjorge/PgQueuer/pull/30

Full Changelog: https://github.com/janbjorge/PgQueuer/compare/0.4.0...0.4.1

pgqueuer - 0.4.0

Published by janbjorge 5 months ago

Notice of Breaking Change

The latest update introduces a breaking change due to the addition of a new updated column to the queue table with a NOT NULL constraint. Users will need to run the upgrade command to update their database schema accordingly. Please ensure you execute the following command after upgrading to avoid any disruptions.

python -m PgQueuer upgrade

This will trigger the below addition a column and creation of an index.

ALTER TABLE pgqueuer ADD COLUMN updated TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW();
CREATE INDEX pgqueuer_updated_id_id1_idx ON pgqueuer (updated ASC, id DESC) INCLUDE (id) WHERE status = 'picked';