v0.2.3

What's Changed

• chore: update changelog for v0.2.3 release by @fahimfaisaal in #4
• Refactored database transaction handling by removing redundant rollback calls for better code clarity

Full Changelog: v0.2.2...v0.2.3

v0.2.2

What's Changed

• quote the table name by @nemith in #2
• refactor: move quoteIdent to utils and used in priority queue by @fahimfaisaal in #3

New Contributors

• @nemith made their first contribution in #2

Full Changelog: v0.2.1...v0.2.2

v0.2.1

What's Changed

Fixed

• Added recovery functionality for unacknowledged queue items via RequeueNoAckRows()
• Added boolean column ack to track acknowledgment status
• Improved query performance with additional indexes
• Fixed issue with duplicate ack_id generation

Full Changelog: v0.2.0...v0.2.1

v0.2.0

Changed

• Modified queue and priority queue to work with byte arrays ([]byte) instead of arbitrary types
• Updated the Values() method to return byte arrays directly without JSON unmarshaling
• Updated SQLite3 dependency from v2.0.3+incompatible to v1.14.28 to fix compatibility warnings

Full Changelog: v0.1.1...v0.2.0

v0.1.1

• Some fixes regarding mod and readme file

Full Changelog: v0.1.0...v0.1.1

v0.1.0

Initial Release 🎉

Added

• Initial release of SQLiteQ
• Basic queue functionality with SQLite backend
• Support for acknowledgment-based processing
• Priority queue implementation with configurable priority levels
• Option to retain acknowledged items in the database (WithRemoveOnComplete)
• Comprehensive test suite for both Queue and PriorityQueue implementations
• Example code demonstrating both regular and priority queue usage
• WAL mode enabled for better concurrent access
• Proper indexing on status and timestamp columns for efficient querying

Implementation Details

• Queue items have simple lifecycle: pending → processing → completed/removed
• Priority queue dequeuing respects both priority and creation time