Release notes from sqlnotebook

Version 2.0.0

2025-06-09T09:22:07Z

⭐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

v1.2.3

2025-06-09T09:19:54Z

Requires Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB3063858 are required.

Changes

Arm64 computers are now supported. Use the downloads labeled "arm64".
Small joins to remote database tables are now faster.
Updated to SQLite 3.46.0.

v1.2.2

2024-06-19T05:15:05Z

Requires Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB3063858 are required.

Changes

32-bit Windows is now supported. If you have an older 32-bit computer, use the "32bit" download below.
Updated to SQLite 3.44.0.

v1.2.1

2023-11-05T18:42:45Z

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

Fixed an error message when saving a notebook in certain situations. (#48)
No longer inserts nonprintable control characters when pressing Ctrl+? key combinations. (#52)
Fixed an error message when a query result includes a zero-length blob.
Updated to SQLite 3.40.1.

v1.2.0

2023-01-08T03:13:05Z

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

When importing CSV/XLS, you can now set the type for multiple selected columns at once. You may also opt to automatically detect column types. (#45)
You can now import non-public schemas in PostgreSQL. (#47)
Fixed handling of blank or missing column names in CSV/XLS files.
Updated to SQLite 3.38.5.

v1.1.0

2022-05-08T21:23:24Z

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

Updated to SQLite 3.38.0.
Added the crypto, fuzzy, and stats extensions from Anton Zhiyanov's sqlean project.
Enabled the load_extension function for loading custom SQLite extensions.
You can now drag-and-drop a CSV or Excel file onto the SQL Notebook window to import it.

v1.0.1

2022-03-04T06:37:30Z

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

On Windows 7, an error message was preventing the application from launching. This has been fixed. Windows 7 users, please see the System Requirements for Windows 7.

v1.0.0

2021-12-16T07:48:26Z

Requires 64-bit Windows 7 (or newer).

Changes

This is the first stable release. All aspects of the application have been improved and polished.

v0.6

2021-12-13T05:36:02Z

Requires 64-bit Windows 7 with .NET Framework 4.6 (or newer).

Changes

First public release.

v0.5

2016-04-25T08:26:02Z

Fixed exception when binding NULL to query parameter.
Added additional help pages.
Removed "root_" prefix from imported JSON table names.
Installer and application are now signed.