If a schema name has lower and upper case letters, the objects (tables) are not found. The schema name should be escaped with double quotes before being used in queries, I think.

Hi!
I found issue, that materialized view is not showing in database info page.
Can you fix it pls.

I think it's because information_scheme doesn't contain information about it, but it's possible to get this list using following query:

SELECT oid::regclass::text
FROM   pg_class
WHERE  relkind = 'm';

Example what i saw now:

and what i got using upper select:

It is common for production DBs to not be open to outside connections. Normally, this is handled by SSHing into a server which can connect to the DB and then proxying through that way. Would be really useful for SQLTabs to support this.

For example, see this screenshot taken from another PG GUI:

Got an error on step 4 of the building instructions "gyp_main.py: error: no such option: --no-parallel"

• Open file in editor
• Save file
• File menu

I'm using intensively temp tables and I like to run each query step by step (block by block ;)) but the connexion is close after each run and all my temp tables are lost...

It woul be great to keep the connexion open !

I can't determine exactly when but sometimes the app freeze (I'm navigating in SQL code using my keyboard and cursor can't move). 100% of the CPU is used !
How can I give you more info (logs, ... ?).

Hi!

From time to time system show following error when i try to open saved connection from the list:

Error: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

When I execute queries that return many rows, it would be nice if the column headings stayed visible as I scrolled down. This is particularly relevant when you've got multiple foreign keys right next to each other, as it can be hard to remember which particular integer you're interested in without scrolling back to the top.

N.B. Thanks for a slick, lightweight, fast alternative to pgAdmin3!

It would be nice having intermediate font size betweenSmall and X-Small :

Было бы логично отображать данные в JSON полях в PostgreSQL отформатированными и с подсветкой синтаксиса, а не просто текстом, как сейчас.

It seems logical to show JSON fields' data in PostgreSQL formatted and with highlighted syntax, not as plain text as it is now.

Hi,

having some easy way of deleting items from connection list dropdown, without manually editing ~/.sqltabs/config would be nice.

Thx

If I have more than one chart block in my SQLTabs script and then choose "Execute All Blocks" from the menu then the ensuing charts do not show up. Each chart shows perfectly well when executing individually using "Execute Block".

Here is my example code. Any chart after the "Number of Requests" chart does not show up.

--- chart donut
/**
## Number of Requests
**/
SELECT label,count FROM metrics;

--- chart donut
/**
## Median Request Time
**/
SELECT label,median FROM metrics;

--- chart pie
/**
## Average Request Time
**/
SELECT label,avg FROM metrics;

I have also seen that the data displayed in the initial chart is sometimes corrupted when using "Execute All Blocks"; however, it is hard to pinpoint which cases that happens in. This is occurring in 0.12.2 and was seen in 0.12.1 as well.

Looks like electron doesn't support datalist tag. Either wait for fix or implement custom history dropdown.

Hi there,

I really love sql Tabs. However, I want to share viszualisations of customer sensitive data with it. Is there a possibility to easily set up an own share server.

Hi!

It will be nice to have possibility to choose element in autoselect window also using arrows, not only Tab.

Version: 0.11.2
OS: Ubuntu utopic

How to reproduce:

• click "Database Info"
• wait a while
• click "public"
• error occures
• click "Database Info"
• error still occures
• click ctrl+e (any query)
• query executes correctly
• click "Database Info"
• no error

It seams that:

• clicking on "public" schema breaks connection for some reason.
• clicking "Database Info" never reconnects to valid state
• executing any valid query reconnects to valid state.

It would be great to have support for formatting SQL statements.
There are some ATOM formatter plugins that could be adapted to sqltabs:
JS: https://atom.io/packages/atom-beautify
JS: https://atom.io/packages/format-sql
JS: https://github.com/diesire/atom-oracle-format

Command+D (Ctrl+D) should detect an current object in the editor, run queries to detect and object type and display a corresponding object description, i.e. table structure, function description and similar.

On OS X at da75db7.

After the Save As dialog completes, no file is saved. I've noticed this problem in 0.12.2 as well.

• Execute selected only
• Execute single (current?) statement

On master at da75db7 (post 0.12.2)

Steps to reproduce:

1. Put cursor over the character s in EXISTS
2. type rspace

result should be EXIST, but it's now EXISTspace.

(It might be worth trying to incorporate the vim-emulation from Atom's vim-mode rather than trying to chase down Vim's extremely complicated corner-cases.)

• Command+W - close tab
• Command+T - new tab

Hi, is there any way to specify connection string using socket?

I tried:

postgresql:///piotrek?host=/var/run/postgresql&user=piotrek

error: Error: FATAL: database "//piotrek" does not exist

and

host=/var/run/postgresql user=piotrek dbname=piotrek

error: Error: could not translate host name "host" to address: Name or service not known

I looked here: http://www.postgresql.org/docs/9.2/static/libpq-connect.html (31.1.1. Connection Strings)

Supporting ssl connections would be nice.

What do you think about brew?

The auto-complete could be helpful if we could select and validate an item.
Or is it possible yet ???

Display SQL data type for each returned column (just under the coloumn name or via tooltip for example).

Thank you for this great tool !

Script output should display warnings and notices.
Waits for node-libpq support.

many tabs overflowing the screen width have to be displayed correctly

Hi,

sqltabs seems pretty awesome, are you planning on adding a Windows version?
Github is lacking a way to ask questions other than by creating an issue :D

• as an alternative to share (that posts data to "third party" without asking 👎
• to local file
• ability to set quoting, line feeds and separator would be nice but not a must.

If ER Diagram support will be implemented it will be kill-feature of product itself. IMHO, of course.

i get this when i run "electron ."

[10282:1229/111606:ERROR:browser_main_loop.cc(173)] Running without the SUID sandbox! See https://code.google.com/p/chromium/wiki/LinuxSUIDSandboxDevelopment for more information on developing with the sandbox on.
[10322:1229/111611:INFO:renderer_main.cc(200)] Renderer process started
null
[10282:1229/111614:INFO:CONSOLE(109)] "Download the React DevTools for a better development experience: https://fb.me/react-devtools", source: /home/marwan/sqltabs/node_modules/react/lib/React.js (109)
[10282:1229/111615:INFO:CONSOLE(83)] "Uncaught Error: Module did not self-register.", source: /home/marwan/sqltabs/node_modules/libpq/node_modules/bindings/bindings.js (83)

and the application just opens in an empty window

Please, report here any issues with building from sources.

The new tab button is not so far ! :)

When table has many columns that do not fit window width vertical scroll bar is not visible. It is half-visible when I change font size to small. Window is full screen. I'm using linux mint 17.2. Screenshots below.

No more "ORDER BY 1/2/3/etc" to write and SQL to re-execute, just click on the column to sort the data.