Releases: brianluft/sqlnotebook
Version 2.0.0
⭐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 SCRIPTto add new scripts dynamicallyDROP SCRIPTandDROP PAGEto 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
.duckdbfiles 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
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
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
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
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
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
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.