v1.3.0

Wed Oct 12 2022

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

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

v1.2.5

Fri Mar 12 2021

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

v1.2.4

Sun Mar 7 2021

• 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

• 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

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

• 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

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

v1.1.6

Mon Jan 6 2020

• 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

1.1.5

Fri Dec 20 2019

• 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