Skip to content

Releases: ernstc/SqlDataInspector

October 2024 Release (version 0.8.1)

13 Oct 14:20
Compare
Choose a tag to compare

New Features

  • Now is possible to adjust the height of the Rows area using drag and drop. #27 @ernstc

August 2024 Release (version 0.8.0)

23 Aug 20:39
Compare
Choose a tag to compare

New Features

  • Added support for MySQL databases #22. @ernstc
  • Added support for PostgresSQL databases #6. @ernstc
  • Ordering distinct values by Count or by Value does a reorder in place without reloading data from the database #23. @ernstc
  • Removed loader spinner thanks to the new mechanism of query execution tracking. @ernstc

Fixes

  • Minor fixes

January 2024 Release (version 0.7.2)

05 Jan 17:17
Compare
Choose a tag to compare

New Features

  • Added extension settings that will let the user to customize the extension behaviour. @ernstc
  • Columns ordering can be changed from the extension settings. Until now the columns have been ordered alphabetically by default. From now on, the default ordering will be the ordinal ordering, but from the settings is possible to enable the alphabetical ordering. It is also possible to choose if the primary key columns must be shown as first columns. #21 @ernstc
  • Columns ordering can also be changed by clicking on the header of names column. This overrides the settings, but once enabled, can be disabled repeating the click on the header until the sorting icon disappears. #21 @ernstc
  • The status of some controls is now persisted in the extension settings. The persisted controls are: page size, show tables, show views, live monitoring refresh rate. @ernstc

Fixes

  • Fixed behaviour when changing the page size when no object has already been selected. @ernstc

October 2023 Release (version 0.7.1)

13 Oct 11:59
Compare
Choose a tag to compare

Changes

  • Added column information such as nullability (indicated with a question mark "?"), size and precision #19. @hjvdwijk
  • Added new feature for copying all the values of the selected column and their corresponding counts. Copied values can be pasted on Excel for further analysis. @ernstc
  • The filters panel is now collapsible. This makes the usage of the workspace area more efficient when no filters are defined. @ernstc
  • Values for columns of type date, datetime, datetime2 and datetimeoffset are sorted descending by default. This can be useful for monitoring columns with datetime for creations, updates and similar. @ernstc

Fixes

  • Fixed a bug in the live monitoring that was preventing the data from refresh #18. @ernstc

September 2023 Release (version 0.7.0)

26 Sep 21:41
Compare
Choose a tag to compare

Changes

  • Added "Inspect data" menu item in the context menu of the editor. This menu item starts the extension showing immediately the object corresponding to the selected text in the editor #17. @hjvdwijk
  • Added server name to header. @hjvdwijk
  • Added selected table/view name to header. @ernstc
  • Improved visualization of geography and geometry columns #13. @ernstc
  • Implemented the filter by name on the list of tables/views #12. @ernstc
  • Improved performance during objects filtering avoiding to query the database for refreshing the list. @ernstc
  • Columns of type binary|text|image|geography|geometry|variant|xml|json now show the count of NULL and NOT NULL values in the "Distinct Values" section. Before this update no values where shown because these type of columns have not been considered for distinct values selection. @ernstc
  • Requires Azure Data Studio >= 1.45.0 @hjvdwijk

Fixes

  • Fixed some theme color issues. @ernstc
  • Disabled ordering of columns of type xml. @ernstc
  • Updated dependecies with security warnings. @hjvdwijk
  • Fixed ESLint warnings. @hjvdwijk
  • Fixed markdownlint warnings. @hjvdwijk

May 2022 Release (version 0.6.0)

23 May 19:00
Compare
Choose a tag to compare

Changes

  • Added visualization of Views #8.
  • Added pagination in the rows data visualization.
  • Added sorting by column in the table rows #5.
  • Primary key columns are shown in bold

Fixes

  • Minor fixes

February 2022 Release (version 0.5.0)

01 Feb 02:14
Compare
Choose a tag to compare

Changes

  • You can filter tables by schema.

Fixes

  • Fixed vulnerabilities.

September 2021 Release (version 0.4.0)

23 Sep 19:31
Compare
Choose a tag to compare

Changes

  • Added rows count in the tables list.
  • Added live monitoring mode for periodically refreshing the views.

Fixes

  • The list of tables does not shows anymore system tables like dbo.__RefactorLog.
  • Fixed filtering on columns with numbers with decimal digits.

July 2021 Release (version 0.3.0)

13 Jul 00:25
Compare
Choose a tag to compare

Changes

  • Distinct Values have a new column that shows the count of the value occurrences.
  • The columns in the Distinct Values section can be sorted ascending or descending.

Fixes

  • Fixed a bug that caused opening the connection to the default database in case the connection is configured for connecting to a server and not to a specific database.
  • Fixed loading indicator.
  • Fixed filter columns with text.

May 2021 Release (version 0.2.0)

04 May 23:14
Compare
Choose a tag to compare

Changes

  • The tool is now available from the Database or Server context menu using the menu item "Inspect data" and no more from the dashboard tab. This let to maximize the working area.

Fixes

  • When switching between panels and then going back to the inspect panel the page used to become completley blank. Now the view maintains its state.
  • Fixed filtering on columns of type time, date, datetime2, datetimeoffset.