SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant version 12.1 released

This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant version 12.1 released
Author Message
Site Admin

Joined: 26 Nov 2006
Posts: 7857

Post SQL Assistant version 12.1 released Reply with quote
Short introduction
Though version 12.1 is released as a maintenance version, as far as its new features go, it's like a new major version. And we are very excited about them. The new personal workspace database feature delivers great productivity boost. This workspace database supports super simple methods for saving the data you work with, and quickly retrieving it later without needing to rerun long running queries again; and then comparing historical results saved over a period of time. It also enables advanced data analytics and data enrichment, across data sources data aggregations, and so on. To illustrate, imagine you're clicking a data grid populated with results of a long running query, selecting "Save to Workspace", and then using SQL queries or other built-in tools to join saved grid results with data from another database, with data from another data grid, or with data from an external CSV file. Version 12.1 delivers a number of other new features and significant enhancements. Here is a complete list of changes:

New database systems and interfaces
1. Support for Apache Cassandra and DataStax Enterprise databases, with full CQL/SQL intellisense, full graphical schema management. Most SQL Assistant tools and features available for relational SQL databases can be used with Cassandra too, including direct data migration to and from other databases.
2. Support for Snowflake databases and warehouses, most SQL Assistant tools and features available for relational databases can be used with Snowflake, including advanced SQL Intellisense, schema compare, data export and import, and so on...
3. Enhanced support for SQLite with new built-in native driver connections enabling use of regular expressions in SQL queries, table and index space usage stats, JSON data handling, attaching external data files as tables, supported by Visual Database Documenter, Schema Compare, and other SQL Assistant tools now enabled for SQLite.

New major features and significant enhancements
4. Personal workspace database, simply put this is the new productivity enhancement that can change how you work with your databases. With a couple of clicks you can now save data grids and results of queries to your personal workspace and then return to them later, query them like other tables, join/enrich with other data, and of course update their data too! We believe this new feature redefines the meaning of productive database development and analytical use. Easily much and mix data from different database, catalog and save query results and more, its your personal database that you can share with others too.
5. Many enhancements in the SQL History. The entire feature has been completely redesigned and now supports storing history for long time, not limited to the current session time; It now supports fuzzy searches and code filtering, enables reusing historical SQL statements across databases, provides more efficient UI with important details shown at the top of the queries and not important details compressed or hidden by default.
6. New and enhanced functions for working with CSV files. You can use the new Data File Query utility to query and update data in CSV files as if they were tables in a relational database using full power of SQL language, regular expressions, transactions, and so on...
7. The new Data File Transformation utility further extends advanced support for CSV files, enabling you to add, remove, modify, and rearrange columns, remove duplicate data, pivot columns and rows, filter using regular expressions, and make other transformational file changes, all that without needing a desktop spreadsheet program.
8. Many small and not so small SQL Intellisense enhancements including but not limited to advanced intellisense for index specific DDL operations, triggers, smarter Intellisense for schema context, suggestions for arguments for built-in database functions, improved JOINs suggestions display differentiating referenced and referencing tables, and more.
9. Improvements in Database Messages pane including new searching and filtering capabilities, integration with SQL History, and so on...
10. Significant changes in how SQL Assistant's Reports handle their queries. You can now use SQL scripts with multiple statements to retrieve the report data.
11. Now supporting data exports to Parquet files.

Database management enhancements
12. All supported databases - the Update Statistics utility is now run in the background, you can continue working while it's updating table statistics in the database.
13. PostgreSQL - Graphical dashboard and session monitors for PostgreSQL now show progress of work of long operations (PostgreSQL 11.x and later).
14. PostgreSQL - enhanced handling of partitioned tables, including but not limited to better SQL Intellisense, scripting DDL for the common table and all its partitions in one atomic operation.
15. PostgreSQL - Top Functions graphical monitor.
16. SQLite - Table and index space usage statistics.
17. Oracle - Graphical partition and subpartition manager.

18. Updated add-ons for Visual Studio 17 and previous versions which now enable using SQL Assistant immediately after the installation and don't require installing additional database specific extensions, like Visual Studio Database Tools or T-SQL Query Editor.
19. SQL Assistant's SQL Editor now preserves BOM in Unicode script files saved with BOM, as well as it can add BOM if such file encoding is selected.
20. SQL Assistant can better support automatic Windows updates and can automatically recover its environment after updates and restarts.
21. A number of other minor improvements.

Here is a link to the list of changes in the previous 12.0 major release
and the cumulative What's new page describing changes in all version 12.x releases.

Last edited by SysOp on Tue May 02, 2023 11:48 pm; edited 2 times in total
Thu Mar 24, 2022 3:54 am View user's profile Send private message

Joined: 29 Jul 2021
Posts: 44

Post Reply with quote

Thanks for the new release.

Unfortunately, I cannot install :

Fri Mar 25, 2022 4:17 am View user's profile Send private message

Joined: 29 Jul 2021
Posts: 44

Post Reply with quote
Ok, I did a full download (not with left-click > check update), but Windows 10 said that the exe is not safe. I continued, and was able to install it.
Fri Mar 25, 2022 4:37 am View user's profile Send private message
Site Admin

Joined: 26 Nov 2006
Posts: 7857

Post Reply with quote
That's because it wants all downloads to be from Windows App Store.
Fri Mar 25, 2022 11:55 am View user's profile Send private message
Display posts from previous:    
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.