v1.3.1

Wed Jan 11 2022

Message DB compatibility: 1.3.0

• Correction to the 1.3.0 package that was missing the database scripts

v1.3.0

Wed Oct 12 2022

Message DB compatibility: 1.3.0

This version requires the use of an update script for existing installations. For instructions, see:

https://github.com/message-db/message-db/blob/master/database/update/1.3.0.md

• The get_last_stream_message function can receive an optional type argument that constrains the result to the last message of a stream of a specified message type (see: http://docs.eventide-project.org/user-guide/message-db/server-functions.html#get-last-message-from-a-stream)
• The database installation scripts terminate on error, rather than proceeding with the rest of the installation when a script error occurs

v1.2.6

Sat Mar 13 2021

Message DB compatibility: 1.2.6

• The uninstall.sh script quotes the database name when dropping it, allowing database names that contain dashes

v1.2.5

Fri Mar 12 2021

Message DB compatibility: 1.2.5

• The print-messages.sh script sorts messages explicitly by global_position

v1.2.4

Sun Mar 7 2021

Message DB compatibility: 1.2.4

• The messages tables columns are ordered for more efficient physical storage allocation.

This version should not be considered an update to an existing database. It requires a new installation of the database, and therefore its advantages will only apply to new databases.

v1.2.3

Fri May 15 2020

Message DB compatibility: 1.2.3

• The md5 function is no longer granted privileges for the message_store user as the function is built-in and the grant is superfluous

v1.2.2

Mon May 4 2020

Message DB compatibility: 1.2.2

This version requires the use of an update script for existing installations. For instructions, see:

https://github.com/message-db/message-db/blob/master/database/update/1.2.2.md

• The get_category_messages server function will return the entire, unlimited extent of messages in a category if -1 is sent as the batch_size argument
• The get_stream_messages server function will return the entire, unlimited extent of messages in a stream if -1 is sent as the batch_size argument

v1.2.1

Thu Apr 30 2020

Message DB compatibility: 1.2.1

• The DROP OWNED BY message_store statement is removed from the uninstall script. The use of DROP OWNED BY is prohibited on AWS RDS. And ultimately, it's superfluous because no database objects are owned by the message_store role.

v1.2.0

Mon Apr 27 2020

Message DB compatibility: 1.2.0

• Install script will not create the database when the CREATE_DATABASE environment variable is set to "off"

v1.1.5

Fri Dec 20 2019

Message DB compatibility: 1.1.5

• Changes applied to a pre-v1 message store are documented in database/update/1.0.0.md
• The v1 update script prints out a link to the changes doc