It's been a while since last update. So... what I was working on?
On this screenshot you can see couple new icons have appeared:
I will tell more about those buttons later on. For now lets have a look at the "Form View" - there are new configuration buttons for each form:
Those buttons let you to define what editors (Text, Hex, Numeric, ...) are used for which data type. There are some predefined editors, but you can always customize them. Pressing the config button opens the main Configuration Dialog on the page, where you configure editors for types:
You can define your own data types and assign editors for them. Editors order can be changed by drag&drop (just move around the editors tab in the config dialog).
Editors are plugin-driven, so there will be editors/browsers with higlighting for XML, displaying PDF, etc. Such plugins are yet to be implemented.
While we're in the configuration dialog, have a look at other configuration pages:
Now, at the first screenshot there is a button with blue arrows pointing outside - it's en exporting feature. Here's the export dialog:
Here's how you export database:
and here's how you define final options for the export (notice the red exclamation icon at the top-left corner of the file entry - it's the new way of SQLiteStudio to tell you that some field has invalid value - when you move cursor over the icon it will tell you what's wrong):
If you export query results, here's how the dialog looks like:
Of course this is a regular SQL editor are in here, so you can use all it's features, like syntax validation, syntax completion, etc:
Now, as you learned, SQLiteStudio got the new form validation notification (the red exclamation icons). Old dialogs got enhanced with it. When you create new column in the table, you select few constraints and some of them require additional configuration, the dialog will tell you that:
Before fixing their configuration, lets have a look how it appears in "Advanced mode":
Okay, lets fix constraint configurations. I'll fix COLLATE here:
You see it even tells which field in COLLATE needs to be fixed. After I fixed all constraint configurations, it looks like this:
Now back to simple mode:
And what about table constraints? Have a look at table's FOREIGN KEY dialog:
Okay. Enough about dialogs and red icons
Lets get back to those new icons I spoke about at the begining. The "fx" icon is for Custom SQL Functions editor window:
The new SQL Function editor also supports aggregate functions:
Another new feature is Collations editor window:
A very important thing that was missing in SQLiteStudio 2.x.x was tracking DDL's being executed on the database. Version 3 has that:
Oh, by the way, it already supports the "WITHOUT ROWID" tables from recent SQLite versions:
..and if you missed the "DDL dialog", or you need a aggregated changes on some database from entire last month - there's a DDL history window:
The most recent work I've done is drag&drop for objects in database tree on the left side:
Currently works only for views and tables, but I also plan to add support for columns in tables. When you drop the object on target database, it shows following options:
It's pretty much the same what was in version 2.1.x, but here it's way more readable to the human being
(the D&D for entire databases was already there since the "Preview 1" - it lets you to change databases order, or organize them in groups/directories).
That's all for now. The application is getting closer and closer to the release, but I'm still not ready to tell the release date. I can tell, that in about 2 months I will tell the release date
But don't worry, it's not that far from now.