Skip to content

Version 2.0.0

Latest
Latest
Compare
Choose a tag to compare
@electroly electroly released this 09 Jun 08:24
· 6 commits to master since this release
v2.0.0
ab97b84

⭐Download the 64-bit installer (recommended)⭐

Or: Download the 64-bit portable zip • Install using Chocolatey

Requires Windows 10 or newer on a 64-bit computer. Going forward, 32-bit systems and Windows 7 and 8 are no longer supported. Users of older machines may continue to use version 1.2.3 which should work indefinitely.

Changes

🔄 FOREACH Loop Statement

Iterate through table rows with automatic variable assignment:

FOREACH (@id, @name, @email) IN customers 
BEGIN
    PRINT CONCAT('Customer: ', @name, ' (', @email, ')');
END
  • Variables are automatically declared and assigned values from each row
  • Supports BREAK and CONTINUE statements like other loops
  • Works with tables, views, and subqueries

💻 Command-Line Interface

Execute SQL Notebook scripts from the command line without opening the GUI:

SqlNotebookCmd "MyNotebook.sqlnb" "MyScript"
  • Perfect for automation, batch processing, and CI/CD pipelines
  • Outputs results in CSV format
  • Returns appropriate exit codes for success/failure

📝 Dynamic Script Management

Create and delete scripts programmatically:

-- Create a new script
CREATE SCRIPT DataCleanup AS '
    DELETE FROM temp_table WHERE processed = 1;
    PRINT ''Cleanup completed'';
';

-- Execute the script
EXECUTE DataCleanup;

-- Remove the script when no longer needed
DROP SCRIPT DataCleanup;
  • CREATE SCRIPT to add new scripts dynamically
  • DROP SCRIPT and DROP PAGE to remove scripts and pages
  • Useful for generating reports, temporary procedures, and workflow automation

💾 Save Command

Save your notebook programmatically from within scripts:

-- Save to current file
SAVE;

-- Save to a specific file
SAVE 'MyBackup.sqlnb';
  • Particularly useful in SqlNotebookCmd for persisting changes
  • Must be used outside of transactions (use "None (auto-commit)" mode in GUI)

🦆 DuckDB Integration

Import data from DuckDB files with full UI support:

  • Drag and drop .duckdb files directly into SQL Notebook
  • Available in Import menu → "From file..."
  • Support for both copying data and live database connections
-- Copy data from DuckDB
IMPORT DATABASE 'duckdb'
CONNECTION 'Data Source=C:\data\analytics.duckdb'
TABLE sales_data;

-- Create live connection
IMPORT DATABASE 'duckdb'
CONNECTION 'Data Source=C:\data\analytics.duckdb'
TABLE sales_data
OPTIONS (LINK: 1);

🗄️ Enhanced SQLite Support

Expanded SQLite file compatibility:

  • Open SQLite databases (.db, .sqlite, .sqlite3) directly via File → Open
  • Import SQLite tables using the same interface as other databases
  • Seamless integration with your existing SQLite workflows
Assets 6
Loading