sasha-alias / sqltabs Goto Github PK
View Code? Open in Web Editor NEWRich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)
Home Page: https://www.sqltabs.com
License: GNU General Public License v3.0
Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)
Home Page: https://www.sqltabs.com
License: GNU General Public License v3.0
The auto-complete could be helpful if we could select and validate an item.
Or is it possible yet ???
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.
Display SQL data type for each returned column (just under the coloumn name or via tooltip for example).
Thank you for this great tool !
Hi,
having some easy way of deleting items from connection list dropdown, without manually editing ~/.sqltabs/config
would be nice.
Thx
many tabs overflowing the screen width have to be displayed correctly
On master at da75db7 (post 0.12.2)
Steps to reproduce:
s
in EXISTS
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.)
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.
Supporting ssl connections would be nice.
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
No more "ORDER BY 1/2/3/etc" to write and SQL to re-execute, just click on the column to sort the data.
Please, report here any issues with building from sources.
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
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.
Version: 0.11.2
OS: Ubuntu utopic
How to reproduce:
It seams that:
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
The new tab button is not so far ! :)
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"?
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.
What do you think about brew?
Script output should display warnings and notices.
Waits for node-libpq support.
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)
Got an error on step 4 of the building instructions "gyp_main.py: error: no such option: --no-parallel"
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 !
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!
If ER Diagram support will be implemented it will be kill-feature of product itself. IMHO, of course.
Было бы логично отображать данные в 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.
Looks like electron doesn't support datalist tag. Either wait for fix or implement custom history dropdown.
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.
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';
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.