Softpedia >Mac >Developer Tools >DtSQL >  Changelog

DtSQL Changelog

What's new in DtSQL 6.7.1

Aug 21, 2017
  • Enhancement:
  • Add tablespace to Oracle database
  • Save script panel automatically if it is changed
  • Selected next script panel if current is closed
  • Selected new added script panel
  • Bug:
  • Building SQL cannot show result

New in DtSQL 6.6.1 (Jul 11, 2017)

  • Enhancement:
  • Show the number of insert/update/delete rows in the result when execute sql
  • Add file extension to exporting file automatically
  • Load last exporting file path
  • Bug:
  • Change the exporting file selecting button to 'Save'

New in DtSQL 6.5.1 (Jun 23, 2017)

  • Enhancement:
  • Prompt to save sql scripts before close
  • Display connection info after db is connected
  • Bug:
  • 'Filter & Sort' does not remove ','
  • Fix oracle constraint script
  • Oracle does not display constrain script

New in DtSQL 6.4.1 (May 20, 2017)

  • Enhancement:
  • Support to change the color of 'Filter & Sort'
  • Add scroll panel for color configuration
  • Improve the performance to free system memory
  • Bug:
  • Fix exporting data issue
  • Correct exporting file existing message

New in DtSQL 6.3.1 (Apr 27, 2017)

  • Enhancement:
  • Improve table data fetching performance
  • Improve exporting data performance
  • Add tab tips to sql result
  • Pop up time picker when edit table date cell
  • Bug:
  • Database disconnection causes script panel refresh issue

New in DtSQL 6.2.1 (Apr 3, 2017)

  • Enhancement:
  • Scroll to selected row after data is updated or refreshed
  • Upgrade attached jdbc jar files
  • Bug:
  • Oracle date update issue
  • Exporting SQL result does not match the select database connection
  • Set current timestamp issue

New in DtSQL 6.1.1 (Jan 30, 2017)

  • Enhancement:
  • Improve performance to close DtSQL
  • Enable search function in components like script and table
  • Cache the location of last open file/folder
  • Load script content of last exit
  • Receive enter event to do search
  • Bug:
  • Save the changes of Oracle timestamp
  • Change export file button

New in DtSQL 5.6.1 (Dec 12, 2016)

  • Enhancement:
  • Improve auto complete performance
  • Improve exporting data performance
  • Provide information for each 10000 exporting records
  • Show table loading status
  • Bug:
  • Fix the issue if sql end with semicolon

New in DtSQL 5.5.1 (Nov 18, 2016)

  • Enhancement:
  • Support max rows in exporting table data
  • Support export data of multiple SQLs
  • Shows last record in the log panel
  • Bug:
  • Applied table filter does not work after the connection name is changed
  • Connection panel does not show selected connection after name is changed.

New in DtSQL 5.4.1 (Oct 19, 2016)

  • Bug:
  • Only one connection node can show its color panel
  • SQL Script does not workif it is end with mixed (r n and rn)
  • Oracle number values show in double format
  • Fix Oracle dup column info
  • Fix Oracle saving changed data

New in DtSQL 5.3.1 (Sep 2, 2016)

  • Enhancement:
  • Change SQL script break to blank row
  • Enable to show script of the SQL result
  • Enable to set different color for DB connections
  • Bug:
  • Show selected table when import data from file

New in DtSQL 5.2.1 (Jul 1, 2016)

  • Enhancement:
  • Enable sort connection nodes
  • Provide package body for Oracle DB
  • Provide type body for Oracle DB
  • Bug:
  • Fix the issue to display Oracle package script
  • Fix the issue to display Oracle type script

New in DtSQL 5.1.1 (Apr 16, 2016)

  • Enhancement:
  • Click db search result to show selected db object
  • Enhance oracle supported data types
  • Bug:
  • Update the numberic value if table is in unformatted pattern
  • Filter & sort does not work in some oracle table
  • UPdated values cannot be save in Oracle

New in DtSQL 4.1.1 (Mar 28, 2015)

  • Enhancement:
  • Improve the performance to free memory
  • Bug:
  • Keep the button to add new sql editor after close all sql editors

New in DtSQL 4.0.1 (Feb 17, 2015)

  • Bug:
  • Merge same SQL prompt variables
  • Skip commented out SQL prompt variables
  • Correct production updating version
  • Save preference value if any is updated

New in DtSQL 4.0.0 (Dec 27, 2014)

  • Enhancement:
  • Support call oracle and postgres procedures and functions
  • Request 20-day trial license online by valid email address
  • Update SQLite jar file
  • Bug:
  • Procedure/function parameters are not loaded properly
  • File name is not added to new SQLIte connection URL
  • Disable loading action if the table is being loaded
  • Trial license expired issue

New in DtSQL 3.9.2 (Dec 2, 2014)

  • Enhancement:
  • Enable to select specified variable in variable bound function
  • DB2: show Java stored procedure script
  • Bug:
  • Variable bound does not work if variable is within parentheses

New in DtSQL 3.9.1 (Nov 6, 2014)

  • Enhancement:
  • Enable to add new SQL Editor in the tab like IE
  • Enable to change memory size
  • Add SQL variable bound prompt function
  • Recycle memory when application is free
  • Bug:
  • Disable result tool bar setting value button if table is not editable

New in DtSQL 3.8.2 (Oct 15, 2014)

  • Enhancement:
  • Oracle: add table partition, subpartition, statistics
  • Oracle: add Clusters, DB Links, Jobs, Types, Packages, Queues, Queue Tables and Rules,
  • MySQL: add table partition & statistics, Collation, Engine, Status and Variable
  • Bug:
  • Oracle: synonym node link
  • Format error message

New in DtSQL 3.8.1 (Sep 27, 2014)

  • Enhancement:
  • Search database objects
  • Bug:
  • Selected db object node is reset if a new db object is created
  • Index creating panel does not show selected table node information
  • Change column data type in table altering panel
  • Connection searching field does not show properly in Linux
  • Exporting data panel does not show column name properly
  • Exporting data panel does not show configuration properly

New in DtSQL 3.7.2 (Sep 6, 2014)

  • Enhancement:
  • Show message if try to export MongoDB data to SQL file.
  • Bug:
  • MariaDB : display users
  • MongoDB : exporting record count is not correct
  • MongoDb : imports data to table
  • The column width value is reset after tab switched if importing data format is 'fixed col width'

New in DtSQL 3.7.1 (Aug 25, 2014)

  • Enhancement:
  • Support new database MariaDB
  • Bug:
  • MongoDb: add new column if the table only has one column
  • MySQL: add new record to the table if it has primary ke

New in DtSQL 3.6.2 (Aug 11, 2014)

  • Enhancement:
  • Enable the panel to import data to tables
  • MongoDb: add new column, import data to table
  • Bug:
  • MongoDb: add new column to a new new table
  • MongoDB: fail to 'test' after the new connection is added

New in DtSQL 3.6.1 (Jul 28, 2014)

  • Enhancement:
  • Support new database MongoDB
  • Enhance DtSQL look and feeling

New in DtSQL 3.5.1 (Jul 2, 2014)

  • Enhancement:
  • Alert Table: rename table/columns, change column data type, add/drop constraints/indexes
  • Create table: enable deleting selected new columns
  • Bug:
  • Index DDL tabs do not show script properly

New in DtSQL 3.4.3 (Apr 26, 2014)

  • Enhancement:
  • Upgrade JRE to version 1.7.0 on Windows & Linux systems
  • Upgrade DB2 JDBC driver jar file
  • Bug:
  • Table DDL tab does not show script properly

New in DtSQL 3.4.2 (Apr 11, 2014)

  • Enhancement:
  • Add new option to refresh table result automatically
  • Enhance function to export single table/mutiple tables/SQL
  • Bug:
  • Export sql result to CSV file

New in DtSQL 3.4.1 (Mar 24, 2014)

  • Enhancement:
  • Right click the tab to close/close others/close all sql result/sql editors
  • Add new tool buttons to load executed SQL to editor
  • Support exort data to PDF file
  • Bug:
  • Automatic completion can not recognize the word after backspace
  • Copy/Paste hot key in SQL Editor do not work
  • Prompt dialog is not popped up if the SQL editor is closed

New in DtSQL 3.3.1 (Mar 3, 2014)

  • Enhancement:
  • Support drop and open file in SQLEditor
  • Support quoted schema and table names in automatical completion
  • Bug:
  • Editor automatic completion does not list selected table columns properly
  • SQL Editor does not show file name properly
  • SQL Editor does not show SQL execution log properly

New in DtSQL 3.2.1 (Feb 24, 2014)

  • Enhancement:
  • Set the editor title name to selected database name
  • Support add/close multiple SQL editors
  • Support quoted table name in editor automatic completion
  • Bug:
  • Editor automatic complate does not list all matched alias table columns
  • SQL Editor Home/End key does not work properly
  • First line in the selected block is not commented

New in DtSQL 3.1.1 (Feb 10, 2014)

  • Enhancement:
  • Support export Binary/Blob to file
  • Support import file data to table Binary/Blob/Clob column
  • Improve automatic completion function
  • Improve table data exporting functions
  • Show log information if there is no executing result returned
  • Log sql executing and result fetching time
  • Bug:
  • PostgreSQL: auto completion does not show table column name properly

New in DtSQL 3.0.2 (Jan 4, 2014)

  • Enhancement:
  • Support SQLServer 2008
  • Add ew option to enable page function
  • Improve the result loading performance
  • Add sequece DDL : postgresql, db2
  • Db2: add Global Temporary Tables
  • Add row count for tables & views
  • Show the information tab if any database object is selected
  • Building SQL : enable select two table columns for select
  • Bug:
  • Db2 : Alias display issue
  • PostgreSQL: User name display issue

New in DtSQL 3.0.1 (Dec 27, 2013)

  • Enhancement:
  • Bug - Error on automatical version update

New in DtSQL 3.0.0 (Dec 14, 2013)

  • Enhancement:
  • Provide first official release and free version
  • Enable to load the table next page records
  • Create a new thread to load ER-Diagram
  • Format selected SQL text : SQLEditor->Right Click to Pop Menu->Format Selected SQL
  • Show loading status while the SQL is executing
  • Bug:
  • DB2: fix building SQL issue for specific table names
  • MySQL: show table information

New in DtSQL 2.11.1 (Oct 14, 2013)

  • Enhancement:
  • Add uncomment line function
  • Enable inverse row selection on result grids
  • Search Column Names (columns will be selected if the column names are matched)
  • HSQLDB: add grant for table columns
  • DB2: add grant for indexes, functions, procedures, sequences
  • MySQL: add grant for table columns
  • PostgreSQL: add grant for table columns and functions
  • Bug:
  • Issue to add constraints for an existing table

New in DtSQL 2.10.2 (Sep 30, 2013)

  • Enhancement:
  • Provide SQL executing time
  • New option is added to table popmenu to show executing SQL
  • Keep the processing circle always on the top
  • Bug:
  • The 'explain select' does not work properly in the SQLEditor
  • If the query is too large, the cross button (to close that result tab) is not visible
  • Application has to be restarted if Auto complete hot key is changed
  • Import tool doesnot work properly in SQLSErver 2008

New in DtSQL 2.10.1 (Sep 17, 2013)

  • Enhancement:
  • Support explain/analyze plan SQL
  • Support export schema table, view, index, trigger, procedure and function DDLs
  • Add new function in table popmenu to select entire column
  • Mimer: enable display data banks
  • MySQL: enable display schedule events
  • Create seperated SQL editor
  • Populate the selected text to the searching panel
  • Bug:
  • Replace all function does not work properly
  • Table create & drop statements are not included in the export SQL data file.

New in DtSQL 2.9.1 (Sep 3, 2013)

  • Enhancement:
  • Register hot key (Ctr+W) for 'execute current'
  • Provide 2 options to copy selected table data : "copy rows" (Ctr+C) and "copy rows with headers" (Ctr+Shft+C).
  • Provide memory usage indicator
  • Add new button to call garbage recycle
  • Create seperated SQL editor
  • Pop up individe result table for each SQL
  • Show table/view grant information
  • Provide new tab panel to show table information
  • Provide new tab panel to show table/view DDL
  • Bug:
  • Table column sorting function does not work properly
  • HSQLDB does not show view DDL correctly

New in DtSQL 2.8.1 (Jul 30, 2013)

  • Enhancement:
  • Add ( Ctrl + Enter ) to execute current SQL
  • Add new function to change the key to execute SQL and trigger SQL Editor Auto Coplete. (Prefererences->Key)
  • Add new buttons to convert SQL Editor characters to lower case and reverse
  • Add 'Goto Line' button in SQL Editor
  • Add line number to DDL text area (trigger, procedure, function and so on)
  • Add loading progress while copying selected table data
  • Cache and save each table filter and sort sql
  • Add 'Reset' button to 'Filter & Sort' panel
  • Support export system information
  • Bug:
  • 'Replace' does not show the changed characters in SQL Editor
  • View script is not formatted and showed in one line
  • MySQL does not show view in information schema
  • Db2 does not show procedure DDL

New in DtSQL 2.7.1 (Jul 6, 2013)

  • Enhancement:
  • Code completion on database name, table name, column name,function name (Ctrl + W)
  • Add built-in database HQSQLDB without any configuration
  • Click table line number to select the whole row
  • Click table top corner to select all table rows
  • Bug:
  • Sort records in table by column name

New in DtSQL 2.6.1 (Jun 24, 2013)

  • Enhancement:
  • Support filter data object tree
  • Support filter table data
  • Support insert Blob/Binary data from files
  • Bug:
  • Insert new record row and duplicate record row

New in DtSQL 2.5.1 (May 23, 2013)

  • Enhancement:
  • Provide new panel to insert index
  • Provide new panel to insert trigger
  • Display database catalog for H2 and HSQLDB
  • Provide new panel to insert constraint (primary key, foreigh key, check and unique constraint)
  • Bug:
  • Dtsql batch file does not load correct JRE
  • Popmenu on two different database shows the same content

New in DtSQL 2.4.1 (Apr 30, 2013)

  • Enhancement:
  • Support creating index, trigger and constraint in table creating function
  • Moved creating connection item to the first one of the pop menu
  • Display database catalog for H2 and HSQLDB
  • Prompt to create a new database connection if there is no connection
  • Provide the link to User's Guide in the first installtion
  • Provide help on how to create database connection and where to download JDBC jar files
  • Bug:
  • Table tool bar buttons are not set properly before table data is displayed
  • FireBird : display table and view information
  • Column default value does not work in creating new table
  • PostgresSQL : referenced keys are not correct in the foreign keys
  • Creating table : the not-null is not selected when primary key option is select

New in DtSQL 2.2.1 (Mar 25, 2013)

  • Feature:
  • Copy the table in the same database
  • Display and edit table records in the same panel
  • Bug:
  • Importing data for table does not show the right table name in the populating panel.
  • Error to insert multiple records in MySQL
  • The sensitive value can be found in Table data search
  • Db2 receives error when creating table with enhanced parameters

New in DtSQL 2.1.1 (Feb 19, 2013)

  • Feature:
  • Support free version
  • Bug:
  • Error in creating DB2 table
  • Error in importing data to DB2 table
  • Enable save button after table data is changed