dory Files

What's Changed

Features

• Email verification toggle: Added NEXT_PUBLIC_REQUIRE_EMAIL_VERIFICATION and EMAIL_FROM environment variables to enable or disable email verification during sign-up, with corresponding UI and backend support.
• Pre-upgrade workspace backup notification: Introduced a prominent in-app alert prompting users to back up their workspace before upgrading to v0.8.0, localized for English, Spanish, Japanese, and Chinese.
• Anonymous user recovery: Guest users can now recover their session and seamlessly transition to a logged-in account after signing in—preserving unsaved SQL queries, saved queries, folders, and Copilot history.
• Full SQL Copilot for guests: Anonymous users now have full access to the SQL Copilot (including SQL generation, table mode, and save functionality), improving onboarding and exploration.

Fixes

• PGlite browser compatibility: Fixed runtime errors when initializing PGlite in browser environments.
• Sidebar layout regression: Corrected incorrect margins in the application sidebar affecting visual alignment.
• Electron stability: Rolled back Electron from v41 to v39.x to resolve version instability issues during startup.
• Electron bootstrap hangs: Resolved hangs during Electron app startup by properly handling bootstrap completion and preventing concurrent launches.

Improvements

• PGlite upgrade with data migration: Upgraded PGlite from 0.2.17 (PostgreSQL 16) to 0.4.3 (PostgreSQL 17) with an automated, safe data migration path—preserving all existing workspace data.
• Standalone Electron builds: Improved reliability of standalone app packaging by materializing better-sqlite3, resolving node_modules symlinks, and copying required web node_modules.

Internal

• Dependency modernization: Major dependency upgrades across the stack—including TypeScript 5→6, ESLint 9→10, React-Resizable-Panels 3→4, Recharts 2→3, Shadcn 2→4, and more—with corresponding code migrations and type fixes.
• Build & tooling updates: Disabled macOS notarization in Electron Builder, updated Hono and @hono/node-server, and cleaned up stale build artifacts in Electron resource bundles.