IMPORTING CSV INTO SQLITESTUDIO UPDATE
IMPORTING CSV INTO SQLITESTUDIO FULL
IMPORTING CSV INTO SQLITESTUDIO PORTABLE

These are big milestones, I decided to bump next SQLiteStudio release version to 3.3.0 (instead of 3.2.2). Next big item pending is support for the Window Functions.

IMPORTING CSV INTO SQLITESTUDIO UPDATE

This of course comes with update of SQLite up to the most recent (at this moment) version - 3.34.1.

IMPORTING CSV INTO SQLITESTUDIO FULL

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

IMPORTING CSV INTO SQLITESTUDIO PORTABLE

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: 3.3.0 released! Posted on 21 February 2021Īfter almost 3 years I'm proud to announce version 3.3.0.

Importing csv into sqlitestudio