QPad
What's new
Changes in QPad
What is new, better and fixed in each version, newest first. QPad tells you at startup when a new version is ready.
Version 1.0.155
Latest version- Improved
English website on getqpad.com
The English website is now on getqpad.com, and qpad.no shows the Norwegian pages unless you have picked EN or NO in the language menu. The links in the license dialog open getqpad.com. Your account, licenses and devices are the same on both addresses.
Version 1.0.152
- New
AI assistant with your own API key
Add your own API key from Anthropic (Claude) or OpenAI under Edit → AI assistant settings, and open the assistant next to Results and SQL, or with Ctrl+I. Describe what you want and get a query back, or use Explain the error, Fix the error and Explain the code. The assistant knows the tab's language, code, errors and the tables and columns of its connection, also for your own EF Core DbContext. Answers appear as they are written, and code blocks can be inserted at the cursor or replace the query. The question, the code, the errors and the names and types of tables and columns are sent to the provider you chose; never query results, connection strings or passwords. The key is stored encrypted, and the use is billed by the provider on your own account. This is a Pro feature.
Version 1.0.151
- New
Debugger with breakpoints
Click left of the line numbers or press F9 to set a breakpoint, and F5 runs the query with the debugger. It stops on the line, and you can step with F10, F11 and Shift+F11, see the variables under Locals, the methods under Call stack, and a value by hovering over a name. An exception the query does not handle stops on the line where it was thrown. Without breakpoints the query runs as before. This is a Pro feature.
- New
Query with your own EF Core DbContext
Point a connection at your project's built DLL and pick the DbContext. QPad suggests how to create it: your design-time factory, a constructor with DbContextOptions, a connection string from the dialog or appsettings.json, or a parameterless constructor. The DbSets are available by name with code completion, SaveChanges works, the SQL EF Core runs is shown in the SQL view, and the schema tree shows your model. QPad uses your project's own EF Core version, works on a copy of the build, and picks up a rebuild by itself. This is a Pro feature.
- Fixed
Queries no longer stopped by Microsoft Defender
Microsoft Defender sometimes mistook a compiled query for malware and stopped it. QPad now compiles queries in a way that avoids this, and explains what happened if a virus scanner still blocks one.
- New
SQL mode
Choose SQL in the language list to write SQL straight against the tab's database. Each result set is shown as a table that can be exported, changes show how many rows were affected, and PRINT messages are shown as text. GO splits SQL Server scripts into batches, a selection runs on its own, and errors point at their line. Code completion suggests tables, columns and keywords, also after an alias. SQL mode is a Pro feature.
- New
Export results to Excel and CSV
Above each table in the results are Copy, CSV…, Excel… and Open in Excel. Copy pastes the table straight into Excel, Word or a mail. In Excel, numbers, dates and true/false keep their types, with a bold header row and filters. Export is a Pro feature.
- New
Accounts on qpad.no: Free, Pro and Educational
Licenses are now managed on your account at qpad.no. Free has IntelliSense and quick fixes for the first 14 days, Pro is free for now, and Educational is free for students and teachers. A license works on up to 3 devices. The license window in QPad shows the edition, has Refresh, and can remove the license from the device to free its place. Keys sent by e-mail keep working until February 1, 2027; register with the same address to keep your key.
Version 1.0.149
- Improved
UI updates
Several improvements and fixes in menus and layout.
Version 1.0.147
- Improved
Security improvements
This version contains security improvements in the app. You won't notice any difference in use, but we recommend updating.
Version 1.0.146
- Improved
Errors shown above the code
Compilation errors and exceptions now appear in a yellow box at the top of the code window instead of in the results. Click an error to go to the line, or right-click to copy the whole error message.
- New
Choose a color theme for the editor
Under Edit → Edit theme you can choose between Visual Studio, Visual Studio Code and One Dark Pro. Each theme has a light and a dark version, and you see both before you choose.
- Improved
Colors for types, methods and variables
The editor now colors code like Visual Studio: types, methods, variables, parameters and namespaces each have their own color.
Version 1.0.144
- New
Send requests for new features
With an activated license, “Feature request” appears in the top right corner. Describe what you are missing and press Submit, and the request comes straight to us.
Version 1.0.143
- New
Quick fixes with Ctrl+.
When the cursor is on an error, Ctrl+. suggests fixes, as in Visual Studio: a missing
using, the full name of the type, typos,asyncon the method and more. Pick a suggestion and the code is fixed. - New
Light bulb on errors
A small light bulb with an arrow appears in front of the line when a fix is available. Hover over it or click it to see the suggestions.
- New
Install missing NuGet packages from the code
If you use a type from a well-known package, such as
JsonConvertorCsvReader, the quick fix offers to install the package. The package is downloaded, added to the query and gets itsusingin one go.
Version 1.0.131
- New
First public version
Write C#, press F5 and see the answer. Three run modes (C# Expression, C# Statements and C# Program),
.Dump()that shows results as tables, tabs and.qpadfiles. - New
LINQ against SQL Server, PostgreSQL and SQLite
Connect to a database and the tables become ordinary properties in your code:
Customers.Take(100).Dump();. The SQL tab shows the SQL that ran. - New
NuGet packages and your own feeds
Search for and add packages from nuget.org and your own feeds, including Azure DevOps with a personal access token.
- New
IntelliSense and formatting
Code completion, parameter info, hover info and errors as you type. Ctrl+K, Ctrl+D formats the code. IntelliSense is turned on with a free license key.
- New
New version notifications and error reports
QPad tells you at startup when a newer version is available. Errors in QPad itself can be sent to us automatically so they can be fixed. This can be turned off under Settings.
Want to try the latest?
A new version installs right over the old one. Your queries and settings are kept.
Download QPad