message-db

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

Sat Mar 13 2021

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

Fri Mar 12 2021

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

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.

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

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

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.

Mon Apr 27 2020

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

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

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

Fri Dec 20 2019

• The update script is deprecated in preparation of versioned update scripts
• Update scripts are located in database/updates
• The update code for the v1.0.0 database is moved to database/updates/1.0.0.sh

Fri Dec 20 2019

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

Thu Dec 19 2019

• The pgcrypto extension is installed into the public schema (if not already installed), rather than the message_store schema

Wed Dec 18 2019

• Vestigial debug output is removed from write_message

Wed Dec 11 2019

• The message_store role does not own the schema

Tue Dec 10 2019

• Initial release