CHANGES.md

Changes

3.0.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

2.1.6

Fri 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

2.1.5

Fri Mar 12 2021

Message DB compatibility: 1.2.5

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

2.1.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.

2.1.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

2.1.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

2.1.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.

2.1.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"

2.0.2

Mon Jan 6 2020

Message DB compatibility: 1.1.6

• Install and uninstall scripts explicitly connect to the postgres database when running the psql utility, and do not depend on the existence of a user database

2.0.1

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

2.0.0

Fri Dec 20 2019

Message DB compatibility: 1.1.4

• The mdb-update-db executable is removed
• The mdb-print-database-scripts-dir is added
• The mdb-open-database-scripts-dir is removed

1.1.3

Fri Dec 20 2019

Message DB compatibility: 1.1.3

• The update script is corrected for its referencing of the gen_random_uuid from the message_store schema

1.1.2

Thu Dec 19 2019

Message DB compatibility: 1.1.2

• The pgcrypto extension is not installed into the message_store schema

1.1.1

Wed Dec 18 2019

Message DB compatibility: 1.1.1

• Vestigial debug output is removed from write_message

1.1.0

Wed Dec 11 2019

Message DB compatibility: 1.1.0

• The message_store role does not own the schema

1.0.0

Tue Dec 10 2019

Message DB compatibility: 1.0.0

• Initial release