React-DBGlass: PostgreSQL client built with Electron.

DBGlass

Code Quality

Simple cross-platform PostgreSQL client. Built with Electron, React, Redux, FixedDataTable.

Features

  • Straightforward and easy UI for creating, reading, updating and deleting your data without writing queries
  • Rich markdown editor for your text data
  • Simple constraint editor
  • Connect to through SSH tunnel using password of public key
  • Incredibly fast presentation of large tables

How To Use

You can either

Download Released App

Extract it somewhere, and then run the executable.

or

Package app manually from sources

To clone and run this repository you'll need Git and Node.js (which comes with npm) installed on your computer. From your command line:

# Clone this repository
git clone https://github.com/web-pal/dbglass
# Go into the repository
cd dbglass
# Install dependencies and run the app
npm install && npm run dev

App will be running in development mode at this point, in which you can:

Toggle Chrome DevTools
  • OS X: Cmd Alt I or F12
  • Linux: Ctrl Shift I or F12
  • Windows: Ctrl Shift I or F12

See electron-debug for more information.

Ignore default modules

We add some module's peerDependencies to ignore option as default for application size reduction.

  • babel-core is required by babel-loader and its size is ~19 MB
  • node-libs-browser is required by webpack and its size is ~3MB.

Note: If you want to use any above modules in runtime, for example: require('babel/register'), you should move them form devDependencies to dependencies.

Pack into an app for your platform from command line:
npm run package
Building windows apps from non-windows platforms

Please checkout Building windows apps from non-windows platforms.

License MIT

Comments

  • New version of DBGlass
    New version of DBGlass

    Apr 11, 2017

    Hi folks! We started to work on completely new version of DBGlass. We admit that previous version have a lot of architecture issues. Architecture will be more flexible with ability to plug other databases.

    New version will be rewritten using redux-saga, slice reducer composition approach, data normalizing and memorized selectors.

    Subscribe on this issue to be aware.

    Reply
  • CockroachDB?
    CockroachDB?

    Apr 12, 2017

    Thanks for the fantastic project!

    I'd love to see first-class support for CockroachDB. CockroachDB supports the PostgreSQL wire protocol, so it should be relatively simple to support.

    Reply
  • PKGBuild for arch?
    PKGBuild for arch?

    May 4, 2017

                                                                                                                                                                                                           
    Reply
  • [Question] Any plans to implement a custom query execution?
    [Question] Any plans to implement a custom query execution?

    Jul 31, 2017

                                                                                                                                                                                                           
    Reply
  • Loading indefinitely when using 'is not null' or 'is null' in the filters
    Loading indefinitely when using 'is not null' or 'is null' in the filters

    Aug 31, 2017

    Title says it all. I can't get any results using the is null and not null. I just get that huge 'Loading...'.

    Glass: Version 0.1.0-beta.6 (0.1.0-beta.6) PG 9

    Known issue?

    Reply
  • Repository field in package.json
    Repository field in package.json

    Sep 29, 2017

    Repository info added to remove npm warning.

    Reply
  • 'Private key' button does not respond
    'Private key' button does not respond

    Oct 11, 2016

    Trying to add a new connection, connecting via SSH, filled all the fields, but the button 'Private key' doesn't do anything. Is this an already known bug ?

    I'm on Mac OS X El Capitan.

    bug help wanted 
    Reply
  • Dark Theme
    Dark Theme

    Dec 7, 2016

    Would it be something that could make it to master a PR to add a dark theming option?

    Reply
  • escaping String based IDs
    escaping String based IDs

    Dec 19, 2016

    If the id of a row is a string, like UUID, then the query that's generated is not valid. It needs quotations around the id.

    Reply
  • Not Useful for Large Tables
    Not Useful for Large Tables

    Oct 11, 2016

    Loading the table data by default when clicking on one of my larger tables (700MB) caused DBGlass to be in the loading state for about 20 minutes. It was stuck running the query SELECT COUNT(*) FROM <tablename>. There should be an option to not show the total number of rows or first page of results default.. or an option to cancel the request during long loading transactions.

    enhancement help wanted large_tables 
    Reply
  • Support postgres scheme?
    Support postgres scheme?

    Oct 9, 2016

    Looks like application supports only public scheme right now.

    bug help wanted 
    Reply
  • Add to Homebrew Cask
    Add to Homebrew Cask

    Oct 11, 2016

    It would be helpful to MacOS users if we could install DBGlass with brew cask install dbglass

    https://caskroom.github.io/

    Thanks for this, it's beautiful!

    enhancement 
    Reply