Foza

v4.0.2

• Removed temporary table from fetchq.doc_pick()
• Reduced the utilization of FROMAT to table name only in fetchq.doc_pick()

(you never stop learning new tricks!)

lusiana

This is a major release because the reschedule and document pick have changed their behavior.

Document pick "sees" a document that is scheduled exactly on "now()".

Rescheduling a document in the past sets its status to pending, so that document is available for picking without the need for a maintenance loop.

That should be a crazy performance improvement!

• doc_reschedule() is able to set status=1 when a document is rescheduled in the past (or present)
• doc_pick() picks documents that are scheduled at NOW()

conco

This release mostly fixes an issue with the metrics_writes table that can go out of the INTEGER limit when performing on a lot of manned queues. We removed the INTEGER primary key in favor of a UUID key. We also improved the logging methods so as to ignore Zero changes and therefore skipping logs that would not affect the counters, effectively reducing the work that the metrics task has to do.

• Uses uuid data type in fetchq.metrics_writes to prevent
  running out of integer IDs over time.
  (#38)
• Reduces metric_writes by ignoring increments of Zero value
• Add new methods:
  • fetchq.doc_push('queue', 'subject')
  • fetchq.doc_push('queue', 'subject', '{"payload": true}')
  • fetchq.doc_push('queue', 'subject', '{"payload": true}', NOW() + INTERVAL '5m')
  • fetchq.doc_append('queue', '{"payload": true}')

canove

• Adds fetchq.queue_truncate('queue_name') to drop current documents in a queue
• Adds fetchq.queue_truncate('queue_name', true) to completely void a queue
• Adds fetchq.queue_truncate_all() to drop all the documents in the existing queues
• Adds fetchq.queue_truncate_all(true) to remove all data from the system
• Improves test environment

asiago

• Refactor schemas so to keep sys and data separated
• moved all the functions into the fetchq schema
• renamed errors table into logs

padova

• Adds fetchq_trace(subject) api.
• Improves migration instructions 1.x -> 2.x

verona

• Adds fetchq_queue_create_indexes(qname) signature that generate per-queue indexes
  based on informations read from the sys_queues table.
• Adds fetchq_trigger_notify_as_json() that can be attached to any table to emit a full
  JSON representation of the event (INSERT; UPDATE; DELETE).
• Emits full JSON events for fetchq_sys_queues so that the client can subscribe to it and
  honor the queue status.

vicenza

Introduces the fetchq_catalog schema so to keep all the queue's tables separated from your app's.