There doesn't seem to be any PopSQL users around here so I'll share my experience with it.<p>Currently, we're a team of 5 on a paid plan and we're loving the tool. We mainly use it to:<p>- Share queries to extract some kind of data from our databases
- Quickly run queries to answer a quick question
- My favorite use case: We create queries around bugs we've noticed in our data. We add "TODO:" in front of the query's name. We'll then move the query to a "Done" folder once we get the expected result.
Other solutions in the `write sql and share the graphs with your team`-space:<p>- ChartIO<p>- 'WagonHQ, Modern SQL Editor' [1] (now aquired by Box)<p>- MetaBase [2,3]<p>- Redash [4]<p>MetaBase is the only one that I know of that is<p>- fully open source,<p>- mature (graphing options, permission model),<p>- still actively maintained, and<p>- both friendly to non-technical users and expert sql'ers alike<p>[1] <a href="https://news.ycombinator.com/item?id=9792464" rel="nofollow">https://news.ycombinator.com/item?id=9792464</a><p>[2] <a href="http://www.metabase.com" rel="nofollow">http://www.metabase.com</a>
[3] <a href="https://news.ycombinator.com/item?id=10425959" rel="nofollow">https://news.ycombinator.com/item?id=10425959</a><p>[4] <a href="https://redash.io" rel="nofollow">https://redash.io</a>
Or, we could just go all meta, in a Postgres shell:<p><pre><code> CREATE TABLE queries IF NOT EXISTS (
name varchar(64),
version varchar(64),
query text,
description text
);
NOTIFY chat 'Alice: Bob, please insert that query into the new queries table, and then NOTIFY "chat" with the name and version of it';
LISTEN chat;
Asynchronous notification "chat" with payload "Bob: See update-rank, v. borked-1" received from server process with PID 8448.
Asynchronous notification "chat" with payload "Bob: I have it set to update in a temp table, so we don't have to reset the real table" received from server process with PID 8448.
SELECT queries.query FROM queries WHERE name="update-rank" AND version="borked-1"
INTO query;
\echo query
-- "Looks sane, let's run it"
DO $$ EXECUTE query INTO result $$; -- Something like that, I'm guessing.
\echo result
</code></pre>
PL/PgSQL's EXECUTE is not to be confused with the EXECUTE that is used with stored procedures.<p>Bonus points if you edit the query by shelling out to sed or butterflies.
I like the GUI, I like the landing page, I like the fact that it has native versions for the 3 main platforms... Congratulations for the team or person behind this! Great work
Postgres user here. pgadmin4 lead me to try alternative clients. Recently, I've found DBeaver useful. I'd give popsql a try if it didn't require google account information.
It's fine to require people to pay for your software. I still think it's a good idea to release at least a basic demo version as open source though. With close binary blobs for all I know it could upload all my personal files or delete them for good, drop all database tables, install a backdoor, etc. I don't trust random people on the Internet to run their code on my computer.
Please add Oracle support when you have an opportunity (I was going to give it a quick try, but unfortunately it doesn't appear to have support for Oracle just yet and that's the primary database our internal systems run off of).
Being an electron app, can anyone tell me how it behaves when viewing 200, 400, records at a time? I attempted to open PopSQL but I don't really want to sign up for an account just to try the thing out.<p>I tried out TeamSQL a while back and it choked pretty hard at about 250.
Just tried this out<p>- Chart is greyed out on my data. Why is that?<p>- Can I provide parameters (such as a date) in the query that can be changed by whoever wants to run a report? I can't see how to do this.<p>- Can I publish this as a dashboard that can be used by non-technical team members?
"Stop emailing SQL queries or pasting them in chat"<p>Hunh you don't you put your queries in sprocs and store that in the data base and your source control system of choice.<p>Soory I don't see what problem this product is for apart from maybe enabling sub optimal coding practices