Softpedia >Mac >Developer Tools >SQLiteStudio >  Changelog

SQLiteStudio Changelog

What's new in SQLiteStudio 3.4.4

Apr 10, 2023
  • ADDED: #3488 SQLite ICU extension is boundled into binary packages (thanks to @tuffnatty).
  • ADDED: #4697 Added a 'Restore original hotkey' buttons at keyboard shortcuts page of configuration dialog.
  • ADDED: Added sqlar extension to the default set of extensions provided with binary packages.
  • CHANGE: #4689 Sorting order is not cleared when table data is refreshed. To removed sorting order user can either double-click on header (once or twice) to restore no sorting for a column, or use context menu to clear any sorting.
  • CHANGE: #4735 Order of functions loading has changed. Now it's: built-in, extension-provided, user-defined. The last loaded has the highest precedense.
  • CHANGE: #4732 SQLite updated to 3.41.2 (except for SQLCipher, which is still on 3.39.4 at the moment).
  • CHANGE: #4683 Custom syntax highlighting colors now use theme-based colors by default (to work well with dynamically changing color palette in night/day theme changes) and can be explicitly enabled in configuration.
  • BUGFIX: #4676 #4716 #4693 #4701 #4669 #4721 Few critical fixes for Query Executor, fixing a frequent error: near ")": syntax error.
  • BUGFIX: #4685 Fixed WINDOW/OVER/FILTER keyword handling in the SQL parser.
  • BUGFIX: #4694 Fixed messages for toolbar buttons in Code Snippets window & fixed loading translations for plugins.
  • BUGFIX: #4698 Fixed handling object names with '{' and '}' in their names.
  • BUGFIX: #4681 Fixed risk of null reference call in the SqliteOrderBy.
  • BUGFIX: #4707 Fixed database file selection dialog, so it doesn't complaint about read-only files.
  • BUGFIX: #4679 Fixed issue with case sensivity of CTE alias.
  • BUGFIX: #4697 Changed default hotkey for rolling back pending changes in table data from Ctrl+Backspace to Alt+Shit+Backspace. Default hotkey affects new users and will not change automatically for those who upgrade from older SQLiteStudio.
  • BUGFIX: #4739 Fixed committing changes in Extensions Manager if modifying valid extension settings, while there is another invalid, yet untouched extension on the list.
  • BUGFIX: #4715 Fixed the UPDATE OF column popup on MacOSX.
  • BUGFIX: #4754 Fixed Windows uninstaller to not create separate uninstall entries in Windows registry per each SQLiteStudio version and added SQLiteStudio icon for the uninstall entry in Windows Add/Remove programs.
  • BUGFIX: Tcl plugin compilation improved on Ubuntu 18.04 (thanks to @tuffnatty).

New in SQLiteStudio 3.4.3 (Jan 20, 2023)

  • CHANGE: #4631 Linux binaries are built again back on Ubuntu 20.04 (instead of 22.04) to make it compatible for more Linux machines.
  • BUGFIX: #4660 Removed unnecessary linking to curses library in Linux build file.
  • BUGFIX: #4658 Fixed crash when SQL parser stack gets overflown.

New in SQLiteStudio 3.4.2 (Jan 17, 2023)

  • Loading data of tables that refer other tables with foreign key could take very, very long in some cases. It's fixed now to work as fast as it was in 3.3.3.
  • Crash when clicking "Test connection" in Database Dialog.
  • Crash when executing JavaScript-implemented custom SQL functions.
  • TLS issues when checking online for updates.
  • SQLite version updated to most recent 3.40.0.

New in SQLiteStudio 3.4.1 (Dec 4, 2022)

  • CHANGE: #4585 SQLite updated to 3.40.0 (except for SQLCipher, which has latest version 3.39.2).
  • BUGFIX: #4600 #4587 Fixed very slow loading of data in tables with foreign keys.
  • BUGFIX: #4549 Query executor column aliases do not need wrapping anymore, because parser in 3.4.0 does not strip wrapped aliases anymore.
  • BUGFIX: #4219 Removed duplicated UI config entries generated by Printing plugin.
  • BUGFIX: #4563 Installer now runs the application at final step as a regular user even if running as root.
  • BUGFIX: Fixed icon path for Linux installer, so that SQLiteStudio shows with the icon in Linux application list.
  • BUGFIX: #4550 Fixed the Test Connection button in Database Dialog.
  • BUGFIX: #4569 Fixed casual application crash on database disconnection.
  • BUGFIX: #4529 Fixed application freeze when creating table with ICU collation.
  • BUGFIX: #4586 Fixed unloading & loading SQLCipher plugin during single run of application.
  • BUGFIX: #4577 Fixed SSL handshake issue under Linux during updates checking.
  • BUGFIX: #4590 Fixed TLS issue under Windows.
  • BUGFIX: #4364 Fixed table modification script in case all existing columns of a table are deleted, but the table remains and then new columns are added.
  • BUGFIX: #4098 Fixed disappearing table (not really, just in UI) when dragging it and dropping onto SQL Editor.
  • BUGFIX: #4594 Initial (default) colors of current line/query in SQL Editor is fixed to not be just black.
  • BUGFIX: #4140 #4343 Disabling Foreign Keys during execution SQL directly from file.
  • BUGFIX: #4593 Fixed row/column (de)selection on header ctrl+click.
  • BUGFIX: #4596 Fixed thread-safety issue with QtScripting (JavaScript) built-in plugin.

New in SQLiteStudio 3.4.0 (Nov 17, 2022)

  • Installer packages are back (while portable packages are still available on GitHub Releases page). The new installer is driven by the VMware InstallBuilder.
  • Python scripting plugin (alongside of already existing similar Tcl, JavaScript and SQL plugins).
  • Code Snippets - a collection of SQL snippets that you can maintain in your SQLiteStudio and use it instantly from the Code Assistant (by triggering the assistant twice).
  • Added convenient way to increase/decrease font size by using Ctrl+MouseWheel or by (configurable) shortcuts Ctrl + + and Ctrl + -.
  • Application state (session) is saved (apart from normal application exit) whenever the state changes and also during critical application crash.
  • WAL mode is now handled properly upon application quit or database disconnection.
  • Database dialog has now just one browse button, but uses Qt file dialog, not native one.
  • Windows i386 (32 bit) binaries are now provided out of the box.
  • Changed F2 hotkey, so it enters inline editing of a cell (no longer it opens the config dialog, which now is under F10 key).
  • Fixed Dead Keys support under Linux.
  • Linux binaries are now built on Ubuntu 22.04 (used to be 20.04).
  • New model of translation files (thanks to the Crowdin).
  • SQLite upgraded to latest 3.39.4. With the upgrade also new features and updated SQL syntax is fully supported:
  • RETURNING syntax in INSERT/DELETE/UPDATE
  • MATERIALIZED syntax in CTE
  • STRICT tables
  • RIGHT, FULL OUTER JOIN, IS (NOT) DISTINCT FROM

New in SQLiteStudio 3.3.3 (Apr 13, 2021)

  • Rather small, yet important bugfix release. Includes update to the most recent SQLite (3.35.4) and brings back independent SQLite library file to allow user manual updates if necessary.
  • Other notable changes are:
  • Expanded/collapsed state of connected databases is saved and restored upon next startup.
  • The "DEFAULT" column on Structure tab is now correctly showing the default value (it was always empty in 3.3.2).
  • Fixed support for portable config directory (the "sqlitestudio-cfg") that was broken in prior 3.3.x version.
  • Few bugs causing unexpected application crash were fixed, improving overall stability of the application.
  • Import and Export dialogs are now rendered correctly under "Fusion Dark" theme.

New in SQLiteStudio 3.3.2 (Mar 8, 2021)

  • Yet another bugfix release, due to critical bug in 3.3.1, which caused SQL numbers and star operators to be wrapped with quotes.
  • Apart from this key bugfix, one more fix in this version is that parenthesis pairs matching now uses different color scheme than text selection colors, so it is not confusing anymore. By the way of this release also automated Unit Tests are added for SQL formatter component, to reduce amount of regression bugs.

New in SQLiteStudio 3.3.1 (Mar 7, 2021)

  • A quick bugfix release, due to critical bug in 3.3.0, which caused SQL strings to be stripped from quote characters when formatting it.
  • Other changes:
  • New option was added in configuration dialog (on Data Browsing page) allowing to disable "smart limit" for number of rows if user is working with lots of columns.
  • HighDPI support improved further. There are still many issues with HighDPI scaling, but they are caused by issues that Qt has and SQLiteStudio will gain fixes for that as improvements in Qt are made.
  • The Foreign Key dropdown (in grid view) was fixed to restore behavior from 3.2.1 (instead of selecting always 1st value from dropdown - or even crashing - when clicking away of it).

New in SQLiteStudio 3.3.0 (Feb 22, 2021)

  • After almost 3 years I'm proud to announce version 3.3.0. It brings update of SQLite to 3.34.1 with all its new features, dark theme, and much more!
  • Among many bugs fixed (59) and improvements, here are few outstanding new features and changes:
  • SQLite upgraded to 3.41.1. This includes UI support for "generated columns", support for new syntax statements - OVER (Window Functions), UPDATE FROM, VACUUM INTO.
  • DbSqliteWx plugin upgraded to use SQLite3MultipleCiphers (SQLite 3.34.1), thus now capable of opening WxSQLite3, SQLCipher and System.Data.SQLite databases (also under Linux & MacOS).
  • DbSqliteCipher plugin upgraded to the most recent version too (which runs SQLite 3.34.0).
  • Windows binaries are now 64-bit.
  • Big values handing was significantly improved. SQLiteStudio still limits initial value for all cells to 100 characters (for optimization reasons) and loads full value when editing it, but if a cell has more data available for display, it will show button at the right side of the cell, allowing to load remaining piece of data at once. User can also load full values for entire column from right-click menu of the column header.
  • Improved HighDPI displays support.
  • Dark theme (Dark Fusion), including native dark theme on MacOS X.
  • Toolbars received a small lifting - a number of buttons were removed (their functions are still available through menu bar, right-click context menu and keyboard shortcuts), Editor Window got its database dropdown pulled to the left, Table Window & View Window got database dropdowns at the beginning of toolbars - for easier context understanding by user.
  • Most repeated and irritating bugs that were fixed:
  • Database panel (left-side panel) shrinking all the time - no longer shrinks.
  • Column in data view is no longer resized if user sets his own width and then edits values in cells or refreshes data from database.
  • There are few notable removals:
  • System.Data.SQLite plugin was removed, as the official System.Data.SQLite library was getting more and more outdated and with new DbSqliteWx plugin version (which can open System.Data.SQLite files) there's no need to continue this plugin.
  • SQLite2 plugin was removed. It was hardly ever used and was causing a lot of maintenance effort.
  • Installer (Qt's Installer Framework) was removed. Updates will still be checked and user will be notified about new version being available, but it will be up to the user to download new version. Only portable packages are going to be provided from now, until more suitable installer framework is found & mastered.

New in SQLiteStudio 3.2.1 (Jul 27, 2018)

  • [BUGFIX]: Fixed start under Linux using the pre-compiled binary distributions (it used to fail due to missing xcb dependency).
  • [BUGFIX]: Fixed 'export data' checkbox in export dialog to not ignore it anymore.
  • [BUGFIX]: Binary packages now include the MultiEditorImage plugin, which introduces the picture preview for BLOB values. It was introduced in 3.2.0, but missing in binary distributions.

New in SQLiteStudio 3.2.0 (Jul 25, 2018)

  • [NEW]: #3188 New plugin to have images stored in database being visible as another tab in the Form View or cell's editor dialog window.
  • [NEW]: #3207 #1444 #2547 Export, Import & Populate dialog settings are remembered, even after application restart.
  • [NEW]: #3268 Query bind parameters are now supported by the query editor while execution - user will be asked for values for these parameters in a dedicated dialog.
  • [NEW]: #3267 Added Extension Manager window, where all SQLite extensions can be registered for loading into databases.
  • [NEW]: #3161 Added support for table-valued functions (https://sqlite.org/vtab.html#tabfunc2)
  • [NEW]: #3349 Added support for UPSERT syntax from SQLite 3.24.0.
  • [NEW]: #3292 Added possibility to execute huge SQL files directly from disk, without loading them to SQL Editor.
  • [NEW]: #3265 Completely new installer for SQLiteStudio is introduced. It bases on Qt Installer Framework. This addresses numerous issues with automatic updates that SQLiteStudio had. It also allows for some new features, like automatic file association under Windows (#3178). Portable (download & run, without installation) distribution continues to be available.
  • [NEW]: #2659 AutoIncrement option is now always available in PK configuration dialog. When AutoIncrement is enabled, a datatype will be enforced to INTEGER type.
  • [NEW]: #2798 Added filter inputs per column as an option.
  • [NEW]: #3224 Added context menu for SQL history tab to delete individual (or a range of selected) entries. Also a "delete" key can be used.
  • [NEW]: #2651 Only a single instance of SQLiteStudio can be running at the time. If another instance is requested, the first one will be brought to the front of windows stack. If another instance was requested due to associated file being open, then the first instance will not only be raised, but also the requested file will be added to database list as temporary, volatile database (not added permanently to configuration).
  • [NEW]: #3033 Ctrl+Shift+c copies data including headers. Also context menu entry added for the same.
  • [NEW]: #2962 Pasting single value to multiple cells results in pasting the value into all selected cells, not just to first one.
  • [NEW]: #2907 The "Open file's directory" menu item added to database list for database nodes.
  • [NEW]: #3388 Added file association entries in the plist for MacOSX
  • [NEW]: #3163 Added menubar accelerator keys.
  • [CHANGE]: #3257 #3260 #3271 Bug/Feature reports are now completely managed by GitHub. Bug report dialog is no longer present in the application, but instead the menu entry opens web browser on project's GitHub page.
  • [CHANGE]: #3285 SQLCipher and wxSQLite3 plugins can now be linked to system-provided libraries, which is especially useful under Linux. Instructions were added to the wiki page: https://github.com/pawelsalawa/sqlitestudio/wiki/Instructions_for_compilation_under_Linux#linking-with-system-provided-libraries
  • [CHANGE]: #3284 SQLite3 upgraded to version 3.24.0 (excluding SQLCipher plugin, which is still on 3.20.1).
  • [CHANGE]: API of QueryExecutor enhanced to provide custom steps at certain stages of execution. Steps can be injected by plugins.
  • [CHANGE]: #3121 Column widths are kept between data reloads.
  • [CHANGE]: #3024 Edit in editor action in cell's context menu stands now "show in viewer" if clicked on read-only cell. Also "set null" and "erase" are not displayed if none of selected cells is editable.
  • [CHANGE]: #3142 Horizontal scroll position is now preserved between sort request on a data view.
  • [CHANGE]: #2971 Column width is now mostly based on data width, not header width, but if there is little columns to be displayed, the header width is also considered.
  • [CHANGE]: #3323 Disabled automatic line wrapping in SQL editor and all other code edition fields in the application.
  • [BUGFIX]: #3259 #3215 #3327 Stop interpreting "+3" or "0010" as numeric types if entered to TEXT column (or any other column not declared as numeric-ish).
  • [BUGFIX]: #3191 CSV import speed improved. It's 1400 times faster. It's not a joke. The bug used to cause the import to be terribly slow. Also other importing plugins gained around 400% of speed.
  • [BUGFIX]: #3119 Fixed extra "empty" row of data when importing from CSV with a new, empty line at the end.
  • [BUGFIX]: #3235 Crash when opening DB dialog, but file was moved.
  • [BUGFIX]: #3185 Fixed creation of new tables/views if "Data" tab is configured as first.
  • [BUGFIX]: #3279 Fixed reporting rows affected with DELETE statement for SQLite2.
  • [BUGFIX]: #3023 Optimized SQL editor widget to work with huge contents.
  • [BUGFIX]: Fixed random crashes at application close (when saving session). Most frequend on Windows platform.
  • [BUGFIX]: #3252 Fixed first character input when starting to edit FK column data.
  • [BUGFIX]: #3251 Fixed DEFAULT constraint dialog to work wit "literal values in double-quotes"
  • [BUGFIX]: #3084 #3085 Fixed beeps under MacOSX when editing FK cell.
  • [BUGFIX]: #3293 Fixed deault shortcut for code assistant under MacOSX from Cmd-Space to Ctrl-Space, so it does not conflict with Spotlight
  • [BUGFIX]: #3190 Fixed handling WITHOUT ROWID and unusual column name.
  • [BUGFIX]: #3177 Fixed tab indentations when selecting even part of a line.
  • [BUGFIX]: #3171 Pasting object to same database is prevented.
  • [BUGFIX]: #3176 Fixed exporting with Common Table Expression (the WITH statement).
  • [BUGFIX]: #3162 Fixed order of column headers in Index Dialog
  • [BUGFIX]: #3159 Fixed dictionary populating plugin to recognize different new-line characters.
  • [BUGFIX]: #3156 Fixed recognition of double-quoted values.
  • [BUGFIX]: #3093 Columns with AUTOINCREMENT statement are defaulted to null for new rows in Form View, so they get committed this way (unless manually changed) and they become an auto generated values.
  • [BUGFIX]: #3086 #3187 Fixed internal task ordering when drag&dropping tasks on the taskbar, so switching between tasks with keyboard shortcut reflects order of tasks on the taskbar.
  • [BUGFIX]: #3173 Added support for detecting and trimming whitespace in pasted text (thanks to nishanthkarthik for contributing this)
  • [BUGFIX]: #2922 Fixed CTE execution by QueryExecutor, so it understands columns from CTE (not editable columns for now, maybe will become editable in future).
  • [BUGFIX]: #2964 SQL history tab shows now local time of execution, not UTC.
  • [BUGFIX]: #3290 Fixed querying data for FK dropdown from tables/columns with unusual characters in name. Also fixed name-wrapping for objects that have unescaped wrapper character inside of their name.
  • [BUGFIX]: #3305 Introduced dynamic limit for number of rows per page - based on number of columns, so it's less likely to hit the memory limit.
  • [BUGFIX]: #3311 Fixed floating point numbers handling.
  • [BUGFIX]: #3383 Fixed JSON export plugin for quoted names.
  • [BUGFIX]: #3347 #3351 Fixed QCheckBox in several places, so text() of it is not used as a valid data. This is to address issues with automatic accelerator keys.
  • [BUGFIX]: Addressed some concurrency erorrs in SQLite 2 plugin
  • [BUGFIX]: #3139 #3116 #3326 #3341 Various code compiling issues addressed.
  • [BUGFIX]: #3145 #3165 #3179 Fixed various typos in messages/interface.
  • [BUGFIX]: #3333 Fixed unit test to honor new features of TableModifier, but also fixed few bugs in TableModifier.
  • [BUGFIX]: #3277 Open Source license issues addressed (specific exceptions for OpenSSL and icons)
  • [BUGFIX]: #2966 Application icon added to package.
  • [BUGFIX]: Few other bugfixes made on the fly, while working on other issues.

New in SQLiteStudio 3.1.1 (Nov 4, 2016)

  • [ADDED]: WxSQLite3 plugin (with encryption support).
  • [ADDED]: System.Data.SQLite plugin (ADO.NET, includes encryption support).
  • [ADDED]: Support for "Row Value" introduced in SQLite 3.15.0.
  • [ADDED]: New option in configuration dialog to decide whether you want to keep NULL values when entering empty strings in cells (new, more intuitive behavior), or overwrite NULLs with empty string values (as it used to be so far).
  • [ADDED]: Editor window has now "Find" and "Replace" toolbar buttons for those functions (which were already there, available under shortcuts).
  • [ADDED]: New built-in functions: import(), import_formats(), import_options() and charset(). All described on SQLiteStudio's wiki (at User Manual page).
  • [ADDED]: #3106 ScriptingTcl has now "tcl_init" command to invoke full interpreter initialization, which creates [clock] commands and some others. It's not invoked automatically to avoid performane issues.
  • [ADDED]: #3136 Added "--master-config" command line option to have a settings file (regular SQLiteStudio config file) that all running SQLiteStudio instances import settings from. More details in manual on wiki page.
  • [ADDED]: #3127 Added 'select all' and 'deselect all' buttons in tigger's UPDATE OF columns dialog.
  • [CHANGE]: #3135 Re-enabled possibility to close database list panel (and reopen it from the View menu entry).
  • [CHANGE]: #2901 Automatically generated database name includes full file name, except for the file extension only (unlike before, when it took only a file name up to the first dot).
  • [CHANGE]: #3140 The "generate name automatically" checkbox has been removed. Now the name is generated automatically by default, unless user starts to edit the name manually.
  • [BUGFIX]: #3118 #3124 #2943 Fixed double precision numbers formatting.
  • [BUGFIX]: DbAndroid plugin: Fixed 'adb' automatic detection under Linux.
  • [BUGFIX]: #3126 #3092 Fixed problem with database versions in Android plugin.
  • [BUGFIX]: #3155 Fixed crash when confiriming custom FK value with Enter key.
  • [BUGFIX]: #3094 #3095 Fixed default FK value preselection when tabbing through cells.
  • [BUGFIX]: #3154 Fixed crash when mass replacing token to another token containing initial token.
  • [BUGFIX]: Fixed query generation for "UPDATE" and "DELETE" when invoking it from Database List context menu for the table.
  • [BUGFIX]: Fixed Ctrl+click (Cmd+click on MacOSX) handling of object names that require name wrapping (such as names with spaces in it).
  • [BUGFIX]: #3133 Fixed resolving tables with unusual (like cyrillic) characters in their names.
  • [BUGFIX]: #3096 Restored data editing by Return key hit, that got broken in 3.1.0 for MacOSX.
  • [BUGFIX]: #3122 Several tweaks to Android shell mode connection.
  • [BUGFIX]: #3093 Fixed memory leak in Android plugin.
  • [BUGFIX]: #3132 Fixed column resolving in a View that uses same alias for two different columns.
  • [BUGFIX]: Fixed importing Windows and Macintosh end-line format CSV files (handling rn and r properly).
  • [BUGFIX]: #3134 Fixed recognizing CREATE TRIGGER statements properly when CASE-WHEN-END is used inside.
  • [BUGFIX]: #3112 Fixed Foreign Key editing when the foreign table was modified (for example renamed) and the local column was already presented in the data view.
  • [BUGFIX]: #3113 DEFAULT value is now automatically inserted only when committing NULL for NOT NULL column. Also new option is introduced to use DEFAULT always for NULL values, regardles of NOT NULL constraint.
  • [BUGFIX]: Fixed refreshing database list view when changing labels display settings in configuration dialog.
  • [BUGFIX]: Fixed FormView row navigation shortcuts.
  • [BUGFIX]: #3097 Fixed alphabetical ordering when exporting entire database.
  • [BUGFIX]: Fixed "UPDATE OF" column list formatting (indentation) in Enterprise Formater plugin.
  • [BUGFIX]: Fixed SqlSimpleFormatter plugin to add ";" at the end of CREATE TABLE statements while exporting database schema to SQL format.
  • [BUGFIX]: Data view fonts now apply to other tabs in the table window and view window.
  • [BUGFIX]: #3005 Fixed performance issue with lots of big values loaded into the grid. Also fixed editing those values using the inline cell editor.
  • [BUGFIX]: #2938 Fixed query executor to idenfity properly tables in named subselects, to the ROWID is handled correctly.
  • [BUGFIX]: #3168 Fixed data filter field in data view, so it handles the single quote character.
  • [BUGFIX]: #2942 Erasing table data context menu option now honors multiple table selection.
  • [BUGFIX]: #2900 Optimized execution of thousands of queries at once in SQL editor window.
  • [BUGFIX]: #2934 Table foreign key dialog can now refer to the same table. So far only column dialog constraint for FK could do it.
  • [BUGFIX]: #3120 Performance of SQL editor window greatly increased when working with huge sets if queries (like thousands).
  • [BUGFIX]: #3028 Fixed formatter for "NOT EXISTS" expression.
  • [BUGFIX]: #2990 Fixed handling scientific numbers notation.
  • [BUGFIX]: #2987 Fixed "go to referenced row" function when using multi word object names.
  • [BUGFIX]: #3173 Fixed numerous typos in messages and names.
  • [BUGFIX]: #3178 Fixed pagination for query simple execution method.
  • [BUGFIX]: #3177 Fixed ORDER BY with column numbers, instead of names.
  • [BUGFIX]: #3125 Fixed trigger UPDATE OF columns popup dialog positioning.
  • [BUGFIX]: #3166 Fixed crash when trying to print data.
  • [BUGFIX]: Fixed reading long values of not-editable result columns (like expressions or functions that return long values). They used to be truncated.
  • [BUGFIX]: Compilation fixes.

New in SQLiteStudio 3.1.0 (Sep 23, 2016)

  • [ADDED]: SQLCipher plugin is now free, open source and distributed together with other standard plugins.
  • [ADDED]: #2963 Indexed expressions for CREATE INDEX statements (introduced in SQLite 3.9) are now supported and can be edited in Index Dialog.
  • [ADDED]: View window now supports explicit column names for the view (introduced in SQLite 3.9).
  • [ADDED]: #3056 #3063 Implemented index column ordering in index dialog.
  • [ADDED]: Added shortcut (Ctrl+/ by default) to toggle comment of current line or selected block of code (if any) in SQL editor.
  • [ADDED]: #3040 Added new entry in context menu of data grid to generate SELECT/INSERT/UPDATE/DELETE statement together with WHERE clause containing IN conditions for selected cells.
  • [ADDED]: Added new entry in context menu of database list to generate queries like in #3040 for selected table.
  • [ADDED]: #2975 Information message after successful table/view change.
  • [ADDED]: Introduced "loadByDefault" property for plugin descriptor files.
  • [ADDED]: Added options to have "Data" tab placed as a first tab for Table windows and for View windows. By default option is disabled, so by default nothing changes.
  • [ADDED]: Added option in configuration dialog to avoid reopening status panel for each message printed there.
  • [ADDED]: Added option in configuration dialog to prevent displaying tooltips over data view when user holds mouse over it.
  • [ADDED]: #3070 Added option in configuration dialog to have new databases marked as not permanent by default.
  • [ADDED]: #3070 Added option in configuration dialog to bypass database dialog completely when dropping file from file manager onto database list.
  • [ADDED]: #3013 When double clicking on empty space in list of indexes or tables (in table or view window) the action is not ignored, but a dialog opens for adding new item.
  • [CHANGE]: DbAndroid plugin has now JAR file embedded and you can get it from Tools menu.
  • [CHANGE]: SQLite version updated to 3.13.0.
  • [CHANGE]: Qt version updated to 5.6.0. Should still compile with 5.3, but binary distributions on homepage will be made with 5.6.
  • [CHANGE]: Foreign key dropdown (when editing FK cell) uses now more readable set of columns and column headers can be resized.
  • [CHANGE]: Column dialog validates scale and precision fields (against INTEGER PRIMARY KEY and against each other).
  • [CHANGE]: Structure tab in table window has now fully named headers in column list.
  • [CHANGE]: Table and View window options moved from Look & Feel configuration page to Data Browsing page.
  • [CHANGE]: All database list options moved to a separate Database List configuration page.
  • [CHANGE]: Window list in main menu -> "View" -> "Window list" is not sorted alphabetically.
  • [BUGFIX]: Not loading Android plugin by default (needs manual load from configuration dialog), which stops the "ADB" error for people not using the plugin.
  • [BUGFIX]: #2927 Several critical bugs fixed and enhancements to table modification algorithm related to foreign keys.
  • [BUGFIX]: #2954 #2803 #2937 Fixed incorrect recreation of foreign keys chain.
  • [BUGFIX]: #3008 Editing foreign key cell with more than 10 000 possible values will now use simple text editor, not dropdown. It also loads values asynchronously.
  • [BUGFIX]: Fixed importing from CSV with some of lines containing less fields than defined in header (or in first data row).
  • [BUGFIX]: #2989 Fixed multiline value handling in CSV import plugin.
  • [BUGFIX]: #2921 Fixed empty values as NULL handling in CSV import plugin.
  • [BUGFIX]: #3034 Fixed handling empty string as value for DEFAULT constraint.
  • [BUGFIX]: #3064 Fixed locking database executions when counting rows in huge tables.
  • [BUGFIX]: DbAndroid plugin has fix for null pointer in the JAR when client has disconnected
  • [BUGFIX]: Error message details were missing in some cases (when smart execution method failed at parsing stage). This is fixed now.
  • [BUGFIX]: #3026 #3027 #3043 Fixed RAISE() function formatting in enterprise formatter (used to produce invalid SQL).
  • [BUGFIX]: #3015 Fixed error with DEFAULT constraint containing datetime('now', 'localtime').
  • [BUGFIX]: #3000 Fixed compilation errors for Qt >= 5.5.
  • [BUGFIX]: #2956 Fixed unexpected data refresh when clicking in the right side of value filter field in table window.
  • [BUGFIX]: #2991 #2928 #2929 #2941 #2960 Fixed executing "garbage" query, causing application crash.
  • [BUGFIX]: #2920 Fixed removing several databases.
  • [BUGFIX]: #3068 #3066 Fixed database removal confirmation dialog so the message asks about removing it from the list, not deleting it.
  • [BUGFIX]: #3073 Fixed crash when unloading plugin with its own configuration subpage and saving config dialog.
  • [BUGFIX]: #2931 #2962 Fixed incorrect results when executing 2-level queries with an expression and an alias combination as a result column definition.
  • [BUGFIX]: #2942 Fixed deleting multiple tables/indexes/... when selected them and picked "Delete table/index/..." from context menu.
  • [BUGFIX]: #2945 Fixed manual reordering of database objects with Drag&Drop.
  • [BUGFIX]: #3055 Fixed crash when exporting on MacOS using plugin that requires column value length information (such as PDF export plugin).
  • [BUGFIX]: #3047 Fixed copying/moving tables together with indexes or triggers with Drag&Drop across same SQLite version databases.
  • [BUGFIX]: #3012 SQL simple formatter plugin does not load by default from now on. It is still available, but won't load until manually loaded.
  • [BUGFIX]: Table window for new table (just created) will now properly close when that table gets deleted immediately by the user.
  • [BUGFIX]: #2998 Fixed reading decimal values from database when using simple execution method (a fallback in case of some problems).
  • [BUGFIX]: #2999 Fixed working on objects from database that on the list is named "main".
  • [BUGFIX]: Fixed error detection when selecting column from incorrect table alias (http://forum.sqlitestudio.pl/viewtopic.php?f=11&t=1051).
  • [BUGFIX]: #3046 Fixed scale & precision fields in column dialog so it's possible to delete their values from the column.
  • [BUGFIX]: Vacuum invoked from context menu on database list is now executed in SQL editor and is asynchronous.
  • [BUGFIX]: #3001 Order of objects exported by Export Dialog is now alphabetical (in object type groups).
  • [BUGFIX]: #3022 Fixed parsing of some expressions, resulting in this particular bug report in being unable to browse view results.
  • [BUGFIX]: Enhanced floating point numbers handling.
  • [BUGFIX]: Fixed formatting of INSERT and UPDATE statements.
  • [BUGFIX]: Enterprise formatter no longer puts new lines when formating list of elements in "IN" clause.

New in SQLiteStudio 3.0.7 (Nov 25, 2015)

  • [ADDED]: #2951 Implemented dropdown value picking for foreign key columns in grid view.
  • [ADDED]: Context menu entry to go to row in referenced table by current foreign key cell value.
  • [BUGFIX]: #2875 Fixed font misconfiguration after Qt update.
  • [BUGFIX]: #2879 Fixed View updating after table modification, when view uses SELECT with table alias same as table name.
  • [BUGFIX]: #2885 Fixed tokens parsing, causing random problems, such as incorrect formatting performed by the simple formatter.
  • [BUGFIX]: Fixed preventing of setting null or empty value on query results that don't come directly from table.
  • [BUGFIX]: Fixed duplicates while copying mupltiple lines from status field.

New in SQLiteStudio 3.0.6 (May 12, 2015)

  • This version brings a long-awaited UI lifting which increases space for all data views. Less frame borders and margins, more data visibility! Database list now takes bottom-left corner (instead of bottom panel), making the list longer. This layout if configurable in settings. The SQL editor now saves contents (when using 'Save' action) to the previously saved/opened file, without asking for the file each time. There's also a new option when inserting new data rows to make it inserted above/below current row, or at the end of grid view. Finally, there are lots of bug fixes. More details as always in the Changelog.
  • CHANGELOG:
  • [ADDED]: #2740 Option to configure whether bottom dock area (with status field) should extend to left border, or should it leave space for database list.
  • [ADDED]: #2819 Introduced "compact layout" as an option (enabled by default) to minimize all margins on the interface.
  • [ADDED]: CSS console for SQLiteStudio (under F11 key) to allow customizing all aspects UI look and feel at a low level.
  • [ADDED]: #2805 The 'Save SQL' action in SQL editor now uses the same file if repeated, unless user picks 'select file to save' from drop-down menu.
  • [ADDED]: #2801 Added option to select where to position the new inserted row - above/below selected row, or at the end of data view.
  • [CHANGE]: Database list is by default from top to bottom, making the status field placed next to the database list, instead of being below it.
  • [BUGFIX]: Fixed 'rows affected' counter when using transactions and executing everything at once.
  • [BUGFIX]: Fixed importing from CSV with empty (NULL) values in last column of last data row.
  • [BUGFIX]: #2853 Allow '$' character as a part of an identifier.
  • [BUGFIX]: #2846 Fixed crash when executing query on a database after just removed other database from the list.
  • [BUGFIX]: #2856 Fixed not working updates manual checking if automatic checking was disabled.
  • [BUGFIX]: #2863 Fixed config dialog to honor DbTree presentation options (sorting, labels) immediately, no manual refreshing required.
  • [BUGFIX]: #2862 Fixed loading SQL scripts into editor when using Chinese language.
  • [BUGFIX]: #2855 Automatic updates are now enabled only for portable build and are disabled by default for other builds.
  • [BUGFIX]: #2867 Fixed support for "ISNULL" in query execution.
  • [BUGFIX]: Fixed synchronization bug in DbSqlite2 plugin causing random crashes.
  • [BUGFIX]: Views are recreated after table modification only if they really need to be updated according to the table change.
  • [BUGFIX]: Fixed querying selects with numerous subselects with '*' operators for result columns.
  • [BUGFIX]: #2868 Global configuration directory is not created (even empty) when using portable configuration.
  • [BUGFIX]: #2866 Fixed Search dialog in SQL editor to honor changes of the searched value during the single session of searching.
  • [BUGFIX]: Fixed importing from data source that provides columns with special characters - they are no longer splitted to column name and datatype.
  • [BUGFIX]: Fixed problem with keyboard focus for syntax completer under Gnome 3.
  • [BUGFIX]: #2872 'Enter' key in table name of import dialog now triggers 'Next' action, not clearing the table name.
  • [BUGFIX]: #2864 & #2791 Fixed synchronouse execution in QueryExecutor, which also fixes the misterious bug in export dialog, causing empty files being exported.
  • [BUGFIX]: Fixed encoding detection and connection testing for SQLite2.

New in SQLiteStudio 3.0.5 (Apr 17, 2015)

  • [ADDED]: #2831 Ported 'Erase table data' feature (in table's context menu) from version 2.1.5.
  • [CHANGE]: Data view has now a 'cover' with progress bar when commiting more changes at once. This eliminates weird GUI freeze when commiting lots of new/deleted rows.
  • [CHANGE]: Populate dialog has now progress bar when working.
  • [CHANGE]: Enhanced SQL formatter to format CREATE TRIGGER statements in a bit more readable way.
  • [BUGFIX]: #2838 Fixed outstanding bug causing database file to be deleted if a user tried "Test connection" on the database under Windows.
  • [BUGFIX]: Fixed crash when closing Populate Dialog while populating was in progress.
  • [BUGFIX]: Fixed warning messages when there was a problem with restoring windows from last session. A message contains now window name that caused problem.
  • [BUGFIX]: #2830 Closing database list made impossible.
  • [BUGFIX]: #2829 Fixed support for DEFERRABLE (and related) keywords in foreign keys.
  • [BUGFIX]: #2827 Release a file after import.
  • [BUGFIX]: #2826 Fixed bug in SQL formatter causing 'expr ISNULL' expressions to disappear.
  • [BUGFIX]: #2834 Removed './lib' form rpath for linux non-portable compilation.
  • [BUGFIX]: #2836 Removed termcap dependency, as it was deprecated and no longer required.

New in SQLiteStudio 3.0.4 (Apr 6, 2015)

  • [ADDED]: Import dialog has now "Ignore errors" option, to skip rows that causes problems (constraint violation, wrong column count, etc).
  • [CHANGE]: Enhanced Copy&Paste capabilities of data grid, so copying and pasting internally in SQLiteStudio will not be limited by TSV format (NULL values will be distinguished, tab characters will be allowed in values), only pasting from outside will be affected by TSV limitations.
  • [CHANGE]: "Invalid database" icon changed, so it's no longer confusing with "Connected" database.
  • [CHANGE]: "Databases" panel cannot be closed/hidden anymore.
  • [CHANGE]: Database dialog reorganized to look a bit nicer, db type moved to top, URL browse button for file is now separated to 2 buttons.
  • [BUGFIX]: #2795 XmlExport plugin: Fixed crash that happend in most exports.
  • [BUGFIX]: XmlExport plugin: Fixed column number attribute incrementing for data rows.
  • [BUGFIX]: #2793 SqlEnterpriseFormatter plugin: Fixed formatting queries starting with EXPLAIN and EXPLAIN QUERY PLAN.
  • [BUGFIX]: #2786 Fixed double plugin names in config dialog for built-in plugins.
  • [BUGFIX]: Fixed dead-lock when fixing path for a database that pointed to inexisting file.
  • [BUGFIX]: Fixed data editing for SQL queries joining the same table several times.
  • [BUGFIX]: Fixed "Ctrl+W"/"Cmd+W" shortcut to work every time, not only every second time.
  • [BUGFIX]: Fixed order of window focusing when closing with "Ctrl+W"/"Cmd+W" shortcut.
  • [BUGFIX]: #2797 Database type is no longer disabled when adding existing database file.
  • [BUGFIX]: SqlExport appends Foreign Key (re)enabling pragma at the end.
  • [BUGFIX]: "Maximized" MDI window state is no longer lost after closing last MDI window.
  • [BUGFIX]: #2812 TableModifier is now much smarter about when to recreate triggers and how to do it.
  • [BUGFIX]: TriggerDialog no longer loses "When" field when editing existing trigger.
  • [BUGFIX]: Columns of Indexes and Triggers tabs in Table Window don't shring after refresh anymore.
  • [BUGFIX]: NumPad Enter key also accepts the Code Assistant choice.
  • [BUGFIX]: Fixed drawing items in SQL code assistant, so they no longer are "black on dark blue" when using classic Windows theme.
  • [BUGFIX]: #2790 Fixed hexadecimal literals evaluation in SQL queries.
  • [BUGFIX]: #2804 Fixed querying SQLite 2 database.
  • [BUGFIX]: Fixed executing query like: SELECT * FROM (SELECT * FROM table); - it used to crash.
  • [BUGFIX]: #2798 Fixed crash when restoring DbList group for inexisting database.
  • [BUGFIX]: #2808 Sorting indicators in data grid fixed to point the right direction and got a little bit larger.
  • [BUGFIX]: #2807 Fixed SQL export plugin when exporting whole database without formatting SQL, so the missing semicolons are appended to each DDL.
  • [BUGFIX]: #2806 Fixed table sorting in Export Dialog.
  • [BUGFIX]: #2809 Fixed crash when trying to paste data into data grid with no rows in it.
  • [BUGFIX]: Fixed rolling back of row marked to deletion, if it was previously already marked as edited.
  • [BUGFIX]: #2814 Fixed executing custom SQL function with same bind parameter used multiple times.
  • [BUGFIX]: #2815 Fixed refreshing data pages after adding/deleting rows in grid view.
  • [BUGFIX]: #2820 Fixed parsing 'IN table.column' expression (used to incorrectly assume a 'NOT' keyword to be present, even it wasn't).

New in SQLiteStudio 3.0.3 (Feb 23, 2015)

  • [ADDED]: Added visual validation indicators to DbDialog, so user is informed why the "Ok" button is disabled at the moment.
  • [ADDED]: Russian translation.
  • [ADDED]: French translation.
  • [ADDED]: #2770 Added SQLite 3 version used by application in the Environment tab of the About dialog.
  • [CHANGE]: Language translations located in a separate directory have now higher precedense, than translations compiled in, so it's possible to test updated translations "on the fly".
  • [BUGFIX]: Fixed support for "function(DISTINCT args)" in Enterprise formatter.
  • [BUGFIX]: #2753 Fixed parsing TEMP and IF NOT EXISTS in CREATE TABLE statement.
  • [BUGFIX]: #2755 Fixed error checking for recurrent expression with LIKE/GLOB operator in it.
  • [BUGFIX]: Switched error message from simple method error to smart method error in QueryExecutor to avoid misleading messages.
  • [BUGFIX]: #2760 Fixed marking "unique" in index dialog when opening existing unique index.
  • [BUGFIX]: #2757 Fixed int64 rounding problem.
  • [BUGFIX]: #2767 Fixed NOT NULL dialog in column dialog, so it doesn't convert to UNIQUE.
  • [BUGFIX]: #2763 Fixed possibility of adding 2 same databases to the list.
  • [BUGFIX]: Fixed copying values from Environment tab of the About dialog.
  • [BUGFIX]: #2774 Fixed handling triggers (when modifying table) in foreign tables, triggers referencing table in its subqueries, etc.
  • [BUGFIX]: Fixed executing SELECT in SQLite2 for columns that need wrapping.
  • [BUGFIX]: Fixed editing data for tables transparently attached in the SQL query.
  • [BUGFIX]: Fixed Shortcut titles translation in configuration dialog.
  • [BUGFIX]: Fixed aggregate functions, so initial and final codes are executed, not only the per-step code.
  • [BUGFIX]: #2781 Portable configuration directory can now be either in the running directory, or in applications directory. It's auto-detected.
  • [BUGFIX]: Optimized loading huge data sets into data grid. It's faster and the progress bar acts more smoothly.
  • [BUGFIX]: Shortcut for closing current window is now displayed in the context menu for taskbar.
  • [BUGFIX]: "Skip first line" option in CSV import renamed to "First line represents CSV columns". Maybe this time it won't confused anyone.

New in SQLiteStudio 3.0.2 (Jan 29, 2015)

  • ADDED]: Full support for the interface translations.
  • [ADDED]: Polish translation.
  • [ADDED]: #219, #2711 Reset autoincrement feature to context menu of table and to structure toolbar in table window.
  • [ADDED]: #2715 Added "rows affected" to the execution result message for INSERT/DELETE/UPDATE queries.
  • [BUGFIX]: Fixed deleting column from table that is the only column covered by an index or an "UPDATE OF" trigger.
  • [BUGFIX]: #2703 Fixed compilation errors on GCC 4.9.
  • [BUGFIX]: #2707 Fixed crash when importing CSV file with empty value for last column.
  • [BUGFIX]: Valid objects in SQL editor are now highlighted and are Ctrl+clickable (the feature was there, but was broken and it didn't work).
  • [BUGFIX]: Fixed invalid 'modified' status when focusing out NumberMultiEditor in FormView, resulting in uncommited change on FormView, even there was no change.
  • [BUGFIX]: #2698 Fixed double precision numbers displaying in the Grid View.
  • [BUGFIX]: #2696 Fixed handling foreign keys when the main table was not renamed, just columns changed.
  • [BUGFIX]: #2713 Fixed foreign key actions in Foreign Key dialog, so they are no longer the same for ON UPDATE and ON DELETE, even they were configured differently.
  • [BUGFIX]: #2715 Fixed storing rows affected/selected in SQL Editor history (bug since version 3.0.0 caused "rows" column in SQL history to be always 0).
  • [BUGFIX]: Main window toolbar is updated after creating/deleting database objects (it was not).
  • [BUGFIX]: #2722 Fixed crash when exporting database without data.
  • [BUGFIX]: #2727 Fixed error message when calling SELECT with table from (transparently) attached database and selecting invalid column - message was misleading.
  • [BUGFIX]: #2728, #2729 Fixed DEFAULT constraint dialog, so 1) it works when creating first column for new table, 2) it allows a single word as a default value, even the word is not an explicit string.
  • [BUGFIX]: #2697 Fixed data populate dialog.
  • [BUGFIX]: #2731 Fixed problem with attached databases not detaching after transparent attach in cross-database queries.
  • [BUGFIX]: #2734 Fixed code assistant crash in Trigger Dialog.
  • [BUGFIX]: #2721 Fixed initial selection of database in SQL Editor window, so it's set to the database currently selected in databases list on the left.
  • [BUGFIX]: #2721 Added database name to error message when the SQL query execution failed.
  • [BUGFIX]: #2718 Checkbox in CSV import plugin renamed to "Skip first row of data".
  • [BUGFIX]: Fixed staring edition of data in grid by pressing Enter key.
  • [BUGFIX]: #2745 Fixed crash when ctrl+right_clicking in SQL editor.
  • [BUGFIX]: #2733 Fixed handling of foreign keys when changing table structure.
  • [BUGFIX]: #2749 Fixed handling of function(distinct arg), resulting in incorrect results when executed.
  • [BUGFIX]: Fixed logging SQL queries when --debug-sql is enabled. Queries from query executor were not logged.

New in SQLiteStudio 3.0.1 (Jan 5, 2015)

  • When the data is being read into the Gird View, columns width gets automatically adjusted, so for small values they are shrinked and for bigger values they're enlarged, but never above the configured limit (a new option in config dialog).
  • Implemented support for immediate editing of rows just added to the WITHOUT ROWID tables (previously the manual refresh of data view was required).
  • Fixed support for expressions as DEFAULT value in table.
  • Fixed support under Windows for running portable distribution, while having different version of Qt installed in the system (added the qt.conf file).