sqlectron-gui

A simple and lightweight SQL client desktop with cross database and platform support.

MIT License

Stars
4.5K
sqlectron-gui -

Published by maxcnunes over 7 years ago

  • Fallback for rowCount to PG 8.x - by @jleclanche
  • Use a File Path Dialogue Window to add a local Database for SQLite (#325) - by @WFrsh
sqlectron-gui - 1.21.0

Published by maxcnunes over 7 years ago

Improvements

  • Improve security by encrypting passwords on ~/.sqlectron.json

Fix bugs

  • Fix #313 - executingQueries[queryId].execute is not a function
  • Fix #306 - An error dialog is displayed when user presses super+w and no window exists
  • Add missing custom configuration for auto complete
sqlectron-gui - v1.20.2

Published by maxcnunes over 7 years ago

Fixed Bugs

  • Fix custom server filter been removed on editing the server
  • Include windows support build with 7z and zip
sqlectron-gui - v1.20.1

Published by maxcnunes over 7 years ago

Fixed Bugs

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

Published by maxcnunes over 7 years ago

New Features/Improvements

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
sqlectron-gui -

Published by maxcnunes almost 8 years ago

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

PS: Remove build for 32bit for while - https://github.com/sqlectron/sqlectron-gui/commit/a257c5296bf6db506743ae2971b69ca4a8d21918

{
  // Changes the zoom factor to the specified factor. 
  // Zoom factor is zoom percent divided by 100, so 300% = 3.0.
  // https://github.com/electron/electron/blob/master/docs/api/web-frame.md#webframesetzoomfactorfactor
  "zoomFactor": 1, 

  // Change the limit used in the default select
  "limitQueryDefaultSelectTop": 100,

  // List of servers
  "servers": [
    {
      // Now is possible add a filter property that will load only 
      // the data is useful in the sidebar.
      // Is only possible to filter "database" and "schema". 
      // It accept the filter types: "only" and "ignore".
      "filter": {
        "database": {
          "only": [
            "company"
          ]
        },
        "schema": {
          "ignore": [
            "pg_catalog",
            "pg_temp_1"
          ]
        }
      },
      "id": "651abe80-ed50-44a1-b778-1bdfe97b0bec",
      "name": "sqlectron-localhost",
      "client": "postgresql",
      ...
    }
  ]
}
sqlectron-gui -

Published by maxcnunes almost 8 years ago

New Features/Improvements

  • Add support for listing indexes - (by @felipetoffolo1)

Fixed Bugs

  • Fix devtools shortcut - (by @vmitchell85)
  • Fix connection problem with old PG versions
sqlectron-gui -

Published by maxcnunes almost 8 years ago

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

  • Attempt to fix #264
sqlectron-gui -

Published by maxcnunes about 8 years ago

New Features/Improvements

  • Replace the database name by the Connection name with the DB logo (by @eMerzh)
  • Display ssh configuration only if checked to unclutter the screen (#222) (by @eMerzh)
  • Add visual distinction to indicate if there are items below (#237) (by @eMerzh)
  • Change disconnect icon to poweroff (#240) (by @eMerzh)
  • Add new tab button (#244) (by @eMerzh)
  • Add 'via' in the server list to make distinction with ssh (#245) (by @eMerzh)
  • Allow press 'escape' to exit modal. (#248) (by @eMerzh)
  • Allow press 'enter' to submit promp modal like passphrase and all (#249) (by @eMerzh)
  • 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 (by @eMerzh)
  • Avoid enabling the "test" connection if no db type is selected (by @eMerzh)
  • Fix warning about null input and fix style (#231) (by @eMerzh)
  • Fix closing connection for a test connection (#232) (by @eMerzh)
  • Add refresh for views when refreshing the database (#230) (by @eMerzh)
  • Style fix trying to unblur retina render. ref #191 (#225) (by @eMerzh)
  • Server can be saved now without a password or user (#256) (by @vkolmakov)
  • Fix problem wiping part of the query (close #234)
  • 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 https://github.com/sqlectron/sqlectron-gui/issues/252 I'm releasing it as it is so we can get some feedback.

sqlectron-gui -

Published by maxcnunes about 8 years ago

  • Add meaningful names to tabs (#214)

Instead of naming File Query <id>. It now will follow the this pattern:

[db: <database_name>][tb: <table_name>] #<query_id>

Example:

[db: game][tb: question] #4
sqlectron-gui -

Published by maxcnunes about 8 years ago

  • Add support to show EXPLAIN command result for PG
sqlectron-gui -

Published by maxcnunes about 8 years ago

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

sqlectron-gui -

Published by maxcnunes over 8 years ago

  • Use custom scrollbars #208
  • Fix window title name
sqlectron-gui -

Published by maxcnunes over 8 years ago

Fixed

  • Unnecessary scrolling on query results #207
sqlectron-gui -

Published by maxcnunes over 8 years ago

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

Published by maxcnunes over 8 years ago

sqlectron-gui -

Published by maxcnunes over 8 years ago

Fixed

  • Fix problem rendering results without rows
sqlectron-gui -

Published by maxcnunes over 8 years ago

New Features/Improvements

  • Improve perfomance rendering large results #180 - by @ghedwards πŸ‘ πŸ‘ πŸ‘ πŸ‘
sqlectron-gui - v1.10.0

Published by maxcnunes over 8 years ago

New Features/Improvements

  • Generate diagram from tables @BornaP πŸŽ‰
    • Save diagram to file
    • Open diagram from file
    • Export diagram to png and jpeg format
  • Add installer support for more Linux distros (Not sure if all installers are working. Please, let me know).

Fixed Bugs

  • Fix typo (#196) @fdaciuk
  • Fix #190 - Scroll bar over table with single row
sqlectron-gui -

Published by maxcnunes over 8 years ago

New Features/Improvements

  • Create Slack channel Slack Status
  • Add support to increase/decrease font-size @krolow
  • Add context menu to database items @BornaP
  • Add SQL object definition and scripts for tables and views @BornaP
  • Add preview routine SQL definition @BornaP
  • Add search databases and search database objects keyboard shortcuts @BornaP
  • Add a installer spinner gif on Windows to replace the default one
  • Add support to close tab with shortcut (close #89)
  • Improve UX for opening and collapsing a database (close #133)
  • Add support to select current line (close #147)
  • Add support to disable the live auto complete
  • Add link to docs of keyboard shortcuts (close #150)
  • Do not quit the application on Mac on closing the last window (close #151)
  • Force the whole database item be clickable
  • Allow connect/collapse the DB clicking only once in the collapse icon
  • Add support to auto refresh dbs and tables
  • Add refresh database button
  • Configure editor search
  • Add shortcut to focus the query editor
  • Replace paging results with scroll
  • Add support for private key passphrase
  • Improve NULL cell style
  • Add modal to show the cell content preview
  • Show result columns with max 220px
  • Improve splash screen
  • Avoid cast DB types to native JS Date Objects (Mysql and PG)

Fixed Bugs

  • Fix when connecting in local and trying to reach ssh settings (#183) @eMerzh
  • Fix when click in cancel while saving a query @krolow
  • Fixed - update SQL editor on selecting already fetched script @BornaP
  • Resolves #126 - fix table rows scaling long texts @BornaP
  • Duct taping to get rid of annoying ResizableBox console error @BornaP
  • Fix problem of rendering multiple unknown columns
  • Fix problem not rendering null values
  • Fix problem duplicating completions (close #135)
  • Fix test connection

Important: In this release I have included only the app with 64 bit support. Please let me know if anyone need it with 32 bit support.

This release took so long to be ready because we had problems with the build process. There is so much we have done in this time that I probably have not included everything in the release notes. Thanks for all those who are using the app and have contributed to the project somehow.

Package Rankings
Top 6.67% on Proxy.golang.org
Badges
Extracted from project README
Slack Status Build