sqlectron-gui

Features

• Sign and notarize builds for macOS

Bugfixes

• Fix bug where switching tab causes loss of editor focus (#687, #690) (thanks @synle)
• Fix clicking on link to docs from config modal

Dependencies

• Update to sqlectron-db-core to 0.11.0 (includes update to underlying ssh library to support more protocols)
• Migrate from redux to @redux/toolkit
• Use regular lodash over per method installations
• Update classnames to 2.3.1
• Update to react-ace 9.4.4 (#683) (thanks @tomch3ng)
• Migrate from node-sass to sass

Developer

• Fix hot module reloading
• Use port 9000 for webpack server
• Migrate much of remaining JS code to TS

Bug Fixes

• Fix crash on startup due to missing dependency

Note: This release has an issue causing an immediate crash on starting. As such, it has been pulled.

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

Features

• Added option to use ssh connections with ssh agent

Bug Fixes

• Fixed ssh private key connections for new open ssh format keys

Developer

Most of the changes were internal changes:

• Upgraded a few dependencies, the most important of them was the electron upgrade to the latest v12 version.
• Removed all remote calls and moved it to the browser process and communication between them is done with pure IPC calls.
• Added more test coverage, now we have e2e and unit tests for a few scenarios.
• The sqlectron-core module has been merged into this package to make development easier and faster, it still using sqlectron-db-core though for the database part.
• Started to convert the project to typescript
• Added inspect context button for development
• Converted a few components to pure functions and hooks

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

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

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

Fixes

• fix query results not re-rendering if field information did not change (#529) - by @MasterOdin
• fix opening select boxes changing modal top location (#530) - by @MasterOdin
• fix the open/save query functionality (#541) - by @MasterOdin

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

• 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

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

• Save button on settings modal sets isLoaded to undefined (#400) - by @alexmylonas
• Dark theme for body element (#384) (#401) - by @alexmylonas
• Password reveal, fixes #398 (#416) - by @synle
• Remove redundant text (#415) - by @synle
• Change zoom factor control to slider, fixes #413. (#414) - by @synle
• Fixes issue with newly created or duplicated items cannot be editted (#410) - by @synle
• Dark Theme Improvements (#408) - by @synle

• 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)

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

Improvements

• Allow searching database items by their schemas (#355) - by @rodrigowirth
• Grouping database items under schema dropdowns (#356) - by @s-kem
• Made resize span for database full height, changed cursor (#359) - by @s-kem
• Add settings modal (#358) - by @maxcnunes
• Make clear the Database and Schema is the initial one used in the conn (#360) - by @maxcnunes
• Print app version in the command line (caveats) (#362) - by @maxcnunes

Fixings

• Preventing each query tab from unmounting to persist state on tab-switch (#353) - by @s-kem

Improvements

• Use XDG basedir spec on linux #327

Fixed bugs

• Ignored passphrase for private key for SSH #331

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

Improvements

• Added open query from file option (#223)

Fix bugs

• Fix #296 - sidemenu resizing