DBJoy 0.4.10

Changed

• Copy Database's table list makes clear its checkboxes are for data. The column is now called Data, and a line under Tables says that every table's structure is copied and unchecked tables are created empty.
• Empty tables show "0 bytes" instead of "Zero KB".

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.10.dmg): 420f42b835355347753c2a85aba6ed54605d0b49d661e072743939075e4b2ee7

DBJoy 0.4.9

New

• Copy Database lets you pick which tables come with their rows. The window lists the source's tables with their estimated row count and size, biggest first, with a filter and All / None buttons. Unchecked tables are copied empty, and foreign keys into them are added without checking the copied rows. With Copy rows in platform schemas on, platform tables such as auth.users are in the list too; unchecking one keeps the target's rows.

Changed

• Copy Database turns off the statement timeout and the idle-in-transaction timeout for its own session, so server or role defaults don't end a long copy.
• When the server drops the connection during a copy, the error suggests leaving out the rows of the biggest tables.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.9.dmg): 56e569dfd051027fc72d4b712e04df8adc74b24c2fbb9a01815144c798c3b476

DBJoy 0.4.8

Fixed

• Copy Database failed with "cannot drop sequence … because column id of table … requires it" when the target's public schema had a table with an identity column (GENERATED … AS IDENTITY) and had to be emptied in place, as on Supabase. A column's sequence is now dropped together with its table.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.8.dmg): cae98e16fcca4a4cd9fc5341f59c329b82a0499f48f6ffad67c5a31ff4ce2fcb

DBJoy 0.4.7

Fixed

• Copy Database now works between Supabase projects (and other managed services) without changing any roles. It copies your schemas, tables and data, and leaves the platform's schemas (auth, storage, realtime, …) as they are.
• When public holds an extension that belongs to the platform, such as vector on Supabase, DBJoy empties public in place instead of skipping it, and the extension stays.
• Foreign keys from your tables into platform tables, such as profiles → auth.users, are added without checking the copied rows, so rows that point at users the target doesn't have still load.
• Your triggers and policies on platform tables (such as on_auth_user_created) are replaced with the source's.
• Not copied: rows of the platform's extension tables (pg_cron's jobs), event triggers, and subscriptions.
• The confirmation lists what is kept, emptied and left out. Anything the copy couldn't replace is listed afterwards as a warning.

New

• Copy rows in platform schemas (off by default) also copies rows such as Supabase's auth.users.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.7.dmg): 290b7585e40fea3c89922a27ff10cbf121660aac9f13ad9d6a2b81561e326bad

DBJoy 0.4.6

Fixed

• Copy Database failed on managed services (Supabase, RDS and others) with errors like "must be owner of schema pgbouncer", because those services keep schemas and extensions owned by their own roles. DBJoy now leaves those schemas alone instead of dropping them, and skips schemas the source's user can't read. The confirmation lists what will be left as it is.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.6.dmg): 04183558c6ba79c0a5df8a63b71eae329c223ca2f736a990afe42c74cda05d98

DBJoy 0.4.5

New

• Copy Database (Database → Copy Database…) replaces everything in one database with an exact copy of another, for example production into a local database. It copies every schema, table, view, materialized view, function, procedure, type, sequence, trigger and extension, with or without the data.
• DBJoy drops every schema in the target first, then loads the source with pg_dump and psql in one transaction. If anything fails or you cancel, the target stays as it was.
• You confirm by typing the target database's name. Read-only connections can't be a target.
• Owners and grants aren't copied by default, so the copy works between servers with different roles. Turn on "Copy owners and privileges" to keep them.
• psql now ships inside the app next to pg_dump.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.5.dmg): 34f8adab2b51e5e63695ef31cde958b9afa30de91b613a3f16cb1f1402635d94

DBJoy 0.4.4

Fixed

• If DBJoy was updated while it was running, clicking Open file, Export, Save script, or choosing an SSH key froze the window for about 10 seconds and then showed nothing. macOS can't show open and save dialogs for an app whose files were replaced underneath it. DBJoy now shows an alert asking you to restart instead.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.4.dmg): 6a5243f9e2c5d1ef385162af5d127b7ffe5c217862b00e67a1ce83d9db167131

DBJoy 0.4.3

Fixed

• Letting go of a starred connection anywhere on the starred bar now ends the drag cleanly. In 0.4.2, dropping between items showed the connection twice for a moment while the drag image slid back.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.3.dmg): 98cb3583e8e279668136e0f1c5815dcc2c863eb6cf87178624cf5edfd6f45281

DBJoy 0.4.2

Fixed

• Dragging connections in the starred bar now works. In 0.4.1 the drag didn't start or wasn't accepted.
• The dragged connection follows the pointer as a round avatar and leaves a gap where it was.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.2.dmg): 63e863d8da5b9556ade6001e8af8572d8880e83c2bc30341c2db08fd23222c49

DBJoy 0.4.1

Added

• Drag connections in the starred bar to put them in the order you want. The order is kept, and newly starred connections go to the end. VoiceOver users can use the Move Up and Move Down actions.

Install

Open the DMG and drag DBJoy to Applications. Signed with Developer ID and notarized by Apple.

Requires macOS 15 or later on Apple Silicon.

SHA-256 (DBJoy-0.4.1.dmg): 395a0405a6a4a0c31e515f32dde66d0275f65702e6246b005d55fc1c45548e49