Softpedia >Windows >Internet >Servers >Database Utils >Sqlectron >  Changelog

Sqlectron Changelog

What's new in Sqlectron 1.37.1

Aug 16, 2021
  • Bug Fixes:
  • Fix crash on startup due to missing dependency

New in Sqlectron 1.37.0 (Aug 16, 2021)

  • Features:
  • Added support for using connection URI in server form
  • Added menu item / keyboard shortcut to auto-format queries in editor
  • Bug Fixes:
  • Fixed running sqlectron with NODE_ENV=development set
  • Fix server validation not showing errors in the UI
  • Fixed color of text in server list when using dark mode
  • Developer:
  • Convert collapse-icon , log-status, loader, and confirm-modal components to TypeScript
  • Add storybook to allow mocking components outside of electron app
  • Upgrade react-tabs, redux, react-select, react-router, and webpack modules
  • Move to npm lockfile v2 format

New in Sqlectron 1.36.0 (Apr 3, 2021)

  • Features:
  • Added option to use ssh connections with ssh agent
  • Bug Fixes:
  • Fixed ssh private key connections for new open ssh format keys

New in Sqlectron 1.35.0 (Feb 23, 2021)

  • Features:
  • Add "save as" menu item for saving queries into new file (thanks @lucaxchaves)
  • Bug Fixes:
  • Add some padding around config path in settings menu
  • Developer:
  • Use electron-devtools-installer to add React / Redux extensions to electron when running in development mode
  • Build:
  • Remove sh build target as it is unsupported by electron-builder

New in Sqlectron 1.34.0 (Feb 17, 2021)

  • Features:
  • Use same filename for saving after opening a file (thanks @sami-sweng)
  • Bug fixes:
  • Properly utilize the automatic limit setting
  • Fix table menu items (e.g. columns, indexes, etc.) being colored lightgray if they had items and black otherwise
  • Fix mutation of query results when copying / exporting to CSV
  • Fix changing the log level setting (still requires app restart to take hold)
  • Dependencies:
  • Update react-router from ^3
  • Update react-virtualized to ^9
  • Update react to ^16
  • Update eslint to ^7 (and also update eslint extensions)
  • Update sqlectron-core to 9.0.3

New in Sqlectron 1.33.0 (Jan 24, 2021)

  • Features:
  • Add keyboard shortcuts for zoom controls - thanks @samuelgrf
  • Dependencies:
  • Update react-resizable to 1.11.0
  • Update brace to ^0.11.0
  • Update sqlectron-core to 9.0.0
  • Update cross-env to 7.0.2
  • Update csv-stringify to 5.5.1
  • Update jointjs to 2.2.1
  • Update react-ace to 7.0.5
  • Update react-draggable to 3
  • Update react-redux to 5.1.2
  • Update redux-logger to 3

New in Sqlectron 1.32.1 (Nov 11, 2020)

  • Fix query results not re-rendering if field information did not change
  • Fix opening select boxes changing modal top location (
  • Fix the open/save query functionality

New in Sqlectron 1.32.0 (Sep 23, 2020)

  • Fixes:
  • fix tabs stacking on top of each other (#519) - by @MasterOdin
  • fix zoom factor in settings showing NaN on first start (#518) - by @MasterOdin
  • use default database for testing connections (#520) - by @MasterOdin
  • Add missing comma for viewport html options (#513) - by @MasterOdin
  • Fix react style key to be camelcase (#517) - by @MasterOdin
  • Build:
  • Bump electron to 8.2.5 (#501, #515) - by @MasterOdin
  • Bump react-select to ^1.3 (#505) - by @MasterOdin
  • Bump webpack loader versions (#506) - by @MasterOdin
  • Use .gitattributes file to normalize line endings to lf for all platforms (#508, #511) - by @MasterOdin
  • Bump electron-builder to 22.8.0 (#507) - by @MasterOdin
  • Fix quotes in npm run script for windows usage (#512) - by @MasterOdin
  • Condense separate dev and prod webpack configs into single file (#519) - by @MasterOdin
  • Build 32-bit releases for Linux and Windows for releases (ebbc059) - by @MasterOdin

New in Sqlectron 1.31.0 (Jul 30, 2020)

  • Add option to list connections instead of rendering cards (#425) - by @barneydmedia
  • Allow custom UI fonts (#330) - by @barneydmedia
  • Single clicking table name runs a default query - by @barneydmedia
  • Fix NaN error on zoomFactor label on first startup (#457) - by @barneydmedia
  • Fix query results error if no custom font is set (#470) - by @rathboma
  • Move from Travis / appveyor to GH actions for CI (#492) - by @MasterOdin
  • Update node-sass to 4.14.0 (#486) - by @MasterOdin
  • Update axios to 0.19.2 (#489) - by @MasterOdin
  • Update electron-builder to 21.2.0 (#491) - by @MasterOdin
  • Add MariaDB to server type dropdown (functionally equivalent to selecting MySQL) - by @MasterOdin
  • Update sqlectron-core to 8.1.1 (#484) - by @MasterOdin
  • Add cassandra authentication support - by @MasterOdin
  • Support MySQL caching_sha2_password authentication (default for MySQL 8) - by @MasterOdin
  • Add official support for MySQL 8 - by @MasterOdin
  • Add official support for PostgreSQL 12 - by @MasterOdin
  • Add official support for cassandra 2.x and 3.10+ - by @MasterOdin
  • Add official support for MariaDB 10.1+ - by @MasterOdin
  • Fix regression on querying information_schema tables on MySQL 8 - by @MasterOdin
  • Fix not being able to specify socket without a port - by @rathboma - by @MasterOdin
  • Use ordinal_position to order column listing for all postgres, mysql, and sqlserver - by @MasterOdin
  • Fix truncateAllTables for sqlserver not working with foreign key constraints - by @MasterOdin
  • Fix sqlserver breaking if using CS collation - by @MasterOdin

New in Sqlectron 1.30.0 (Sep 6, 2018)

  • jQuery security updates - #424 @eMerzh
  • Add Option to Disable Splash Screen - Issue #426 @barneydmedia
  • Add Option for Custom CSV Characters - #301 @barneydmedia

New in Sqlectron 1.29.0 (Jan 4, 2018)

  • Save button on settings modal sets isLoaded to undefined
  • Dark theme for body element
  • Password reveal, fixes
  • Remove redundant text
  • Change zoom factor control to slider, fixes
  • Fixes issue with newly created or duplicated items cannot be editted-
  • Dark Theme Improvements

New in Sqlectron 1.28.0 (Nov 25, 2017)

  • Prevent drag and drop causing redirect (#388) - by @haivp3010
  • Fix re-rendering results table when sidebar width changes (#395) - by @s-kem
  • Add collapse to sidebar (#380) - by @haivp3010
  • Fix connection reload (#394)

New in Sqlectron 1.27.0 (Oct 23, 2017)

  • Added posibility to export on csv or json file #301 (#366)
  • Fix CSV export (#368)
  • Fix encrypt decrypt #369 (#370)
  • Added checkbox to toggle wrapping in query editor (#298) (#373)

New in Sqlectron 1.26.0 (Oct 14, 2017)

  • Improvements:
  • Allow searching database items by their schemas (#355)
  • Grouping database items under schema dropdowns (#356)
  • Made resize span for database full height, changed cursor (#359)
  • Add settings modal (#358)
  • Make clear the Database and Schema is the initial one used in the conn (#360)
  • Print app version in the command line (caveats) (#362)
  • Fixings:
  • Preventing each query tab from unmounting to persist state on tab-switch (#353)

New in Sqlectron 1.25.0 (Aug 28, 2017)

  • Improvements:
  • Use XDG basedir spec on linux #327
  • Fixed bugs:
  • Ignored passphrase for private key for SSH #331

New in Sqlectron 1.24.0 (Aug 21, 2017)

  • Improvements:
  • Allow use the right common path for configuration files - https://github.com/sqlectron/sqlectron-gui/blob/master/docs/app/configuration-file.md#configuration-file

New in Sqlectron 1.23.0 (Aug 7, 2017)

  • Improvements:
  • Added open query from file option (#223)
  • Fix bugs:
  • Fix #296 - sidemenu resizing

New in Sqlectron 1.22.0 (Jun 22, 2017)

  • Fallback for rowCount to PG 8.x
  • Use a File Path Dialogue Window to add a local Database for SQLite (#325)

New in Sqlectron 1.21.0 (Jun 2, 2017)

  • Improvements:
  • Improve security by encrypting passwords on ~/.sqlectron.json
  • Fix bugs:
  • ExecutingQueries[queryId].execute is not a function
  • An error dialog is displayed when user presses super+w and no window exists
  • Add missing custom configuration for auto complete

New in Sqlectron 1.20.2 (Feb 13, 2017)

  • Fix custom server filter been removed on editing the server
  • Include windows support build with 7z and zip

New in Sqlectron 1.20.1 (Jan 28, 2017)

  • Fix config not been created
  • Fix connection with passphrase closing right after connecting
  • Fix bit column values for mysql

New in Sqlectron 1.20.0 (Jan 27, 2017)

  • New Features/Improvements:
  • Add support for logging
  • Add doc about the configuration file
  • Add a default port for SSH
  • Fixed Bugs:
  • Overwrite reload shortcut without global settings
  • Fix passphrase not been saved and used for connection
  • Fix input files not respecting the disabled state

New in Sqlectron 1.19.0 (Jan 22, 2017)

  • NEW FEATURES/IMPROVEMENTS:
  • :Add SQLite support and update builder settings
  • Add schema support for the tables, views, triggers and connection (by @eMerzh and @maxcnunes)
  • Add support for schema in autocomplete (by @eMerzh)
  • Add additional keybinding (Ctrl/Cmd-R) to execute query #278 (by @blakek)
  • Add doc of how to pronounce sqlectron
  • Load config only once
  • Add support to set the zoom factor (check out the .sqltectron.json below)
  • Show info when there is duplicated columns
  • Add support to filter the schema and databases loaded in the sidebar (check out the .sqltectron.json below)
  • FIXED BUGS:
  • Fix disconnect from sqlserver
  • Remove max length from most server fields

New in Sqlectron 1.18.0 (Jan 22, 2017)

  • New Features/Improvements:
  • Add support for listing indexes
  • Fixed Bugs:
  • Fix devtools shortcut -
  • Fix connection problem with old PG versions

New in Sqlectron 1.17.0 (Nov 7, 2016)

  • New Features/Improvements:
  • Allow to cancel queries while are running
  • Add support to set the Windows domain (sqlserver)
  • Change bg color for current and connected dbs
  • Makes clearer the metadata for db still loading
  • Fixed Bugs

New in Sqlectron 1.16.0 (Oct 25, 2016)

  • New Features/Improvements:
  • Replace the database name by the Connection name with the DB logo
  • Display ssh configuration only if checked to unclutter the screen
  • Add visual distinction to indicate if there are items below
  • Change disconnect icon to poweroff
  • Add new tab button
  • Add 'via' in the server list to make distinction with ssh
  • Allow press 'escape' to exit modal.
  • Allow press 'enter' to submit promp modal like passphrase and all
  • Show more error context
  • Simplify the tab names
  • Add horizontal scroll for tabs list
  • Improve docs
  • Add support to rename tab
  • Fixed Bugs:
  • Fix uncontrolled to controlled fields
  • Avoid enabling the "test" connection if no db type is selected
  • Fix warning about null input and fix style
  • Fix closing connection for a test connection
  • Add refresh for views when refreshing the database
  • Style fix trying to unblur retina render.
  • Server can be saved now without a password or user
  • Fix problem wiping part of the query
  • Upgrade react-router to remove deprecated warnings
  • Fix resizable componet warn about onResize event
  • Ignore html2canvas from webpack parse
  • Auto scroll tabs on closing a tab
  • PS:
  • In this version has been included support to horizontal scroll in the tabs. The current implementation has a lot of edge cases to be improved. But since we are discussing in maybe replacing the tabs with list #252 I'm releasing it as it is so we can get some feedback.

New in Sqlectron 1.15.0 (Sep 6, 2016)

  • Add meaningful names to tabs (#214)
  • Instead of naming File Query . It now will follow the this pattern:
  • [db: ][tb: ] #

New in Sqlectron 1.14.0 (Sep 6, 2016)

  • Add support to show EXPLAIN command result for PG

New in Sqlectron 1.13.0 (Aug 22, 2016)

  • Add support for Cassandra DB. Take a look here what this support covers.

New in Sqlectron 1.12.0 (Jul 21, 2016)

  • Use custom scrollbars #208
  • Fix window title name

New in Sqlectron 1.11.3 (Jul 19, 2016)

  • Fixed:
  • Unnecessary scrolling on query results #207

New in Sqlectron 1.11.2 (Jul 11, 2016)

  • Doesn't show scrollbar on header any more, fix height for one or multiples rows - by @plandevida
  • Add support for Linux 32 bit