Geordi 12.6.0 was released

Posted . Visible to the public. Auto-destruct in 59 days

Changelog

- `geordi dump`: Allow to forward the compression option to the underlying `dumple` command, e.g. `geordi dump --compress=zstd:3` (for PostgreSQL) or `geordi dump --compress` (for MySQL).
- `dumple`: Allow to specify a compression algorithm for PostgreSQL, e.g. `dumple --compress=zstd:3`. The already supported compression for MySQL `dumple --compress` is kept untouched.

In PostgreSQL you will notice a speedup of ~50%.

Example

Performance improvements during a deploy (e.g. lib/capistrano/tasks/db.rake)

namespace :db do
  desc 'Do a dump of the DB on the remote machine using dumple'
  task :dump do
    on primary :db do
      within current_path do
        execute :dumple, '--fail-gently', '--compress=zstd:3', fetch(:rails_env, 'production')
      end
    end
  end
end

or when loading a dump geordi dump -l production --compress=zstd:3.

Last edit
Emanuel
License
Source code in this card is licensed under the MIT License.
Posted by Emanuel to makandra dev (2025-09-22 13:43)