Next big item pending is support for the Window Functions. This of course comes with update of SQLite up to the most recent (at this moment) version - 3.34.1. It's a full support, that includes SQL syntax compliance, Constraints Dialog support and proper behavior (refreshing) in the data Grid View and Form View. I just finished working on the 'GENERATED ALWAYS AS' columns support. More and more people complain about this so I decided to push hard on having them in SQLiteStudio. GENERATED columns support added & moved to version 3.3.0.Ī lot of time passed since last release and SQLite has introduced number of syntax incompatible changes. You can download new version either directly from home page or choose other files from GitHub releases page.ĭevelopment update Posted on 04 February 2021 Only portable packages are going to be provided from now, until more suitable installer framework is found & mastered. 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. Installer (Qt's Installer Framework) was removed.It was hardly ever used and was causing a lot of maintenance effort. plugin was removed, as the official library was getting more and more outdated and with new DbSqliteWx plugin version (which can open files) there's no need to continue this plugin.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.Database panel (left-side panel) shrinking all the time - no longer shrinks.Most repeated and irritating bugs that were fixed: 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.Dark theme (Dark Fusion), including native dark theme on MacOS X.User can also load full values for entire column from right-click menu of the column header.

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. Big values handing was significantly improved.DbSqliteCipher plugin upgraded to the most recent version too (which runs SQLite 3.34.0).DbSqliteWx plugin upgraded to use SQLite3MultipleCiphers (SQLite 3.34.1), thus now capable of opening WxSQLite3, SQLCipher and databases (also under Linux & MacOS).This includes UI support for 'generated columns', support for new syntax statements - OVER (Window Functions), UPDATE FROM, VACUUM INTO. It brings update of SQLite to 3.34.1 with all its new features, dark theme, and much more!Īmong many bugs fixed (59) and improvements, here are few outstanding new features and changes: Full changelog is available here.ģ.3.0 released! Posted on 21 February 2021Īfter almost 3 years I'm proud to announce version 3.3.0. New model of translation files (thanks to the Crowdin).Linux binaries are now built on Ubuntu 22.04 (used to be 20.04).Changed F2 hotkey, so it enters inline editing of a cell (no longer it opens the config dialog, which now is under F10 key).Windows i386 (32 bit) binaries are now provided out of the box.Database dialog has now just one browse button, but uses Qt file dialog, not native one.WAL mode is now handled properly upon application quit or database disconnection.Application state (session) is saved (apart from normal application exit) whenever the state changes and also during critical application crash.Added convenient way to increase/decrease font size by using Ctrl+MouseWheel or by (configurable) shortcuts Ctrl + + and Ctrl +.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).Python scripting plugin (alongside of already existing similar Tcl, JavaScript and SQL plugins).RIGHT, FULL OUTER JOIN, IS (NOT) DISTINCT FROM.RETURNING syntax in INSERT/DELETE/UPDATE.

With the upgrade also new features and updated SQL syntax is fully supported: The new installer is driven by the VMware InstallBuilder.

Installer packages are back (while portable packages are still available on GitHub Releases page).

This version brings quite a number of new features, enhancements and updates, but also a lot of bugfixes. 3.4.0 released! Posted on 16 November 2022

Db browser for sqlite dark mode