Skip to content

0.3.0

Choose a tag to compare

@github-actions github-actions released this 02 Dec 02:35
· 557 commits to main since this release

data-peek v0.3.0 Release Notes

This release brings major new features including Microsoft SQL Server support, multiple result sets, auto-updates, and significant infrastructure improvements.


Highlights

Microsoft SQL Server Support

data-peek now supports Microsoft SQL Server alongside PostgreSQL and MySQL. Connect to your SQL Server databases with full feature support:

  • Standard SQL Server authentication
  • Active Directory authentication support
  • Full schema exploration and query execution
  • Inline editing, table designer, and DDL generation
  • Query plan visualization (EXPLAIN)

Connection strings can be pasted directly for quick setup.

Multiple Result Sets

Execute multiple SQL statements in a single query and see each result in its own tab — just like TablePlus, DBeaver, and DataGrip.

SELECT * FROM users;
SELECT COUNT(*) FROM orders;
UPDATE products SET price = price * 1.1 WHERE category = 'electronics';

Each statement's results display in separate clickable tabs:

  • Green indicator: Data-returning statements (SELECT)
  • Blue indicator: Row-affecting statements (INSERT/UPDATE/DELETE)
  • Row counts and execution timing per statement

Auto-Updater

data-peek now automatically checks for updates on launch and notifies you when new versions are available. Manual checks are also available via the menu.


New Features

Feature Description
MSSQL Support Full Microsoft SQL Server database support with all features
Multiple Result Sets Execute multiple statements, see results in separate tabs
Auto-Updater Automatic update checks with download prompts
Storage Recovery Automatic recovery from corrupted config files
Documentation Site New docs site at /docs with comprehensive guides

Improvements

Security

  • Encryption keys now use safeStorage: Connection credentials and saved queries are encrypted using Electron's machine-specific safeStorage API instead of hardcoded keys. This provides better security tied to your OS keychain.

Developer Experience

  • Turborepo integration: Monorepo builds are now orchestrated by Turborepo
    • Cached builds: ~73ms (cached) vs ~5.4s (uncached)
    • Parallel task execution
    • Proper dependency ordering across packages

Web & Marketing

  • GitHub Star button in header
  • Improved responsive design across all pages
  • Mobile-first breakpoints for better UX on small screens

Technical Changes

New Files & Modules

apps/desktop/src/main/
├── adapters/mssql-adapter.ts   # New MSSQL database adapter
├── storage.ts                  # DpStorage facade with auto-recovery
├── updater.ts                  # Auto-update functionality
└── sql-utils.ts                # Shared SQL utilities

apps/docs/                      # New Fumadocs documentation site

Updated Adapters

All database adapters (postgres-adapter.ts, mysql-adapter.ts, mssql-adapter.ts) now implement:

  • queryMultiple() method for multi-statement execution
  • SQL statement splitting that respects string literals and comments

Shared Types

New types in packages/shared:

interface StatementResult {
  sql: string;
  rows: Record<string, unknown>[];
  fields: FieldInfo[];
  rowCount: number;
  affectedRows?: number;
  duration: number;
}

interface MultiStatementResult {
  results: StatementResult[];
  totalDuration: number;
}

Build System

  • Added turbo.json for task orchestration
  • New scripts: build:web, build:docs for Vercel deployments
  • Shared package now has its own tsconfig.json

Bug Fixes

  • Fixed identifier quoting consistency across MSSQL and other database types
  • Fixed connection string parsing to support multiple key formats
  • Fixed updater behavior: automatic checks download silently, manual checks prompt user

Breaking Changes

None. This is a backward-compatible release.


New Contributors


Full Changelog: v0.2.0...v0.3.0