web-pal/dbglass

PostgreSQL client built with Electron.

dbglass's Issues

Connection with SSL

Looks like currently SSL connections doesn't work.

not able to create more than one connection

I'm trying to create a new connection to a different database that the one I had as favorites but it keeps connecting to the existing one.

Version 0.1.0-beta.6 (0.1.0-beta.6)
OS X 10.11.6

Doesn't work with no password user

Password is compulsory in the login screen, but my (localhost) user has none. I know it's bad, except it's the default with Postres.app - I'm probably not the only one with the issue.

Add to Homebrew Cask

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!

Full immutable support

We need implement full immutable support

Ability to run custom queries

Having the ability to build an run my own custom SQL query (with the option to cancel long running requests) would make this tool a powerful replacement to the current tools I use.

PKGBuild for arch?

[Question] Any plans to implement a filter in the side table listing?

escaping String based IDs

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.

publish npm package?

it looks like it already requires npm to build / run. So, for ease of installation, I think doing npm install db-glass would be super helpful :-)

Not Useful for Large Tables

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.

Problem with concurrently --kill-others "npm run hot-server" "npm run start-hot"

Hello there, I'm trying to build the app from source but I'm having this issue when running

npm run dev
Problem with concurrently --kill-others "npm run hot-server" "npm run start-hot"

Here is the info at npm-debug.log:

0 info it worked if it ends with ok
1 verbose cli [ '/usr/local/bin/node', '/usr/local/bin/npm', 'run', 'dev' ]
2 info using [email protected]
3 info using [email protected]
4 verbose run-script [ 'predev', 'dev', 'postdev' ]
5 info lifecycle [email protected]~predev: [email protected]
6 silly lifecycle [email protected]~predev: no script for predev, continuing
7 info lifecycle [email protected]~dev: [email protected]
8 verbose lifecycle [email protected]~dev: unsafe-perm in lifecycle true
9 verbose lifecycle [email protected]~dev: PATH: /usr/local/lib/node_modules/npm/bin/node-gyp-bin:/Users/taniadaniela/DBGlass/node_modules/.bin:/Users/taniadaniela/.rvm/gems/ruby-2.3.0/bin:/Users/taniadaniela/.rvm/gems/ruby-2.3.0@global/bin:/Users/taniadaniela/.rvm/rubies/ruby-2.3.0/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/X11/bin:/Users/taniadaniela/.rvm/bin:/Users/taniadaniela/.rvm/bin:/Applications/Postgres.app/Contents/Versions/latest/bin:/usr/local/sbin:/usr/local/git/bin:/usr/local/bin
10 verbose lifecycle [email protected]~dev: CWD: /Users/taniadaniela/DBGlass
11 silly lifecycle [email protected]~dev: Args: [ '-c',
11 silly lifecycle   'concurrently --kill-others "npm run hot-server" "npm run start-hot"' ]
12 info lifecycle [email protected]~dev: Failed to exec dev script
13 verbose stack Error: [email protected] dev: `concurrently --kill-others "npm run hot-server" "npm run start-hot"`
13 verbose stack spawn ENOENT
13 verbose stack     at ChildProcess.<anonymous> (/usr/local/lib/node_modules/npm/lib/utils/spawn.js:33:16)
13 verbose stack     at emitTwo (events.js:106:13)
13 verbose stack     at ChildProcess.emit (events.js:191:7)
13 verbose stack     at maybeClose (internal/child_process.js:877:16)
13 verbose stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:226:5)
14 verbose pkgid [email protected]
15 verbose cwd /Users/taniadaniela/DBGlass
16 error Darwin 15.6.0
17 error argv "/usr/local/bin/node" "/usr/local/bin/npm" "run" "dev"
18 error node v6.9.1
19 error npm  v4.0.2
20 error file sh
21 error code ELIFECYCLE
22 error errno ENOENT
23 error syscall spawn
24 error [email protected] dev: `concurrently --kill-others "npm run hot-server" "npm run start-hot"`
24 error spawn ENOENT
25 error Failed at the [email protected] dev script 'concurrently --kill-others "npm run hot-server" "npm run start-hot"'.
25 error Make sure you have the latest version of node.js and npm installed.
25 error If you do, this is most likely a problem with the DBGlass package,
25 error not with npm itself.
25 error Tell the author that this fails on your system:
25 error     concurrently --kill-others "npm run hot-server" "npm run start-hot"
25 error You can get information on how to open an issue for this project with:
25 error     npm bugs DBGlass
25 error Or if that isn't available, you can get their info via:
25 error     npm owner ls DBGlass
25 error There is likely additional logging output above.
26 verbose exit [ 1, true ]

Any ideas? thanks..

ssh tunnel connects to port 5433 by default

... at least in my case. When working on a manually created tunnel, it works.

cmd+t prompt for truncating table

cmd-t shouldn't be mapped to truncate table. I think it's to dangerous to be mapped there. Since cmd-t is usually used for tabs. I'm ok with just right-click then click trucate to do so.

Tables with many columns

Opened table in database which has many columns and I find it hard to see all columns.You have to use mouse or arrow keys to navigate.I suggest adding some kind of zoom(Ctrl + scroll for example) or some other solution to it.
Keep up good work, I'd like to use this in future

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

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?

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

cmd+s to confirm save

In the same way Undo works with cmd+u when I'm done making changes it would be nice to be able to confirm my changes pressing cmd+s as the shortcut for clicking save button:

Update with character "["

I can't update a row when there is a column that contains the character "[".
This only happen when you have a table with no primary key
Table exemple:

And this is the result when i try to change any column:

As I can see, if you create a new table and add a column with that character and then updates another column it works, but if you change the table and return to the table, when you try to update the column it will give you the error.

This also happens when you put the character in any position of the text

CockroachDB?

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.

Empty password

Allow for an empty password (ie: localhost connection)

SO MANY ISSUES WITH THIS APP!!

So many issues! If you change the name of the table then it does not change the name of the relation. Most of the time it crashes while opening a table. The UI is not intuitive and there is no refresh button to update the table rows.

'Private key' button does not respond

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.

Date field data represented by {} (Postgres)

I haven't tried other databases, but when using Postgres, data in a field of type 'date' isn't displayed. Instead it is represented by '{}'.

Wrong item count on the last page

Page 6:

Page 7(last and with error)

Change database on same connection

The idea is to choose from your list of databases in the current connection (similar to current connection click dropdown with favorites appear)

Quick (and ugly) preview of what I'm saying:

It don't have to be like that but that's the feature I'd like.

Thanks

The server does not support SSL connections

I'm having this issue even when connect via ssh is off.
Version 0.1.0-beta.3 (0.1.0-beta.3)

Support postgres scheme?

Looks like application supports only public scheme right now.

New version of DBGlass

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.

Support for other database types

Hey, really awesome job on this project! A few months ago I started working on the same idea with dataface. I didn't get as far as you did, and frankly I'm glad this came out so that I don't need to! One feature I was excited about, though, was support for multiple database types, primarily leveraging knex.js for query building. Knex doesn't quite do everything, but my plan was to use basic class inheritance to write DB-specific queries for things that knex didn't support. Here's what I mean.

Any thoughts about supporting more database types?

Unable to DROP table

Hello,

Using the MAC OS10.12.3 desktop app, DBGlass beta6

When I have a n:m relation through a third table, I am not able to delete any of the three tables involved in the association.

No error or message displayed.

Create command for generating test databases

We need to have ability to generate test database with different schemas and rows

Dark Theme

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

Drop/truncate table not working

Open connection,

on tables view, right click and "drop table" or truncate table

observe popup, that asks if you are sure. click to positive button.

a new pop up for delete/clone row shows up (this is the same as if you alt click on a record)

I think the alt click is sticking, and when you click the confirmation popup, it is assuming you are clicking on a record.

Deb package

A debian package would be nice for install. the tar is not difficult its just binding and add icons to distinguish is a pain to do manually.